Skip to main content

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

 

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


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?



 



 



 



 



 



 



 



 


Try this



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


Excellent! That's the ticket! Thank you!

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


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"))))


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


Nintex edited my response, so it looks a little wonky .. but the solution is correct.

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.


Thank you!

Reply