Skip to main content
Question

URL button to check/uncheck a checkbox

  • July 12, 2021
  • 0 replies
  • 165 views
Hi everyone, I'm trying to create a URL button that just checks or unchecks a checkbox (depending on status of the checkbox) so that I can trigger a pipeline. I just can't get it to change the checkbox. I'm sure I'm missing something incredibly obvious here... 

var text NewCheckboxValue = If([Send to Quickbooks Trigger]=true,"0","1");

URLRoot() & "db/" & "DBID" & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_312=" & $NewCheckboxValue &  "&apptoken=" & "XXXX"​

And then I've also been trying to use a=doredirect to refresh the current form page but I haven't quite worked that out either. Thank you!!!

------------------------------
Elena Larrabee
------------------------------

Try this and see if it helps:

var bool NewCheckboxValue = [Send to Quickbooks Trigger]=false;

URLRoot() & "db/" & "DBID" & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_312=" & $NewCheckboxValue &  "&apptoken=" & "XXXX"​​


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