cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

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

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!

Labels: (1)
Reply
4 Replies
Workflow Hero

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

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

Accept as Solution Reply
Workflow Hero

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

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!

Accept as Solution Reply
Workflow Hero

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

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

0 Kudos
Accept as Solution Reply
Workflow Hero

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

Hi ‌, have you solved it?

0 Kudos
Accept as Solution Reply