Jump to content
  • 0

Record cannot be saved because an error was encountered in Triggered Actions


Carioca
 Share

Question

2 answers to this question

Recommended Posts

  • 1

Please ensure that you don't have referential integrity enabled in you table relationship.

According to the note in https://howto.caspio.com/tables-and-views/triggered-actions/:

Quote

In the case of referential integrity enabled in a relationship, if a trigger executes on an insert event to the parent table, and inserts a record to the child table, the Triggered Action will fail. This is due to the action of inserting a record to the child table occurring first, thus failing the integrity check as the parent record does not yet exist.

 

Link to comment
Share on other sites

  • 0

Thank you! You're right, I have referential integrity enabled in my table relationship. I've disabled it and not receiving the error anymore.

1 hour ago, AtayBalunbalunan said:

Please ensure that you don't have referential integrity enabled in you table relationship.

According to the note in https://howto.caspio.com/tables-and-views/triggered-actions/:

 

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