Problem with UserToken in Formula URL
I have a working Formula URL button which is changing the value in a checkbox, based on the current value. However, we're having problems with another user's use of the button to trigger a quickbase ...
Forum Discussion
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 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.