Thank you for the quick response.I believe your answer assumes a level of understanding that I do not have.I assume you are answering the part of my question to do with the XML response.I'm not quite sure what to do with the code you sent.You are referencing a fid of 6 (a boolean) which I assume I must modify to fit what I have in my table.I can create a new field type boolean if needed.
Here's what I have:
Field 224: Project ApprovalType: text
Field 225: Project Approval ButtonType: Formula - URLFormula: URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=<App Token>&_fid_224=Approved&rid=" & [Record ID#]
Notification: Project Completion ApprovalCondition: Sent wherever field "Status" changes to "Completed"Type: Custom MessageCustom Message:
Hello User,<br>Please approve the project [Project Name] using the below approval link.<br><br>
[Project Approval Button]<br><br>Thank you for your attention,<br><br>MEDA QuickBase Administration
I have 2 issues.
1. Email is sent with a link (it works in that it updates the Project Approval with "Approved"). Need to modify to send with a button as requested from the users.
2. Once the link is submitted a browser session is started with a XML response. Need to provide a human readable response. These are business users and would not understand XML.
Please let me know if any further information is needed.
Use the information below to put a link into a Notification email.
This works on a PC or Mobile device. It also works if a user is logged in or not.
The link is Used to respond to a Notification by changing a status, checking a checkbox, or other interactions that require a response. The example below clicks a checkbox.
The link goes into a text field on the table:
var text URLONE = URLRoot()& "db/" & Dbid()& "?act=API_EditRecord&rid="& [Record ID#]& "&_fid_<field ID>=1"& "&apptoken=<apptoken>"& "&usertoken=<usertoken>";
var text URLTWO = URLRoot();
$URLONE& "&rdr="& URLEncode($URLTWO)
Then the field is added to a custom email Notification:
<a href="[Click to Approve]">Click to Approve</a>
That really helped.
It gives me the code I needed for the button I was looking for.
Thanks so much!