Jump to content
  • 0

Insert Records from Views to a Table


Esraaa

Question

3 answers to this question

Recommended Posts

  • 0
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

Link to comment
Share on other sites

  • 0

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!

Link to comment
Share on other sites

  • 0

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.

image.png.6cb182e12d1f536a9e10fac1c2735150.png

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...