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
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"
- You have to create multiple conditions. where all are true
Yes_or_No is not equal to Yes
Yes_or_No is not equal to No
If you want it to be case sensitive as well, you will need to create a formula that will check on the upper etc - 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).
