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

[Carioca]

I am creating an on insert trigger for my table but upon testing, I got this error.

 

Modified the trigger to a simple insert like this:

 

However, the error still persists.

Does anyone encounter the same issue? Any help would be greatly appreciated.

[AtayBalunbalunan]

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.

 

[Carioca]

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/: