Forum Discussion

olivermah's avatar
olivermah
Qrew Assistant Captain
7 years ago

URL button to populate a field with the current user

Hi There, I currently have a url button that populates a certain field with the user that last modified the record.   I need some help to change it from the user the last modified the record to ...
APIs and custom code
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
OK, so there is no way that the formula can work if your app is requiring Application Tokens.  You need to either turn off the need for Application Tokens or else provide on in the formula by adding in a line like,


var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xcxcxcxcxcxcxcxcxcxcxcx"
& "&_fid_30=" & URLEncode([Last Modified By]);


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