Forum Discussion

SteveStephens1's avatar
SteveStephens1
Qrew Member
2 years ago

Opposing Checkboxes

I am trying to figure out how if CheckBox1 is selected, CheckBox2 is cleared.  If CheckBox2 is selected, CheckBox1 will be cleared. 

Thoughts

From a new user



------------------------------
Steve S
------------------------------
  • Have you tried using two form rules?  Also are you using the new styles form or the Legacy Style forms?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • SteveStephens1's avatar
      SteveStephens1
      Qrew Member
      1  When Inprocess Inspection is equal to checked, change Incoming Inspection to unchecked
      2  When Incoming Inspection is equal to checked, change Inprocess Inspection to unchecked

      New Style forms



      ------------------------------
      Steve Stephens
      ------------------------------
      • ChayceDuncan's avatar
        ChayceDuncan
        Qrew Captain

        Your setup looks correct, but at least what you copied has what appears to be the same rule copied twice. 

        If you're seeing inconsistent results, check to make sure that the checkbox for 'Run change actions when a condition changes from false to true' is unchecked.



        ------------------------------
        Chayce Duncan
        ------------------------------
  • Hi Steve.

    I don't know if this helps but I used a Forumla button to do this. If one checkbox is set to '1' then the others are set to '0'.

    If ([IOE Authorisation Revoked]=false and [IOE Authorised]=true,
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&apptoken=cf5y3a7djhknc9z2kgrab8kjtp8" &
    "&_fid_263=1" &
    "&_fid_259=0" &
    "&_fid_275=0" &
    "&_fid_267=0" &
    "&_fid_271=0" &
    "&_fid_100=" & Now() &
    "&_fid_102="& URLEncode(User()) &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
    "?a=er&rid=" & [Record ID#]))

    Fields 263, 259, 275, 267 and 271 are all checkboxes. The code above removes the tick from 259,275,267 and 271 when a tick is placed in 263.

    I hope this helps.

    Michael



    ------------------------------
    Michael White
    ------------------------------