Triggered action that can add record as well as delete record

[rgiljohann]

I created a triggered action that successfully adds a record to a different when it is supposed to. This is used in an authentication table that filters users by two checkbox fields. Since the first part works, the second part I am trying to accomplish is if later I 'uncheck' those boxes, the different table updates accordingly. I have not been able to get that to work with the triggered action shown below. Ideally, it would be best if the second table deletes the record if I 'uncheck' that box, but I have not been able to get that to work. Again, I have the first Insert Into section working properly. I have not been able to get the second part which would either be an update or delete to work properly.

Triggered action:

 

[Vitalikssssss]

Hi @rgiljohann,

I would highly recommend creating a separate trigger for on "Update" event which will delete the updated record if criteria met.  

You currently have all events enabled (Insert, Update, Delete) which might create a lot of confusion after you try to test the Trigger.

Also, you need to change "Delete from" clause to #inserted if you would like to delete only updated record if criteria is met.  

Hope this helps.

[Vitalikssssss]

Hi @rgiljohann,

You can delete a record with "Delete" action block. 

You can also set a "Where" condition in order to delete records conditionally.

Hope this helps.

Regards,

Vitalikssssss

 

[rgiljohann]

I tried the delete as shown below, but could not get it to work.