Confirmation button in email

  • 3
  • 2
  • Question
  • Updated 3 weeks ago
  • Answered
We have designed a HTML 'Booking Ticket' email to be sent as an email notification to clients when booking details are received.

The email notification is sent to the client directly via Quickbase notify upon saving the form.

We would like to include a button in the email which the client presses that 'confirms' the booking.

How would we go about building this button that changes the 'job status' field in a job row to 'confirmed'?
Photo of Lochlan Broughton

Lochlan Broughton

  • 224 Points 100 badge 2x thumb

Posted 1 year ago

  • 3
  • 2
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
create a formula field with the below formula 

URLRoot() & "db/" & Dbid()  & "?a=API_EditRecord&usertoken=USER_TOKENrid="&[Record ID#]&"&_fid_18=approved"

_fid_18 - change to your fid

and on the notification 

Message Type : Custom Message
Custom Message: [Formula_field]
Interpret Custom Message as HTML: Yes
Photo of Lochlan Broughton

Lochlan Broughton

  • 224 Points 100 badge 2x thumb
Do you know any way to redirect the user to another URL after changing the field?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,700 Points 5k badge 2x thumb
Can you post another URL? then, will format the formula for you.
(Edited)
Photo of Lochlan Broughton

Lochlan Broughton

  • 224 Points 100 badge 2x thumb
We're still building the website, so for now could you use www.example.com?
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,700 Points 5k badge 2x thumb
Try to add at the end of URL:

& "&rdr=" & URLEncode("http://www.google.com")
Photo of Lochlan Broughton

Lochlan Broughton

  • 224 Points 100 badge 2x thumb
Thank you! Do you have any advice or best practices for hiding the user token from users? Or do you just fine-tune the permissions so that particular user token can only edit particular fields, and not view tables?
Photo of Lochlan Broughton

Lochlan Broughton

  • 224 Points 100 badge 2x thumb
Amazing. Thank you.
Photo of Sumedha Weerasuriya

Sumedha Weerasuriya

  • 346 Points 250 badge 2x thumb
Have been trying to get this to work, but it is not working for me i am using application tokens. here is my formula url 

URLRoot() & "db/" & Dbid()  & "?a=API_EditRecord&usertoken=xxxxxxx&apptoken=xxxxxxxrid="&[Record ID#]&"&_fid_143=1"

i am getting an error saying that application token are required.