Jump to content
  • 0

Triggered not working when data was imported


Kuroshi
 Share

Question

I have a table that has Triggered action. When records were inserted, it will copy some of the data to other table. However, I tried to import a file to the table as an append and the Triggered action did not fire. But, my triggered is working as expected when I entered or inserted a record directly in the table. Any thoughts?

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Hi,

Since you mentioned that you are importing a file in the table, triggered action will not work. So basically, this is expected behavior.

Triggered Actions currently will not run from import of data through either manual import or DataHub tasks. This is also stated here: https://howto.caspio.com/tables-and-views/triggered-actions/

Triggered action will only work if you are inserting the records manually inside the table.

I hope this helps.

-Barbie

Link to comment
Share on other sites

  • 0

Hello @Kuroshi

I am thinking of a workaround for this and came up with this ->  Create a Task instead that has the same functionality as your Triggered action. Task is somehow similar to trigger. However, the task will not fire automatically once you inserted a record. you will need to click the 'Run' task or schedule when will the Task run.

I hope this helps and works.

Barbie

Link to comment
Share on other sites

  • 0
On 5/1/2021 at 4:45 PM, Barbie said:

Hello @Kuroshi

I am thinking of a workaround for this and came up with this ->  Create a Task instead that has the same functionality as your Triggered action. Task is somehow similar to trigger. However, the task will not fire automatically once you inserted a record. you will need to click the 'Run' task or schedule when will the Task run.

I hope this helps and works.

Barbie

This Caspio how-to link might be helpful as well: https://howto.caspio.com/tasks/

Link to comment
Share on other sites

  • 0

As mentioned on the previous responses, Import bypasses the triggered action, thus they wont react to your imported records. If you really need to make the imported records go through to your triggered action, what I can suggest is to import them to an extra table. Then use a an application task to insert or update the main table base on what is the content of that task. 

Triggered action should now work from that. 

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