Forum Discussion

ROBERTSACHS's avatar
ROBERTSACHS
Qrew Cadet
7 years ago

How to modify two fields with a single FORMULA URL?

I have two fields, Status (FID=16), and Comments (FID=44).   I have an existing button which inserts today's date into Comments, along with some text: var text MyDate =Left(ToText(Today()),2) & ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
var text URLONE = URLRoot() & "db/" & Dbid() 
& "?act=API_EditRecord&rid=" & [RecordID#] 
& "&_fid_44=" & URLEncode($NewText)
& "&_fid_99=" & URLEncode('ToBe Reviewed);

change 99 to the fid of the field to be updated.  There is no practical limit to the # of fields you can update, just keep listed them vertically in that same format.