How do I only send 1 email from a Change workflow rule?
I created a template in Google Docs called “Rejection Report”. I created a column in my main table called “Rejection Report”. I created an action that sets the value of [Rejection Report] to “Sent” I have a workflow rule set up to fire when “Sent” is in the [Rejection Report] column.
Everything is working as it should, but I just need the email sent one time, and that’s as soon as the word “Sent” shows up in the [Rejection Report] column. I understand I can do a scheduled workflow, but that won’t work for this situation. Is there anyway to create an expression that says something like [Rejection Report] = “Sent”, and nothing else.
Any ideas or suggestions?