I have two Person or Group fields in a list and Nintex Form, and I want to prevent the user from entering the same name in both
fields. In the Validation Rule for the PrimaryOwner field, I have tried:
userEquals({ItemProperty:PrimaryOwner},{ItemProperty:SecondaryOwner})
Result: NEVER evaluates to true. I tried the same person and different people in the two fields.
If(userEquals({ItemProperty:PrimaryOwner},{ItemProperty:SecondaryOwner}),1,0)
Result: Same as above
equals({ItemProperty:PrimaryOwner},{ItemProperty:SecondaryOwner})
Result: ALWAYS evaluates to true. I tried the same person and different people in the two fields.
If(equals({ItemProperty:PrimaryOwner},{ItemProperty:SecondaryOwner}),1,0)
Result: Same as above
Here's the odd part - I even tried comparing the field against itself (PrimaryOwner in both parts of the formula) and the results
are still as shown above. So I must be missing something about how this works.
Is there a way to observe what is being returned from a validation formula in Nintex Forms? It would be easier to analyze if I
know what the validation formula is returning. Thanks!
(Nintex Forms 2.4.1.0)