Forum Discussion

QuintenQuinten's avatar
QuintenQuinten
Qrew Assistant Captain
7 years ago

Deactivate Url Link in Email Notification After It has been sent

An email notification is sent with a url link formula that allows a field to be changed in a table. However, sometimes the field in the table gets changed manually with a different text than what the...
NotificationsEmail
QuintenQuinten's avatar
QuintenQuinten
Qrew Assistant Captain

There is no way of telling the email that the multiple choice field has been changed, because it was manually changed. A solution would be to put a if then statement in the link in the email so when/if the field gets changed in the table, no affect will occur.

QuintenQuinten's avatar
QuintenQuinten
Qrew Assistant Captain
7 years ago
No date or time. The field I'm looking at is a multiple choice field with three options, "entered data", "approved", "shipped". Email gets sent out when field is "entered data" and when the link in the email is pressed, field moves to approved. Sometimes there is not enough time to wait for the email response so it gets moved to shipped. However, a person goes back in their email and presses the link forcing the field to go back to approved. I don't want that. Once it is manually changed to shipped it needs to stay there even if the link is pressed in the email.