Solved

Rule Show/Hide

  • 20 December 2017
  • 5 replies
  • 2 views

Badge +5

Hi,

Any help please!

 

In a Form I have for example 2 columns:

 

One column is called: CostCentre

This is a dropdown menu with values like:

B001

B002

B003

B004

etc.

 

Second column is called: LineManager

 

How can I setup a rule so that LineManager is hidden on the form unless B003 and B004 is chosen from the dropdown CostCentre.

 

Thanks,

Adam

icon

Best answer by lazyme119 20 December 2017, 15:20

View original

5 replies

Badge +9

Write a rule for 'Line Manager' like below.

Badge +5

Hi Laksmi C,

I tried your method:

In here when I choose B003, the LineManagers field shows up. So that is good.

But when I choose B004 than the LineManager fieldis hidden.

I want the LineManager field to be shown if I choose B003 or B004.

Any suggestions?

Userlevel 6
Badge +16

Try the ‌'s suggestion but using !contains() instead !=

Badge +5

Hi Fernando,

This worked for me!!!

!contains (CostCentre, "B003") && !contains (CostCentre,"0111 B004")

Many Thanks,

Adam

Badge +5

made a mistake...

This is the correct one

!contains (CostCentre, "B003") && !contains (CostCentre,"B004")

Reply