Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by BaySunshine

  1. Hi Magnum, The value 'true' for MngrNotesChk may not be inserted as the light pink true field is just like a placeholder. Click on the Logic or Data button on the left and drag a 'true' field and place it in here. It should then work. Apart from this, I don't see any other issue with the trigger. A full screenshot of the trigger will help us in reviewing it better. Regards,
  2. Hello, Can you please provide more details on your question? What is the type of DataPage you used? Have you created those columns using custom code in your DataPage or using tools in your webpage? A screenshot of the issue will be helpful as well. Regards,
  3. Hello, This cannot be done automatically due to system limitations in Caspio. It is only possible if you manually run a Report DataPage. Formula fields/triggers need an insert/update to happen to the table to automatically change the status of the field. Hope that helps.
  4. 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,
  5. 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.
  6. Hello Billy, You can add the following and try: <script> document.getElementsByName("cbParamVirtual1")[0].selectedIndex.text; document.getElementsByName("cbParamVirtual1")[0].value = "2012"; </script>
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  • Create New...