Is there a way to prevent a user from creating another new form which already exists in the sharepoint list? For example, there is already an item in the list with ID # A and name of Joe John.
A new person, goes to the list to create a new item. Nintex form appears and they enter ID # A and the name of Joe John. Can it flag them, while still in "new mode" to say that there is already a form with the same ID # and name to stop them from creating another one? There should not be 2 forms with the same ID # and name in the list.
I want to prevent the new user from creating a duplicate entry in my nintex form. Thoughts?
Hi - unfortunately no, you can have the same unique ID and a different person than the previous entry; it's when its the same unique ID and name combo.
How would you your suggestion on the calculated value control while creating a new nintex form as they won't have time to search first then enter; they want the flag/error to appear as they are creating a new form.
The calculated value control would look like:
If it comes up true then there is a duplicate.
You could add this rule on the save button to disable it.
It looks up the ID on the list and returns all the names. If the name is contained in the array it will return true. Tried to use inArray runtime function but it did not like the element being compared to a named control for some reason but contains works.
You could put this in an IF runtime function to display a message if you wanted. etc etc.
okay - so i tried this and it did not work... trying to use the fields that are in question:
Notification ID - is the # (contains alpha and numeric info)
Individual Accountable for Error - is the user's name
The areas that are underscored are from the named controls.