Skip to main content

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!

 

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


I have tried the above format, and I'm still not getting the results I need. Here are the different variations of the above formula I've tried:

 

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

 

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

 

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

 

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

 

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

 

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

 

If you or anyone else has any other suggestions, that would be great. Thanks again!


Could you send me the templates of your list and form?


Hi ‌, have you solved it?


Reply