question

CiprianPopovici-5292 avatar image
0 Votes"
CiprianPopovici-5292 asked MichaelHan-MSFT commented

unique values for multiple columns SHAREPOINT LIST

Hello,
I need to enforce unique values for some columns in a Sharepoint list but cannot find a solution that is working. This columns are formatted as Date and as Person. OOTB permit only one column at a time to be unique.
I find an article bellow using this javascript code that is placed on the newpage.aspx but cannot make it work.

This is the code that i try to modify , from site bellow. I also made a list with exact this fields ,but it's not working. Can you tell me what i do wrong?

https://www.codeproject.com/Tips/1205585/Unique-Entries-Based-on-Multiple-Columns-in-Sharep?fid=1926122&df=90&mpp=25&sort=Position&spc=Relaxed&tid=5722003


office-sharepoint-server-development
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT answered MichaelHan-MSFT commented

Hi @CiprianPopovici-5292,

The code in that article only works for single text type columns. You can noticle that columns(Title,Name,Email) used in the aritcle are all text type. While you are using Darte cloumn and Person column. These type columns will not work with the code.

So, you have to change your columns to text type to use the code. Otherwise, you have to use the OOTB that permit only one column at a time to be unique.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @CiprianPopovici-5292 ,

Is there anything update? If my reply helps you, you could mark it as answer.

0 Votes 0 ·