Forum Discussion

LizChartrand's avatar
LizChartrand
Qrew Cadet
5 years ago

Rich Text Button Help - Completing more than one task

Hello, I'm trying to create a button that, will check different boxes when clicked in a sequence so we can monitor task completion on a record. For instance, when clicked once the button checks ...
APIs and custom code
Buttons
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
I'm not certain I got your logic 100% accurate, but I think I would go for something like this instead:


//Token
var text tk = "xxxxxxxxxxxx";

//Checkbox FID
var text ck = If(
[QB Update Complete?],"&_FID_77=1",      //Update FID 77
[CRT completed?],"&_FID_80=1");          //Update FID 80

//Button Name
var text name = If(
[QB Update Complete?],"Lease Execution Complete?",
[CRT completed?],"Completed","Units Updated?");

//Landing Page
var text URL = URLRoot() & "db/" & Dbid() &"?a=dr&rid="&[Record ID#]);

//Base Action URL
var text base = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=" & $tk &
"&rid=" & [Record ID#] &
"&_fid_82=" & URLEncode(UserToName(User()));

//Primary URL
var text URL = $base & $ck & "&RDR=" & URLEncode($land);

"<a class='Vibrant Success' href='" & $url & "'>" & $name & "</a>"​


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------