Skip to main content
Question

Opposing Checkboxes

  • October 2, 2023
  • 0 replies
  • 49 views

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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach

    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
    ------------------------------
    Terms & ConditionsAccessibility statement