How would I create a script that sends an email when a dropdown of an existing record is changed/updated to a specific option.
For example: a database record has a dropdown with three options (a,b,c) when it is changed from option A to option C (and submitted) I would like to send a notification email to a user. But specifically from A to C, not A to B.
Is this possible?