cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How can I use a validation rule to compare a text value

Jump to solution

I need help with Nintex Form 2013 to validate if a field value falls within a range:

 

For example

 

Field 1 is a text field where users enter a code

Field 2 is a text field describing the type of code

I need to know if value from Field 1 does not fall within a certain range: between 100000 and 110000

 

And if Field2 = Executive

 

then display a message "Executive Code not valid"

 

OR

 

Field1 does not fall within a certain range: between 200000 and 220000

 

And if Field2 = Officer

 

then display a message "Office Code not valid"

 

OR

 

Field1 does not fall within a certain range: between 700000 and 799999

 

And if Field2 = Member

 

then display a message "Member Code not valid"

 

Thanks in advance

Labels: (3)
Tags (1)
0 Kudos
Reply
1 Reply
Highlighted
Workflow Hero

Re: How can I use a validation rule to compare a text value

Jump to solution

Have you tried to create 3 validation rules within the form on the Field1 control? An example rule would be (Field2=="Member") && fn-greaterthan(Field1, 799999) && fn-lessthan(Field1, 700000)

What you need to do in the condition is that when ever the evaluation is true, then the control is invalid.

You can also set the validation within the Field1 control settings.

See Quick Reference of Form Validations and Expression Operators  for more help

0 Kudos
Reply