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 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).
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