I have a list of employees and two of the columns used are "Location" and "Initials". On my Nintex form, I want to add employees to my list, which is straightforward. However, at any location, two employees cannot use the same initials. If they are in different locations, same initials is ok. How would I use the Query function to accomplish this?
Essentially, if a new employee working in Location A chooses initials YZ, I have to verify that no one else in Location A is assigned those initials. If an employee in Location B has initials YZ, that is ok. The idea is to not allow the form to commit to the list until this check returns true (i.e. initials are not in use)
Thanks so much!!