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'?

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=cwfcy7gdzqrsyncqbi2bn4u4kr&usertoken=xyz123455678&rid=" & [Record ID#]& "&_fid_202=1"& "&rdr=" & URLEncode("https://xxxx");------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

Try a) switching your formula around and b) using both an apptoken and a usertoken. I have done this; and I use both and it works.URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=cwfcy7gdzqrsyncqbi2bn4u4kr&usertoken=xyz123455678&rid=" & [Record ID#]& "&_fid_202=1";------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

If you have any problem redirecting to an external website, you may have to contact Quickbase Support and ask them to enable your realm to allow redirect to extra websites. I had that problem once and it drove me crazy.------------------------------Mark Shnier (YQC)markshnier2@gmail.com------------------------------

No, you use it like a regular field; but it will show up as a link not a button, no matter whether you have set it to display as a button or not. Make sure the Link Text makes sense for what it is going to do.------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

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 fidand on the notification Message Type : Custom MessageCustom Message: [Formula_field]Interpret Custom Message as HTML: Yes

Confirmation button in email | Qrew Discussions

JohnThomas
Qrew Cadet
8 years ago
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
- LochlanBroughto
  Qrew Trainee
  8 years ago
  Do you know any way to redirect the user to another URL after changing the field?
- GauravSharma3
  Qrew Commander
  8 years ago
  Can you post another URL? then, will format the formula for you.
- LochlanBroughto
  Qrew Trainee
  8 years ago
  We're still building the website, so for now could you use www.example.com?
LochlanBroughto
Qrew Trainee
8 years ago
Amazing. Thank you.
SumedhaWeerasur
Qrew Cadet
7 years ago
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.
- ChrisNewsome
  Qrew Captain
  6 years ago
  I stumbled across this post trying to accomplish the same thing. I'm also getting an error 24 with the app token. I can't understand why as I'm using the token with another API currently. I can't get anywhere with this until I solve the token issue.
  
  ------------------------------
  Chris Newsome
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    6 years ago
    Please post you code that is now working.
    
    ------------------------------
    Mark Shnier (YQC)
    markshnier2@gmail.com
    ------------------------------

Forum Discussion

Confirmation button in email