Skip to main content
Solved

Dynamic Rule - Or statement?

  • January 20, 2025
  • 0 replies
  • 302 views

Forum|alt.badge.img+4

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 multiple locations. I went thru thinking I could create rules to SHOW the question depending on the location. My problem comes when I have several locations which is basically are the EXACT same rule for a different location. I am finding the question only shows for the highest number rule. 

I did some googling and confirmed what was happening regarding the rule number. It seems the easiest way to fix this would be the ability to use an OR statement in the condition of the rule. I see several articles mentioning the same thing, but it doesn't seem particularly clear -   I can create the initial rule, then choose ALL or ANY for subsequent rules. 

Is there no way to do an OR here?   Should I be looking at this a different way?

My example is similar to this:

Boston  Quest1 Quest2

NY  Quest2 Quest3

RI  Quest 1 Quest 2. 

If Location = Boston   Show Quest 1  Show Quest 2

If Location = RI  Show Quest1   Show Quest 2

I could combine the rule to   If Location = RI or Location = Boston or Location = NY   Show Quest2

 

 

I built it all out without the OR, but got a rule warning:

Rules #10 and #11 are both 'show/hide' rules on the same field (Ex - Schutz).

 

 

Best answer by MarkShnierYou

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

 

MarkShnierYou
Forum|alt.badge.img+24

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