How can I hide a panel based on the selection in a drop down?

  • 26 October 2017
  • 2 replies
  • 18 views

Badge +4

I have a drop down choice field on a form. That field has 3 possible choices: Employee, Contractor, Temporary.

Here is my logic:

  • Panel A and Panel B are visible if EmployeeType == Contractor. So the Rule I created has Hide checked and has a formula like this: EmployeeType != 'Contractor'.
  • Panel A is visible if EmployeeType == Temporary. This is where I am running into my issue. I would assume that I could have a rule with a formula such as: EmployeeType != 'Contractor || EmployeeType != 'Temporary'. This does not work for me. I have tried the or() function but my selections are not boolean. I have also tried 2 rules breaking the formula apart and that does not work. 

Any suggestions to the issue in the second bullet?


2 replies

Badge +7

Hi,

Panel A is visible if EmployeeType == Contractor or EmployeeType == Temporary so the condition will be Hide if:

and(EmployeeType != 'Contractor' , EmployeeType != 'Temporary')

you should use and instead of or.

BR,

Badge +2

Thanks for the solution, the construction works in my particular situation.

Reply