How do you create an approval button within Email Notifications?

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>

 

Improvements:

Once the User clicks the link, the browser opens and takes the user to the QB login page. We would like to remove this unnecessary step. QB requires the User login to the App and load the page.

To make the link into a button you must use the img tag. https://www.w3schools.com/css/css3_buttons.asp Use this tutorial to learn how to do this.

Your button image can be one of the images stored here: https://login.quickbase.com/db/bcgnn27bx?a=q&qid=1000039