Forum Discussion
EverettPatterso
6 years agoQrew Captain
The notification will have 2 Button Yes and No. If i receive the physical bill then i click Yes and a record gets generated in the transaction table
What do you want the No button to do?
------------------------------
Everett Patterson
------------------------------
- GunshamLakhiani6 years agoQrew CadetThe No Button will not do anything which means no records gets generated in the transaction table.
------------------------------
Gunsham Lakhiani
------------------------------- EverettPatterso6 years agoQrew CaptainSo just create one button for Yes and use that in your email notification
Formula URL (will show as a hyperlink in email) this will use the API to add the record to the transaction table with a status Paid
URLRoot() & "db/" & "Dbid name" & "?act=API_AddRecord&apptoken=apptoken&_fid_6=Paid"& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_TABLE]
- Change the "Dbid name" to the transaction table dbid you want the record created
- If app tokens are enabled, insert token
- Change _fid_6 to the field ID for the transaction Status field
- Change rdr [_DBID_TABLE] to the table you want to redirect them back to or any other URL
If you want to make the hyperlink into a button, then create a Formula Rich Text and use that in the email
Formula Rich Text
"<a style=\"background: #4285f4; border-radius: 5px; padding: 8px 20px; color: white; display: inline-block; font: normal 700 24px; text-decoration: none;\" href=\"" & [Yes button] & "\">Yes</a>"
- Change [Yes button] to the new formula URL field
------------------------------
Everett Patterson
------------------------------