Discussions

Expand all | Collapse all

Unable to implement rule in quickbase

  • 1.  Unable to implement rule in quickbase

    Posted 06-26-2018 15:29
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1737414/RackMultipart20180626-124142-10edbz6-image_inline.png?1530026791">


    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"
     


  • 2.  RE: Unable to implement rule in quickbase

    Bronze
    Contributor
    Posted 06-26-2018 16:08
    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


  • 3.  RE: Unable to implement rule in quickbase

    Posted 06-26-2018 17:39
    can't i use "OR" or "AND" use both values.. in the same condition? is that a quickbase limitation?


  • 4.  RE: Unable to implement rule in quickbase

    Silver
    Contributor
    Posted 06-27-2018 13:00
    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).