cancel
Showing results for 
Search instead for 
Did you mean: 
johns
Nintex Newbie

Nested and validation statements Ninitex form

Jump to solution

Hi folks, 

 

I'm a newbie on here and to SharePoint and I've got an issue with nested and statements in a validation rule. 

 

Basically, I want an error message to be thrown if 

1. Amount from a dropdown is in Euro 

2. The Budget is > 125000

3. The Director field is empty. 

 

This validation rule is on the director field. 

 

What I've got is Control is invalid if : 

and(and(equals(EuroOrSterling, "€"), greaterThan(BudgetAmount, 125000)), isNullOrEmpty({Self}))

 

But it isn't working. 

 

Anybody able to help? 

Thanks in advance. 

Labels: (1)
0 Kudos
Reply
1 Reply
jpmhuls
Nintex Newbie

Re: Nested and validation statements Ninitex form

Jump to solution

For dropdown values you need to put it inside a parseLookup:

and(and(equals(parseLookup(EuroOrSterling), "€"), greaterThan(BudgetAmount, 125000)), isNullOrEmpty({Self}))

0 Kudos
Reply