I have a field in my form "Status", and depending on the status I want an email to be sent to the customer to let them know what the status is on their order.
The problem I am having is that every time I edit a record, it sends an email, even if nothing was changed. For example if the status of an order is "Completed", I can open and close the record many time and an "order completed" email is sent each time, even though I haven't changed anything. How do I set it so that the emails are only sent when the status has been changed?