Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
5 years ago

Controlling Two checkbox fields

I have two checkbox fields that are labeled yes or no.  I am currently controlling them to make them required with the below Rule.  I would also like to control them so a user cannot select both Yes or No.  I want them to only be able to select one or the other.  Is there a way to do this with the current rule that is set up?



------------------------------
Brian Brian
------------------------------
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Try two  new rules

    when checkbox 1 is checked
    action
    uncheck checkbox 2.

    and then copy the rule and do the opposite.

    Be sure to uncheck the box to force the rules to fire all the time.

    you can also double safety net with a rule that says

    When the record is saved,
    and
    checkbox 1 is checked
    checkbox  2 is  checked.

    abort the save with message "please choose only 1 checkbox"

     



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------