Jump to content
  • 0

Trigger Error


Glitch

Question

I receive an error when trying to enable the new trigger that I am currently working on. The error says "Can not enable trigger due to 2 cascading triggers". 

 

I don't see anything wrong with my trigger, I'm just passing the records to another table from #inserted. 

 

Can someone help?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Hi @Glitch,

 

This error occurs when you exceed the limit of 2 cascading triggers. Caspio's cascading triggers is only limited to 2.

Now, what are cascading triggers? 

This is when, a triggers action activates another trigger.

So for example,

Table A has trigger 1 > The trigger is to Update Table B.

Table B has trigger 2 > Trigger 2 runs on UPDATE, then again activates another trigger.

Now these are cascading triggers. These acts as a waterfall trigger. 

 


I think this error may also happen when you are trying to create triggers on the same event.

Say, the events are - Insert records to table1 upon Insert on table2 . And you have another trigger that would insert records to Table2 as well.

You can view the triggers associated on the Table by clicking Properties under the Tablename.

 

Screenshot_13.png.bf04fabd8ead37032fe63748e69fddfe.png

  From there, you can check which of the Triggers are causing the conflict. 

 

Hope this helps!

Link to comment
Share on other sites

  • 0

Just wanted to share this, this is what I have experienced. There is an Error message that says. "Triggered Action cannot be enabled because it exceeds the limit of 2 cascading triggers." - For this case, I believe that this is a system limitation. Also, I have a grow plan and the nested is up to 2. 

Link to comment
Share on other sites

  • 0
On 8/31/2022 at 4:08 PM, IamNatoyThatLovesYou said:

Hello Everyone, You can check this HowTo Documentation as well for more information regarding nested levels. https://howto.caspio.com/tables-and-views/triggered-actions/#:~:text=Maximum number of nested levels

Hi Guys! Here is an updated documentation for the nested levels as the old one is no longer available. https://howto.caspio.com/triggered-actions/triggered-actions-2/#:~:text=Date%2C and Variables. -,Limits,-Depending on your

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