Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


HampasLOUpa last won the day on December 4 2018

HampasLOUpa had the most liked content!

1 Follower

About HampasLOUpa

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. HampasLOUpa

    Randomly choose a data from a field.

    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?
  2. HampasLOUpa


    Does creating 100 DataPages affects my storage count?
  3. HampasLOUpa

    Retrieve/recover those changes?

    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!
  4. HampasLOUpa

    Rule Help

    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!
  5. HampasLOUpa

    Setting up Charts

    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!
  6. HampasLOUpa

    PCI Compliance

    Are all Caspio accounts PCI compliant?
  7. HampasLOUpa

    Formula field in another formula field.

    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.
  8. 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/
  9. HampasLOUpa

    Database Reindexing

    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?
  10. HampasLOUpa

    Filter dropdown based on criteria.

    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.
  11. HampasLOUpa

    Relationship not working

    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/
  12. HampasLOUpa

    Search to include one or both options

    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!
  13. HampasLOUpa

    if autofill data not present, trigger new form entry

    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!
  14. HampasLOUpa

    Using a View for a dropdown lookup

    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!
  15. Hi, You may want to see this video tutorial about RLS. I think this might help you.