Forum Discussion

LochlanBroughto

Qrew Trainee

8 years ago

Confirmation button in email

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 ...

APIs and custom code

NotificationsEmail

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
  ------------------------------
  - ChrisNewsome
    Qrew Captain
    6 years ago
    Field type is Formula-URL
    
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=URLEncode([Record ID#])&apptoken=XXXXXX&_fid_202=Checked"
    
    I'm trying to send a confirmation email to a customer with a "confirm" button that will switch a checkbox to checked when they click it.
    
    Thanks!
    
    ------------------------------
    Chris Newsome
    ------------------------------