Forum Discussion

M1keG's avatar
M1keG
Copper Contributor
Mar 21, 2024

SharePoint conditional uniqueness

Hi All,

 

I have a question about implementen custom column/list validation in SharePoint.

I have 2 columns that are important for validation. First one is the name, second one is the code connected to that name.

I want the user to be able to add new items to the list, where the name is free (no restrictions) but I want the code connected to it to be unique, but only if the name is different. So if a user adds the same name twice, I want it to be okay to use the same code (in fact is has to be the same). But if a different name is entered with the same code, I want it to give an error.

Below I have tried to visualize what I want to achieve, but I can't seem to find out how in Sharepoint.

 

Name

Code

Result

Name A

1010

TRUE

Name A

1010

TRUE

Name A

2020

FALSE

Name B

3030

TRUE

Name B

1010

FALSE

 

If anyone has any suggestions, I would love to hear them.

Resources