So, I'm completely new to Nintex / SharePoint related stuff.
I would like to compare the user input in a Nintex Forms field to already existing items in the same list.
Maybe my example will make it somehow clearly.
In a contact list, I got the column 'company name'.
When a user tries to create a new contact, and puts the company name 'Smith' in the field, I'd like the field to check the contents of the column 'company name', wheter the company name already exists or not.
Note: The user should still be able to create the contact, it should just be a reminder / note that this company name is already in the list.
Any help or tips are appreciated.
Solved! Go to Solution.
For my scenario, I have two lists - "Test" as my main list and "Customer" as the customer list. The scenario works the same way with a single list. Just adjust the formula accordingly.
When I type a customer name in the Title field of my Test list form, the calculated value field is supposed to show me a message highlighting that the customer already exists.
NOTE: the formula will only validate when you navigate out of the title field
Customer does not exist
Customer does exist
Hope that helps
thank you so much for this answer! I was able to get it to work the way I want it to!
Is it possible to change the color of the text that is being written in the calculated value control?
I cant seem to find it in the settings.
Thanks once again!
when you click on the control, you will notice the ribbon bar changing to the ribbon bar for the calculated value field. One of the things you can adjust there is the font style. That will do the trick for you.
Alternatively you can use CSS and apply a CSS class to the control, which you'd have to implement first under Form Settings.
Maybe I should've had a closer look before asking.
I saw it a couple of seconds after asking this.
Still thanks for your time!
I tried to implement your solution, but it does not work.
I am trying to check if a person already exists in my list an the field is a people picker.
Thanks in advance for your help.
One more thing, the function works in edit mode, but I would like it to work dynamically on the client side.
Thanks for your help.
I followed your steps , still not able to get the result. How can we debug this?
Thanks in advance