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.
Caspio Guru
shared this idea
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/
-
Ana
commented
Yes, adding SQL capability would help a lot for experienced users!
-
Ryan
commented
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?
-
jens
commented
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. -
Teacher
commented
I AGREE wholeheartedly!!!
-
Anonymous
commented
Use calculated fields. They take SQL