Jump to content
  • 0

Different SMS for Insert vs. Delete Triggered action


Fleshzombie

Question

Hi,

 

I am setting up a sms notification triggered action when employees are scheduled and removed from the schedule

 

At the top, you choose "run actions on"  Is there a way to separate or add one of those sections so I can have actions that are triggered on Insert, and separate actions that are triggered on Delete?

It doesnt give me the option to duplicate the "runs actions on" shell.  

 

Or would I be able to use IF statement to determine if the data is being inserted or deleted?

 

Thank you,

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 1
1 minute ago, Fleshzombie said:

so I can have actions that are triggered on Insert, and separate actions that are triggered on Delete?

You can only have 1 trigger of each 'run-on' type - Update, Insert, or Delete. I usually like to break them up into 3 triggers for their respective type in all of my apps for easier organization.

Pretty much, you would create a Trigger that runs on Insert, then you would create a 2nd Trigger that runs on Delete and copy the contents from the Insert trigger over to the Delete trigger. Now if the table has a new record inserted, only the Insert Trigger will go off - and vice versa.

 

Link to comment
Share on other sites

  • 0

Thank you!  I was just reading through the online help and saw this.  Didn't realize because I was making copies of triggers before making changes in case I break what was previously working and it would make me disable the previous action so I thought it was limited to 1

Back to work, I am sure I will be back with more questions.

 

Link to comment
Share on other sites

  • 0

Hiyaa! For everyone who may stumble upon this thread, here's the how-to article where we can see the info about only being able to activate one triggered action/event at a time:

https://howto.caspio.com/tables-and-views/triggered-actions/#:~:text=Additional Notes about Triggered Actions

Other additional info about triggers can be found there as well :)

 

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