Send Email triggered action to send email only once

[CFSol]

I have created a data page that allows a record to be 'flagged' via a checkbox. (photo below)

I am finding that if someone goes into the record to update another field, the email will resend. The only way I can think to combat this is by having the 'Flagged' checkbox untick itself once the email is sent so if other fields are updated, it wont register that the checkbox isn't ticked.

Appreciate all help

[ParkLoey]

Hi @CFSol, that's actually the easiest idea! However, it might defeat the purpose of the checkbox. Not sure about your workflow but it might also cause confusion if the record is viewed and they see that "Oh, this record hasn't been flagged yet." So they might just check the checkbox and cause sending the email again,

A solution I can provide is by adding a new condition to make sure the email will be sent IF and ONLY IF, the checkbox was updated to TRUE. This solution will basically require you to just add a couple of things to your existing trigger. First, make sure to also join the table where you are updating so we can compare the OLD checkbox value to the NEW checkbox value.

 

I hope this helps!  

[cheonsa]

Hi all,

In addition, you may refer to these links:

https://howto.caspio.com/triggered-actions/triggered-actions-2/

 

[NiceDuck]

The other idea here is to put an extra yes/no flied in the table which will indicate if the record has already got an email. If the checkbox = false, it means they haven't had an email yet.

after sending an email, update the record to have a check in that field.




 

[NiceDuck]

My suggestion above is what is more commonly used. HOWEVER,  The first suggestion by @ParkLoey above is way better and more efficient for the trigger. 
Unless you have specific restraints, prefer to use that setup instead of the one I suggest above.