Skip to main content
Nintex Community Menu Bar

Nintex form: Validating a field entry against all list items

  • February 16, 2018
  • 4 replies
  • 43 views

Forum|alt.badge.img+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

rhia
Nintex Partner
Forum|alt.badge.img+15
  • Nintex Partner
  • February 17, 2018

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


Forum|alt.badge.img+14
  • Scholar
  • February 19, 2018

checking for uniqueness in forms is not reliable.

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


Forum|alt.badge.img+1
  • Author
  • February 19, 2018

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


Forum|alt.badge.img+14
  • Scholar
  • February 19, 2018

definitely!

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