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 email url is allowing. Ex. Email wants the field to change to "blue", but the manual adjustment change it to "red". When the link in the email gets clicked days after, the field in the table that was manually changed gets overwritten to a different text. Ex. The field that had "red" changes back to "blue". How do you keep the email from overwriting when you don't want it to? Is there a way to deactivate the email or the links in the email after is has been sent?
The Url button in the email will always update the field in the table no matter what. But I don't want it to if the field has already been changed to something else. How do I go about that?
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.
var text Extend = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
var text Display = URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#];
$Extend& "&rdr=" & URLEncode($Display)
Email is triggered when field is changed to "enter data". The button in the email then triggers the field to be changed to "approved".
If([my status field]="entered data",
That doesn't work. It is almost impossible to hide a button in an email. That button in the email will always be active.
I wouldn't know if that is possible because I don't know how to edit the role permissions...
How do I go about doing that? Do I give the viewer or participant the permission since the url button is in an email?