Forum Discussion
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.
- MichaelBarrow7 years agoQrew CadetExactly! And what would the code for something like that look like?
- QuickBaseCoachD7 years agoQrew CaptainSo 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?
- QuintenQuinten7 years agoQrew Assistant CaptainNo 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.
- QuickBaseCoachD7 years agoQrew CaptainDo you still need to fire the email when the button is pressed? I assume so. Anyways I now understand your request. Can you post your current formula for the button?
- QuintenQuinten7 years agoQrew Assistant Captain
var text Extend = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"
& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"
& "&_fid_206=Approved";
var text Display = URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#];$Extend
& "&rdr=" & URLEncode($Display) - QuickBaseCoachD7 years agoQrew Captain.. and one more question. Is the email triggered only when the field is changed to Approved?
- QuintenQuinten7 years agoQrew Assistant Captain
Email is triggered when field is changed to "enter data". The button in the email then triggers the field to be changed to "approved".
- QuickBaseCoachD7 years agoQrew CaptainSo can we just hide the button when the status is not "entered data"
var text Extend = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"
& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"
& "&_fid_206=Approved";
var text Display = URLRoot() & "db/" & Dbid() & "?act=dr&rid=" & [Record ID#];If([my status field]="entered data",
$Extend
& "&rdr=" & URLEncode($Display)) - QuintenQuinten7 years agoQrew Assistant Captain
That doesn't work. It is almost impossible to hide a button in an email. That button in the email will always be active.
- QuickBaseCoachD7 years agoQrew CaptainHave you tested it?