URL button to check/uncheck a checkbox

Question

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...&nbsp;
var text NewCheckboxValue = If([Send to Quickbooks Trigger]=true,"0","1");

URLRoot() &amp; "db/" &amp; "DBID" &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;_fid_312=" &amp; $NewCheckboxValue &amp;  "&amp;apptoken=" &amp; "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------------------------------

blakeharrison · Answer

Try this and see if it helps:
var bool NewCheckboxValue = [Send to Quickbooks Trigger]=false;

URLRoot() &amp; "db/" &amp; "DBID" &amp; "?a=API_EditRecord&amp;rid=" &amp; [Record ID#] &amp; "&amp;_fid_312=" &amp; $NewCheckboxValue &amp;  "&amp;apptoken=" &amp; "XXXX"​​------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

elenalarrabee1 · Answer

Thank you for the response! It still isn't updating the checkbox... The URL looks right when I hover over the button too, it's showing that fid312=1 when the box isn't already checked. I'm not sure why it's not actually editing the record.

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

elenalarrabee1 · Answer

I realized what I was doing wrong! I wasn't specifying the the table by its alias, I was just including the actual DBID. I didn't realize that wouldn't work.

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

Forum Discussion

URL button to check/uncheck a checkbox

3 Replies