Discussions

Expand all | Collapse all

Controlling Two checkbox fields

  • 1.  Controlling Two checkbox fields

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


  • 2.  RE: Controlling Two checkbox fields

    Posted 9 days 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
    ------------------------------