Nintex form: Validating a field entry against all list items

  • 16 February 2018
  • 4 replies
  • 7 views

Badge +1

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


4 replies

Userlevel 6
Badge +15

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. happy.png 

Cheers,

Rhia

Userlevel 5
Badge +14

checking for uniqueness in forms is not reliable.

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

Badge +1

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

Userlevel 5
Badge +14

definitely!

... as I already recommended in previous post happy.png

Reply