Unable to implement rule in quickbase
When i create the above rule, I should be able to add "Yes" or "No" (case insensitive), but i am able to enter all the below values? How should i restrict only "Yes" and "No"
Forum Discussion
can't i use "OR" or "AND" use both values.. in the same condition? is that a quickbase limitation?
It's because the criteria is "equal to"... which is case sensitive. Contains would not be case sensitive. You could always write a formula-checkbox to check for all 4 conditions in one field; and then write your formula based on the checkbox - your checkbox would have to live in the form somewhere (usually in a hidden section).