Forum Discussion

Re: How do you create an approval button within Email Notifications?

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:

Table: Projects

Field 224: Project Approval
Type: text

Field 225: Project Approval Button
Type: Formula - URL
Formula: URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=<App Token>&_fid_224=Approved&rid=" & [Record ID#]

Notification: Project Completion Approval
Condition: Sent wherever field "Status" changes to "Completed"
Type: Custom Message
Custom 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.

Thanks.
 

No RepliesBe the first to reply