lee_hoselton
Scholar

How to configure a form rule to evaluate on multiple conditions?

Jump to solution

I'm building out a form for our HR department and I'm having some issues getting a rule to function correctly. I have have drop down control that's connected to a choice column named Type of Search with 3 options

  • Full
  • Limited
  • Emergency

I have some controls in a panel that will only be used for Full or Limited searches so I'm trying to configure a rule to hide the panel.  I've tried the following syntax

All result in the panel being hidden, but doesn't show when Limited or Full is selected

I have another panel that is hidden unless TypeofSearch equals Emergency which works fine.

I'm new to Nintex, so I'm sure I'm missing something simple. Any suggestions?  Thanks!

0 Kudos
Reply
7 Replies
cassymfreeman

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

So you want to hide the panel only when Type of Search <> "Full" AND Type of Search <> "Limited"?

You have an OR.  I think you need an AND.  Wouldn't it be simpler to just hide when Type of Search = "Emergency"?

0 Kudos
Reply
cassymfreeman

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

I have created a quick form with two panels.  Panel one "Full or Limited" has this rule:

and(not(equals(TypeofSearch,"Full")),not(equals(TypeofSearch,"Limited")))

Panel two "Emergency" has this rule:

not(equals(TypeofSearch,"Emergency"))

Seems to do the trick?

0 Kudos
Reply
lee_hoselton
Scholar

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

Thanks for the response. 

I only want the panel to show when Type of Search is "Full" or "Limited".   The reason I didn't hide it only when emergency is selected is because the drop-down doesn't have a default value so I assumed it would be visible initially.  I didn't want to have a default value on the drop-down because I want to ensure users choose a value.

0 Kudos
Reply
cassymfreeman

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

and(not(equals(TypeofSearch,"Full")),not(equals(TypeofSearch,"Limited")))

The above rule condition says Type of Search is not equal to Full and Type of Search is not equal to Limited.  That is what you want.  Our logic is slightly different as you are referring to "showing" it when in reality these rules only let you choose when to "hide" it.  Give the above a whirl and see what happens?

Reply
lee_hoselton
Scholar

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

That did the trick.  Thank you so much!

Reply
cassymfreeman

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

you're so welcome

0 Kudos
Reply
LindiB
Novice

Re: How to configure a form rule to evaluate on multiple conditions?

Jump to solution

Hi, I'm having this exact same issue.  I'm trying to hide a text field EXCEPT where any of the 3 options below are selected from a lookup field:

  • DAT Data Entry Error
  • DIV Diversion
  • WRG Wrong Customer Invoiced

 

See attached screenshot. I've finally got it to work for the first two conditions but as soon as I add the 3rd condition it won't work!  i.e. the text field is displayed when I select the first two options, but if I select the third option then the text field stays hidden.  No matter which order I add the conditions, the first 2 always work, but the 3rd one doesn't. What have I done wrong?

0 Kudos
Reply