Forum Discussion

brian_s's avatar
brian_s
Qrew Trainee
3 months ago
Solved

Dynamic Rule - Or statement?

I have been building a series of dynamic rules this afternoon and hit a snag.  Basically, I have a list of questions that need to be filled based on location. Each question COULD be asked in multip...
Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    3 months ago

    Yep been there, done it,  bought the T-Shirt.

    You need to write a rule per field and not a rule per Situation.  You need to "get your mind right".   Check out my Cool Hand Luke Post here:

     https://community.quickbase.com/discussions/quickbase-discussions/dynamic-form-rules-and-or/81433

    dynamic form rules and or | Qrew Discussions

     

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 months ago

Yep been there, done it,  bought the T-Shirt.

You need to write a rule per field and not a rule per Situation.  You need to "get your mind right".   Check out my Cool Hand Luke Post here:

 https://community.quickbase.com/discussions/quickbase-discussions/dynamic-form-rules-and-or/81433

dynamic form rules and or | Qrew Discussions

 

brian_s's avatar
brian_s
Qrew Trainee
3 months ago

You know, I did come across this, and I thought about it for a while and that's when I moved on.  I have no doubt that your right that I need to get my head right, but for example in your post you say to 1. Scrap  2. Define on Paper  3. Put in with Keyboard.

In order to do this with a rule, I still need that OR statement that doesn't seem to exist. The situation I was creating the rule for is if any of these rules are selected Location1, Location2, Location3 then SHOW THE RULE. 

Unless you mean to do something like:

IF  LOCATION is not Blank

and ANY of the following are true   Location = Location1, Location =  Location2, Location = Location3

Show  "A FIELD" and repeat this rule for each field.   This last part literally just came to me as I was typing. Im going to try it now...