Nintex form: Validating a field entry against all list items

[voelkc]

I am working with a task list named "Tasks" and would like to validate that entries made into the field "Title" are unique.

How can I validate in my Nintex form against those requirements?

Can I use the custom validation option in the form settings or do I use "calculated value"?

I am already validating to use only certain characters with "Regular Expression".

Any help to create the formula is helpful.

Thank you in advance!

Christian

[rhia]

Hi there - 

So if you use custom validation, you're going to need a JavaScript function. 

I think another way to do it (off the top of my head) is to use a List Lookup control to lookup "Title" and display "Created". If it's populated at all (ie if Created = greater than 1/1/1900) then that means it's not unique, as it's found a match. Otherwise, it's good. I'd validate off that.

But ... JavaScript would likely be the better way if you're good with it. I ... am not.  

Cheers,

Rhia

[emha · Accepted solution]

checking for uniqueness in forms is not reliable.

your better option is to configure Title list field itself to 'Enforce unique values'

[voelkc]

Maybe using "Enforce unique values" in the columns is also an option. Thoughts?

[emha]

definitely!

... as I already recommended in previous post