Unable to implement rule in quickbase

  • 0
  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 0
  • 1
Photo of Micro Dev

Micro Dev

  • 1,626 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 (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,254 Points 5k 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).