I would like to have a button in an email notification that checks a box when clicked. However the email notification is located in a different table from that of the checkbox.I am getting error codes when clicking the button. I have made buttons before but error codes keep showing up.

Please post you code for the button and the error

URLRoot() & "db/" & [_DBID_Contracts] & "?act=API_EditRecord&rid=" & [SAP Contract #]& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"& "&_fid_282=true"ERROR Code:<qdbapi><action>API_EditRecord</action><errcode>30</errcode><errtext>No such record</errtext><errdetail>Sorry, there is no record in this application table with the record identifier (rid) of "800275310".</errdetail></qdbapi>

To edit a record you need to specify the record I'd or the key field value. There is no way that you have a Record ID of 800 million. So either you need to change to this &rid=" & [Record ID#] Or else &key=" & [SAP Contract #] If that SAP Contract was the Key field.

I changed it to &rid="& [Record ID#] and got the error:Sorry, there is no record in this application table with the record identifier (rid) of "5

The button is on table A. But you want to edit a record on another table, table B. Which record do you want to edit? You need to specify either the record ID number or the Key field of table B. Once that works you will then have to decide where you want to leave the user or else the system will put up a success message in the screen which you will want to suppress.

Click a button in email notification to change field in different table

25 Replies

QuintenQuinten
Qrew Assistant Captain
8 years ago
Sorry for the problems. This worked, the checkbox gets checked when clicked in the email notification, however I now get the error "We can't understand the URL you specified. If you think the URL is correct, try refreshing this page." Not sure how to get rid of this error
QuickBaseCoachD
Qrew Captain
8 years ago
I can't read your mind as to what your current formula is.
I'm good, but not clairvoyant.
QuintenQuinten
Qrew Assistant Captain
8 years ago
It is the same as above, I just put the user token in my preferences:

URLRoot() & "db/" & [_DBID_Contracts] & "?act=API_EditRecord&rid=" & [Contract - Record ID#]

& "&apptoken=*******************"

& "&usertoken=*****************"

& "&_fid_282=true"

& "&rdr=" & URLEncode(URLRoot() & [_DBID_Contracts] & "?a=dr&rid=" & [Record ID#]
QuickBaseCoachD
Qrew Captain
8 years ago
Missung db/

& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_Contracts] & "?a=dr&rid=" & [Record ID#
QuintenQuinten
Qrew Assistant Captain
8 years ago
It worked! Thanks so much!

Forum Discussion

Click a button in email notification to change field in different table

25 Replies

Related Content

Add button to create record in different app

New Notifications

API Button Help

Notification with attachment

Formula Url Buttons