This is a different question, but tangentially related to my forthcoming question about Option Sets:
How does one make a validation rule using the yes/only tick boxes?
(The following examples are pretty rudimentary, I’ve created a blank 2.20 instance just for testing this logic out) While my example might be a good case for the tracker (which has radio buttons for Option Sets), this will be all part of a much larger aggregate data entry form.
It seems that analytics interpret a as a “1” in 2.18 (2.20 the jury is still out), which makes doing things like pivot table very straight forward. When I applied that logic to the validation rules I have come up empty.
So I have three optionCombos for a data element:
I’d like to prevent the user from checking more than one box. The ideal thing would be to make a radio button, but the users don’t have the time/expertise to set up and maintain a custom form, so I am left with validation rules.
So I made a validation rule where the Left side:
and the right side is “1”
and the operator was ==
I tried many variations of operator, and have even put in things that can never be true, and in every case I cannot get the validation step to come back with anything but passed:
Am I missing any kind of gotcha or proper syntax for checking “Yes Only” values? The only other thing I can think of is to have the user input a “1” into a number entry and check that with a validation rule.
I checked what this looked like in the DB, and they are coded as “true” just like a Yes/No:
I tried various combinations of “Yes” “yes” “true” “TRUE” and couldn’t get any to take.
Any help on this would be greatly appreciated. Thanks!