AnsweredAssumed Answered

Nintex Forms Validation with lookup()

Question asked by steven.amico@kodakalaris.com on May 28, 2015
Latest reply on Jun 1, 2015 by steven.amico@kodakalaris.com

I am trying to use a Validation Rule to assure that the user does not enter a value in a field that is already used in another

list in the same site.  In the Validation Rule for the SiteURL field, I have:

 

not(isNullOrEmpty(lookup("Site Collection Portfolio","Site URL",{ItemProperty:SiteURLFull},"ID")))
Result: NEVER evaluates to true.  I tried values that are and are not in the lookup list.

 

My thinking was that if the lookup function returned a value for ID, then the validation fails (user is not allowed to save), and

if the lookup function failed to return a value for ID, it would be null or empty, and the validation passes (user is allowed to

save).

 

A couple of questions:
(1) Should the "List Title" (parameter 1 of the lookup function) be Display Name or Internal Name?  I think it is Display Name

because I receved an error when I tried Internal Name, but I am not sure.
(2) Should the "Column To Filter On" (parameter 2 of the lookup function) be Display Name or Internal Name?
(3) Will this work if the "Value To Filter On" (parameter 3 of the lookup function) is a Calculated Column?  I also tried it as

two concatenated Single Line of Text fields, and got the same results.

 

Any help is appreciated - thanks!

 

(Nintex Forms 2.4.1.0)

Outcomes