Skip to main content
Nintex Community Menu Bar
Answer

Hide a Control Unless One of Three Options Selected - Need Syntax

  • August 17, 2022
  • 10 replies
  • 50 views

Underdog

Hello Everyone,

I want to hide a Control unless one of three choices is made. 

Here's the syntax I've written:

 

Formula

When

RequestingArea != "Audit" || "P&C Finance" || "Tax"

Then

Hide

 

I believe I'm close to the correct syntax.  Would someone be able to provide the proper syntax?

Thanks!

 

25202i70F8C126A12D1F39.png

 

Best answer by Garrett

Try this

Not(RequestingArea == "Audit" || RequestingArea == "P&C Finance" || RequestingArea == "Tax")

10 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • August 17, 2022

Not(RequestingArea == "Audit" || "P&C Finance" || "Tax")


Underdog
  • Author
  • August 17, 2022

Hi @Garrett,

Thank you for the response.  Hope your day is going well.

I typed in your suggestion and Nintex didn't like it.  The "Choice" Control still shows.

 

 

When I type your recommended formula with one item, in this case "Audit", it works fine.

 

 

Thoughts?

 

 

 

 

 

 

 

 


Garrett
Forum|alt.badge.img+16
  • Scout
  • Answer
  • August 17, 2022

Try this

Not(RequestingArea == "Audit" || RequestingArea == "P&C Finance" || RequestingArea == "Tax")


Underdog
  • Author
  • August 17, 2022
Excellent! That's the ticket! Thank you!

Garrett
Forum|alt.badge.img+16
  • Scout
  • August 17, 2022

Sorry for the initial mistake... I'm in the middle of coding a workflow


bamaeric
Forum|alt.badge.img+14
  • Apprentice
  • August 17, 2022

Another option is to use Runtime functions, which I've have better luck with in the past. It's also a matter of preference. The below formula should work too.

 

not(or(contains(RequestingArea,"Audit"),or(contains(RequestingArea,"P&C Finance"),contains(RequestingArea,"Tax"))))


Underdog
  • Author
  • August 17, 2022

Hi  That worked too.  I had to add an "or" and one parenthesis, but your suggestion worked.  Should I pose this as another question, so that you get credit for solving this too?

Thanks!

 

Solution:

not(or(contains(RequestingArea,"Audit"),or(contains(RequestingArea,"P&C Finance"),or(contains(RequestingArea,"Tax")))))

 

@bamaeric


Underdog
  • Author
  • August 17, 2022
Nintex edited my response, so it looks a little wonky .. but the solution is correct.

bamaeric
Forum|alt.badge.img+14
  • Apprentice
  • August 17, 2022

Good catch. That's why you troubleshoot. No need to add another question - a kudo is fine. Glad you were able to get a solution.


Underdog
  • Author
  • August 17, 2022
Thank you!