Insert Records from Views to a Table

[Esraaa]

Hey! 

 

Is there any way to automatically and instantly insert new view's records into a separated table?

[Mathilda]

On 6/1/2017 at 5:40 PM, Esraaa said:

Hey! 

 

Is there any way to automatically and instantly insert new view's records into a separated table?

Hi,

As far as I know this kind of  triggers are not available yet, it requires coding on the server level. This team should be able to implement that.

You may trigger inserting a row in the table only via Zapier and insert record into another table, if it works for you

[Kurumi]

Hi @Esraaa,

As of July 27, 2017, Caspio introduced a beta feature of Triggered action which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-9-8/

And on October 4, 2017, Caspio released the version Caspio 9.9 that includes their new feature, Triggered Actions. https://howto.caspio.com/release-notes/caspio-bridge-9-9/

This allows you to create and execute a specified data events (i.e. insert, update or delete) to perform additional data changes and complex data calculations on the same table and other tables.

 

Check these videos for more information:

You can check the Triggered Action article here: https://howto.caspio.com/tables-and-views/triggered-actions/

 

I hope this helps!

[ParkLoey]

Hi! In relation to the triggered action suggestion, just wanted to give insights on how to actually use it for this case. 

Basically, views are made up of one or more tables. So, if a record is added to a view, it means a record was added to a table. In order to utilize triggered action to insert the new record to a different table, the "ON INSERT" trigger event is what we need to use and we need to put the trigger on the EDITABLE table stated on the view. Here's a simple insert trigger that inserts newly inserted records into a different table which anyone can use to start creating triggers.

PS. Make sure the trigger is enabled so it works!