Jump to content


  • Content count

  • Joined

  • Last visited

  1. Date Range Prompt /Filter

    Hi Bill, Instead of 'Next X Days' or 'Previous X Days', try 'Greater than' for first criteria and 'Less than' for second criteria. That way you will get all the records within those dates. Regards,
  2. Bulk File Delete

    Try deleting them in a different browser. If that doesn't work, please attach some screenshots of steps that you took to delete the data.
  3. Hello Billy, You can add the following and try: <script> document.getElementsByName("cbParamVirtual1")[0].selectedIndex.text; document.getElementsByName("cbParamVirtual1")[0].value = "2012"; </script>
  4. Multi-Select Listbox and Conditional Logic

    Hi, Sorry to say that Rules do not work with List-String DataTypes. That is a current limitation of Caspio. One workaround for your issue would be to convert currentAssign field into a text box and change it to a dropdown form element in the DataPage. Or, if you know JavaScript, create a Virtual field in your DataPage and assign the value of currentAssign to this Virtual field. Rules can be applied to Virtual field just like you would for any other DataTypes. Hope that helps.
  5. Hi Tanager, In both of your triggers where Scale is set to either Regional or Local, you are counting inserted values in the Having condition. This value is never going to be more than 3 because it is being compared to only 1 inserted value. In case of less than 3, it is updating always since the inserted value is always going to be 1, which is less than 3. So, to fix this issue, join both inserted and the table values. Then it updates the data correctly. Also, since you want to run this action when delete happens too, you should compare it with deleted table also. I created one update with the deleted table. You can create the second one following the same example. Hope this helps.
  6. Hi Youssik, Following is a video on how to integrate Zapier with MailChimp. https://www.youtube.com/watch?v=fPUJFy4VElg&feature=youtu.be Also, here is the Caspio link on Zapier: https://howto.caspio.com/integration/zapier/ Hope this helps.
  7. Hello James, It is not possible for a trigger to insert a new record in customer billing table since the tables are related by many to one, meaning many records with same customer name in the order table and only record to be created of that name in the billing table. By changing the design of the table, this can be achieved. Please see below screenshots of the table design and the trigger that I could implement by making this change. Hope this helps.