Jump to content
  • 0

Triggered Action for Bulk Data Update


EmmePGN
 Share

Question

With the help of a Caspio Chat Support agent, Ian Natividad (very helpful person),  I managed to create a triggered action that would update fields from one table after a certain value is entered from another table.

I have over 200 records and now wish to update all in one go by uploading an excel workbook update.  But the trigger I created (through the very helpful person), doesn't seem to work on bulk updates. It only works when I do a one record update at a time activity.

Am I missing something? Or are triggers designed to only work on one single record update action at a time?   Please help.  Below is the said trigger.

:) Thank you in advance.

 

 

triggeredaction.jpg

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

I believe it is because Triggered Actions do not run on import of data, both manually and from the DataHub.

You can find this in the "Additional Notes about Triggered Actions" section towards the bottom of this page:

https://howto.caspio.com/tables-and-views/triggered-actions/

Also, there is a maximum amount of records that can be updated via Triggered Actions at one time, and this number changes depending on the plan you have. You can find this on that same page I linked.

Link to comment
Share on other sites

  • 0
4 hours ago, kpcollier said:

I believe it is because Triggered Actions do not run on import of data, both manually and from the DataHub.

You can find this in the "Additional Notes about Triggered Actions" section towards the bottom of this page:

https://howto.caspio.com/tables-and-views/triggered-actions/

Also, there is a maximum amount of records that can be updated via Triggered Actions at one time, and this number changes depending on the plan you have. You can find this on that same page I linked.

 

Thank you so much for this information.

 

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...
 Share

×
×
  • Create New...