AnsweredAssumed Answered

Creating Rule to show/hide a control based on what another control contains

Question asked by cory92790 on Aug 25, 2017
Latest reply on Sep 25, 2017 by fhunth

I am trying to show or hide two controls based on what another control contains. If a calculated value field (called "Filter Control") contains CLM01, CLM74, or CLM75 I need the two controls to be displayed, but if it contains anything else, I need it to stay hidden.

 

The rule I created initially for the controlwas:

 

Filter Control!="CLM01"||"CLM74"||"CLM75"

 

I would then check the "Hide" option for the rule, but had no luck. So, I shortened it down to:

 

Filter Control!="CLM01" and this worked perfectly.

 

I tried various bracketing and spaces, shown below, also with no luck:

 

(Filter Control!="CLM01"||"CLM74"||"CLM75")

 

Filter Control!=("CLM01"||"CLM74"||"CLM75") - This one will display the controls when Filter Control contains CLM01, but not CLM74 or 75.

 

Filter Control!="CLM01" || "CLM74" || "CLM75"

 

(Filter Control!="CLM01" || "CLM74" || "CLM75")

 

Filter Control!=("CLM01" || "CLM74" || "CLM75")

 

Any formatting suggestions would be greatly appreciated. Please, let me know if I've been descriptive enough. I can also provide screenshots as necessary.

 

Thank you!

 

Outcomes