I have 2 columns (first name and last name) in a SharePoint custom list. I have a calculated column called "full name" just concatenates the first and last name columns.
Due to requirements, I need to be able to store the first and last names in separate columns which is why I used a calculated field for the full name so that users don't need to enter the full name a second time.
However, I need to be able to verify that a "full name" is unique to the list. Is there a way to apply a uniqueness validator on a calculated column? If not, are there any possible solutions to verify the uniqueness of a full name?