Show/Hide panel based on dropdown menu

  • 26 February 2019
  • 2 replies
  • 0 views

Badge +4

Hi,

 

Similar issues have been posted but I cant find a solution that works for me. I need a rule in my form that keeps a panel hidden unless a requirement is met.

 

In my form, users need to select an employment type from a drop down:

  • Regular permenant position
  • Seasonal
  • Sessional
  • Fixed Term
  • Temporary (Maternity Leave)

 

I want a panel to show only if Fixed Term or Temporary are selected. The hide button is ticked in the rule and I am selcting a Named Control, not the Item property.

I've tried numerous formulas including:

or(StatusExtraInfo!= 'Fixed Term' , StatusExtraInfo != 'Temporary')

or(StatusExtraInfo!= 'Fixed Term' || StatusExtraInfo != 'Temporary')

StatusExtraInfo!="Fixed Term', 'Temporary'

and so on.

 

Any help would be greatly appreciated.

 

Lexie


2 replies

Userlevel 4
Badge +12

Hi Lexie,

first, you can't check for "Temporary" with the not equals (!=) operator, when your term is "Temporary (Maternity Leave)". You would have to check for the full term.

 

Try this one and see if it works for you:

and(not(contains(StatusExtraInfo, "Fixed Term")), not(contains(StatusExtraInfo, "Temporary")))

 

This will apply hide if StatusExtraInfo not contains "Fixed Term" and not contains "Temporary".

 

Best regards

Enrico

Badge +4
Thanks so much! I needed the' and' and the 'not' - rather than 1 or the other.

Your help is much appreciated.

Reply