Dynamic rules, I am trying to create a rule that will ride 2 of the three options in a list and only show the one that I have selected.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I am trying to create a rule that will ride 2 of the three options in a list and only show the one that I have selected. I would need to repeat the same logic two more times 

ie. 

individual selects from a drop down list field either a,b,or c and then the subsequent section headers hide from viewing.  

Example

Select a; hide b and c 

Select b; hide a and c 

Select c; hide a and b

Photo of Christopher

Christopher

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
When users get their brain tangled up on the show hide rules, it's because you just need to re-wire your brain backwards.

The answer is easy. 

Make a Rule as to when to show section A

Make a Rule as to when to show section B

Make a Rule as to when to show section C

In your case its probably just

When A is checked show section A

When B is checked show section B


When C is checked show section C
Photo of Carlos

Carlos

  • 0 Points
Did you end up figuring this out?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
Carlos. The answer is in my answer.
Photo of Carlos

Carlos

  • 0 Points
Hey Mark,
I guess I had trouble getting that type of rule to work, because mine was slightly different. I had 3 multiple option fields, and I wanted the 2 others to become read only when one was turned on. I bumped in to an issue where QB was telling me that I had two rules "both show/hide' rules on the same field.

My original rule logic that QB didn't want to accept.

---------------
     Rule1

       When
       Approved is equal to “on”

       Action
       Make read-only Conditional
       Make read-only Denied

    Rule2
       When
       Conditional is equal to “on”

       Action
       Make read-only Approved
       Make read-only Denied

    Rule3
       When
       Denied is equal to “on”

       Action
       Make read-only Approved
       Make read-only Conditional
-------------

What I changed it to, and now it works as I need it to without any warnings or problems.


-------------
     Rule1

 When
       Multiple Conditions  - are true

           When -any- of the following conditions are true:
              Approved is equal to 'On"
              Conditional is equal to "On"
Action
       Make read-only Failure

     Rule 2

 When
       Multiple Conditions  - are true

           When -any- of the following conditions are true:
              Approved is equal to 'On"
              Failure is equal to "On"
Action
       Make read-only Conditional

     Rule 3

 When
       Multiple Conditions  - are true

           When -any- of the following conditions are true:
              Failure is equal to 'On"
              Conditional is equal to "On"
Action
       Make read-only Approved

----------------

Anyways, both require 3 rules, so i found it weird that one was accepted, maybe there's a better way and I just don't know it. I'm not a programmer and I've only been working on QB for about a month. It might be too much information, but maybe it will help someone if they stumble in to this as I did.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,448 Points 50k badge 2x thumb
It sounds like you did it correctly.