Unable to implement rule in quickbase

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • In Progress

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"
Photo of Pushpakumar Gnanadurai

Posted 12 months ago

  • 0
  • 1
Photo of Micro Dev

Micro Dev

  • 1,524 Points 1k badge 2x thumb
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?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,516 Points 4k badge 2x thumb
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).