Send Different Emails Based on Status

[BeffreyJezos]

Hi

I have built a simple order tracking app and I want to send email notification to the users every time the status is changed. The problem is that I have multiple status for the orders.



Here is a sample of my table records. As you can see, I have "Placed" ,"Picked up" , and "Delivered" status. I have a couple more but the idea is that for each of these status, I want a different email message or content sent to the email address of the user.

Currently, I am only using acknowledgement emails so the users will receive an email upon placing an order. Is there a way to do this? Thanks in advance.

~Hexy

[Tubby]

Hi @HexGone!

If you can use triggered actions on your account, you can achieve that using a similar triggered action as this:


This triggered action will run on an update event(when you update the status), and then check the updated value of the field "type" (in your case, "Status").  Based on the updated value of "type", the trigger will change the email body to the corresponding CASE WHEN statement that it matches and then send it to the email address included in the updated record.

I hope this helps.

- Tubsss 

[Flowers4Algernon]

Hello, this forum post might be helpful as well: