Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by HampasLOUpa

  1. HampasLOUpa

    Adding Emoji

    Can emojis be added in a DataPage? I just want to add some emojis to my DataPage. I wonder if this is possible.
  2. How can I export a DataPage with all the table/view and data connected to it?
  3. I have a Details Report DataPage on the Destination and Messaging of the DataPage. I want it to display the message first, then close the DataPage.
  4. Hi, I tried using it and the randomizer worked. However, the problem here is that all it gives me a name that was previously called. I think this needs further code to limit the randomly selected data. Thanks!
  5. I'm planning to create some sort of a randomizer app. I want my DataPage to randomly select a name from a field in my table. Any idea to do this?
  6. Does creating 100 DataPages affects my storage count?
  7. I think those are also called snap back up and is designed for up to 30 changes but if it's ways past that, the best option is to contact support. I think they may be able to like provide you an option to recover on a wider scale. But of course, there's a fee. Cheers!
  8. That's one of the annoying things about rules, the "You can only use a field once." Though you can add the field/s to a section. When you do that you are giving yourself another way to select that field. Let say you have Field1 and you put it under Section 1. Then you can choose Section 1 for the first rule and the Field1 for the second rule or so. Just saying. Cheers!
  9. Hi, This is quite a challenge to achieve since the Gantt Chart is not yet a standard feature of Caspio. You can try using a Horizontal Bar Graph like this: Then have it configured to accept completed task or so. This is how the table of this looks like by the way. Hope this helps. Thanks!
  10. Are all Caspio accounts PCI compliant?
  11. This is correct. For example. Your Formula Field 1 has this formula: [@field:First_Name] +' '+ [@field:Last_Name] and then your Formula Field 2 has this formula: [@field:Balance] + [@field:Current_Amount] - [@field:Amount_Paid] and you want your output to be like this: "Jolli Beng balance is $50" You can put all those formula in one field. It should look like this: [@field:First_Name] +' '+ [@field:Last_Name] +' balance is '+ ([@field:Balance] + [@field:Current_Amount] - [@field:Amount_Paid]) Note: To do this, make sure that the names have the same Data Type otherwise, you should use Cast or Convert to change the Data Types.
  12. If I'm correct, you have applications on both Weebly and Caspio. Well, the thing is double login will definitely be unavoidable in this as those are two different platforms. I would suggest that you use Weebly only to host Caspio's Applications thus avoiding the double logins. Now, I'm not an expert but if what you want is a dashboard for each of your user, There are features like RLS, User-Specific Redirects in Caspio for that. One example of that is this: https://www.youtube.com/watch?v=lBBs6PXniqQ. You should see this article that they have about User-Specific Redirects as well: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/
  13. We are starting to experience a lag in entering Data into our tables. I am thinking of optimizing my tables by doing Database Re-indexing, is this possible in Caspio?
  14. I want to filter a dropdown based on the on the authentication but I want to show all values in the dropdown when that filtering field is admin.
  15. Hi, If the the fields are from two different tables, you do need to create a relationship for you to be able to pull those data. Here are the steps: 1. Create a relationship between the tblWashInfo and tblTrailer. To do that, you must have a field that is similar to both tables. Let's assume that the similar field is "license plate number". You may want to visit the following links first. Online Help Center: https://howto.caspio.com/tables-and-views/relationships Create a One-to-Many Relationship — Child Forms and Child Reports in Caspio: https://www.youtube.com/watch?v=sgIaAeZxmy8 Database Relationships (Part 1 of 3) - Data Normalization: https://www.youtube.com/watch?v=oexOYUUyQik Database Relationships (Part 2 of 3) - One-to-Many Relationships: https://www.youtube.com/watch?v=IstAk982ntA 2. After creating the relationship, the next thing to do is to create your view. Just follow the instructions on how to create a view in this link: https://howto.caspio.com/tables-and-views/what-are-views/ 3. If you are using a Report DataPage, then you just have to use it as the Data Source. 4. If you are using Submission DataPage, then use a cascading element . Please see Cascading Element articles here: https://howto.caspio.com/datapages/datapage-components/cascading-elements/
  16. Hi, Search forms in a Report DataPage work like this: If you don't enter any criteria and hit the search button, it will give you all the records you have as long as the Logic in the "Configure Search Fields" is set to "OR". In you case, you can use radio button as your search element. Then as mentioned above, change the logic to OR. Then add "Any" to the option, remove the value for the "Any" option. I wouldn't recommend Checkbox unless Obedience and Rally Fields in your table. Hope this helps!
  17. Hi, In this option that I will give you, I am assuming that you are using "AutoComplete" type of form element for your Customer Name Field. What you can do here is create a submission form to add new customer information (Let's call it Add New Customer DataPage). Then, in the Destination and Email - Destination after record submit, you can choose "Close Window" and then click the Source in the editor paste this code: <script> alert("New customer has been added!"); setTimeout(function () { win.close();}, 2000); </script> This code is to give you an alert message and close the form after 2 seconds. In your original input form, if you have set the "Customer Name" field as AutoComplete, you should not be able to receive any suggested name if the name is not yet on the list, right? If so, add an HTML Block after the "Customer Name" field. Click the Source and then Paste this code: <a href="DEPLOYMENT CODE OF ADD NEW CUSTOMER DATAPAGE" onclick="window.open(this.href, '', 'resizable=no,status=no,location=no,toolbar=no,menubar=no,fullscreen=no,scrollbars=no,dependent=no,width=200(DEPENDS ON YOU PREFERENCE),height=200')(DEPENDS ON YOU PREFERENCE); return false;">Add New Customer</a> This link goes to the "Add New Customer" DataPage. After filling the "Add New Customer" with the new customer details, you should be able to see the new customer name when you type it in the "Customer Name" field. This should address the function that you want. **I do have some suggestion for you though. **Customer name is not really a good field to use in identifying customers/records because this not a unique record. What I would suggest is to use email address, ID or other information unique to your customer/data. **You can also make your fields Cascading Element (https://howto.caspio.com/datapages/datapage-components/cascading-elements/) so that when you enter say an email address, your customer name or any other field associated to the email address can become autocomplete. This add mores integrity and control in your data input and records. Hope this helps!
  18. Hi, I think you have configured the dropdown to display the employee id instead of the name. For the below example, I set the "Field for display" the exact field that I want to see in the dropdown menu. In your case, check what field did you set for display. If you set the employee id as the field for display, then simply change it to the employee name field. I hope this helps. Thank you!
  19. Hi, Selecting the " Filter data based on your pre-defined criteria" will give you the option to automatically display report data based on your pre-defined value. For example, you can use paramater value as your criteria, or filter using definite values. Please refer to this link for more information: https://howto.caspio.com/parameters/tech-tip-custom-filter-elements/
  20. In addition to what TWIRED said, you also would need the following: General HTML Knowledge - There will definitely a time where you will need to create your own tables, do hyperlinks etc. In depth knowledge about Database - Caspio is technically an Online Database Application Platform so a strong and working (not theoretical) knowledge about Database would be ideal. Ability to learn - Well Caspio is like new way of developing, so best get someone who can easily learn. Most importantly - PATIENCE, PATIENCE, PATIENCE. - Caspio will require all it's users to be patient with everything. Well at least from my experience, that's about everything you will need.
  21. Hi, You can upload most type of files such as documents, spreadsheet and images and most especially the most common sql file formats . You can also upload videos and music but can't be played. Since I think they don't have a player for that. These medias are treated as general files. Hope this helps.
  22. Well as for me. It worked. I was able to use the date to filter my report. My date is also a formula field. I also used "Full Name" field which is also a formula field. You can use Calculated field though. Hope this helps.
  23. Hi, If you want this to happen in a DataPage level, you will need to write a several codes for that. It's possible but kinda tricky. Some can be complicated though, so if you're not a hardcore web developer/programmer, you will definitely have hard times figuring it out (but if you wan to try you can see these links though: https://www.codeproject.com/Questions/785941/How-to-send-email-in-HTML-using-javascript , https://www.smtpjs.com/ , https://stackoverflow.com/questions/48283396/sending-email-from-javascript-with-smtp-server , try also googling other links/tutorials). There is another way to do that.It's a bit different to what you want but I think I will do. As I was exploring Caspio Bridge, I saw this Triggered Action functionality. It works in the Table/Database level. When there is an activity in your Table, say you updated a value of a field, you can select several options like send SMS, Email or even populate another table. This is also a bit tricky to configure but as per my experience, Caspio offers wide range of support, How-To, video tutorials and Online Training. Try these links : https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Thanks.
  24. Is there a way to change these data types without having to start all over again? This bugs me so thank you for any answer.
  • Create New...