Forum Discussion

SteveStephens1's avatar
Qrew Member
8 months 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. 


From a new user

Steve S

4 Replies

  • 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)
    • SteveStephens1's avatar
      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
        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 White