Problem with UserToken in Formula URL

Would it not be the apptoken instead??  Something like this ??

URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9=" &apptoken=apptoken& URLEncode($NewValue);

Try this

// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [Process for Submission] ;


var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9=" & URLEncode($NewValue)
& "&usertoken=xxxxxxxxxxxxxxxxxxxx";

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});" & "void(0);

great thank you.  That worked (for the button), but it still didn't fix the problem with the Quickbase action

The Quick Base Action should continue to operate under the Permission of the user who created the action.

I suggest that you check if the "other User" actually has permission to update that record.

 One way to do that is to change the URL button to this - ie temporarily comment out the javascript refresh as that hides the error messages.




// make a formula variable to be the opposite of the checkbox condition.
var bool NewValue = not [Process for Submission] ;


var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9=" & URLEncode($NewValue)
& "&usertoken=xxxxxxxxxxxxxxxxxxxx";

$URL

//"javascript:" &
//"$.get('" &
//$URL &
//"',function(){" &
//"location.reload(true);" &
//"});" & "void(0);"



That will expose any error messages when the button is pushed.  My guess is that the "other user will push the button and get some kind of permissions error.

I know that the users have permission to update both records.  The actual records in the other table would already have been updated by these users (and they have), and the checkbox value is changing when the user clicks the button, so I believe the permissions are okay.  I also just tried changing the users role to Administrator (same as my role) in the most recent test and the results are the same.  I'll comment out based on your suggestion and report back

No errors on the update (and that's validated because the checkbox value always changes), it's just that with this user the QB Action doesn't fire. 

Well that has me stumped.

Same as the QB support tech I spoke with.  I think he was taking shots in the dark to try and resolve it.  

what is the trigger field and more importantly what field types are you populating?