Forum Discussion

QuintenQuinten's avatar
QuintenQuinten
Qrew Assistant Captain
8 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
8 years ago

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.

QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
So are you saying that you need to record the date / time the field was manually changed, and the date time that the email button changed it, and if the manual change date/time was after the last email change date / time, then suppress the button?