I need help with Nintex Form 2013 to validate if a field value falls within a range:
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"
Field1 does not fall within a certain range: between 200000 and 220000
And if Field2 = Officer
then display a message "Office Code not valid"
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
Solved! Go 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