Discussions

Expand all | Collapse all

URL button to check/uncheck a checkbox

  • 1.  URL button to check/uncheck a checkbox

    Posted 23 days ago
    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
    ------------------------------


  • 2.  RE: URL button to check/uncheck a checkbox

    Posted 23 days ago
    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/
    ------------------------------



  • 3.  RE: URL button to check/uncheck a checkbox

    Posted 23 days ago
    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
    ------------------------------



  • 4.  RE: URL button to check/uncheck a checkbox

    Posted 23 days ago
    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
    ------------------------------