Caspio SQL Query
Would be nice if there was an SQL query for Caspio whereby you can write SQL statements to manipulate data in your Caspio database. In addition, be able to schedule jobs to run SQL query. Furthermore, it would also be great to trigger queries based on insert or update or records. See attached.
The feature is now available in Caspio 9.9 Release. Look for new Triggered Actions in Tables. More information can be found at https://howto.caspio.com/tables-and-views/triggered-actions/
Yes, adding SQL capability would help a lot for experienced users!
The trigged actions are nice but being able to write direct queries would be a game changer
AdminAdmin (Product Manager, Caspio) commented
In recent 9.8 Release, Triggered Actions feature has been offered to a limited number of existing beta users for the purposes of evaluating and providing feedback. The general availability of Triggered Actions are expected to be in the coming release.
Joshua Jobin commented
When can we expect this?
This would be huge.
The other option is to enable an ODBC connection to the database where we can use any of the SQL front ends.
I AGREE wholeheartedly!!!
Use calculated fields. They take SQL