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

I fixed the error message, except when the button is clicked in the email, it takes me to the table A (where the button is located). I want it to take me to table B where the checkbox is located.

Can you post your current code?

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

& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"

& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"

& "&_fid_282=true"

& "&rdr=" & URLEncode(URLRoot() & Dbid() "?a=dr&rid=" & [Record ID#])

I'm thinking it is in the Dbid() part

Right. You want to land on the SAP table


So the ReDiRect needs to say


& "&rdr=" & URLEncode(URLRoot() & [_DBID_SAP_Table] & "?a=dr&rid=" & [Contract -Record ID#]


You will need to get the correct name for that SAP table from settings, for that table, and then Advanced Properties.

I get an error code of 83 when I put it in the email notification.

Please post your current formula and the XML response

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

& "&apptoken=b9pzvpjdbfk42zck9xawjk99nx5"

& "&usertoken=b27z4b_xfm_b57dsvw279ijqcf93f6cdaj7y4f"

& "&_fid_282=true"

& "&rdr=" & URLEncode(URLRoot() & [_DBID_Contracts] & "?a=dr&rid=" & [Record ID#])


ERROR CODE:
<?xml version="1.0"?>

-<qdbapi>

<action>API_EditRecord</action>

<errcode>83</errcode>

<errtext>Invalid error code: 83</errtext>

<errdetail>User token is invalid</errdetail>

</qdbapi>

It does not seem Tom like your usertoken. Is the usertoken enabled for the application which holds the record you are editing?

It is in the manage application tokens table within the App Properties. I'm not sure how to enable it though

The user tokens are different than an application token.

The user token allows a formula URL button to edit a record without the user needing to sign in.  The downside is that you will not know who actually clicked the button as it will always show the user of who owns the application token as the [Last Modified by]


The user tokens are obtained by clicking on your name at the top right and then "Manage Preference".  That is where you can create user tokens and assign their use to specific apps.

My guess is that the user token is either not correct or is not enabled for the app you are editing.