I am running the latest version o Nintex Forms on SharePoint 2013 Enterprise and can't get the validation rule on a form to work. It worked first time, but every attempt to test in the preview fails to use the validation. I am using IE11 for testing as that is the target browser for our users.
I have added a rule on a drop down control and told it to look at the values in two drop-down controls and see if they are equal.
the rule as I have written it is:
Control is invalid if:
Solved! Go to Solution.
They are drop-down named controls.I have applied the rule to drop-down control A but tested it on the 'Save' button and elsewhere and this simple operation just doesn't work.
so to debug what's going on with the formula I'd suggest following
- place 3 calculated value controls on form
- configure fromula for 1st one just to: BusinessUnit
- configure fromula for 2nd one just to: FundingType
post a screenshot how do they evaluate
II added those fields as per your instruction and then ran the form making the choices. The sum appears to result in "false". For context A is the BLC value and B is the Time and Material value. The third is the result of the sum.
The sum is:
Done. Here is the result (in order of your instructions). Very odd. Not sure what to make of this. i have checked every field on the rest of the form for any possible duplicates and not found any
I used a variation of the formula in the calculated column to check when the values DoNotEqual:
The result is returned as True.
I used the same formula in the rule and but it still does not fire and present the error message i configured:
Not firing message when validating:
It's starting to look like the product feature (validation rules) is broken?