Create coloum as index
Dear All,
I have Custom list. I created coloum called "IndexNo" which i dont wanna be duplicate when user enter the data. How can i make it?
Its mean, i want to create colomn which user cant enter same index number again & again.
Regards
lasantha
November 22nd, 2010 8:12am
You can use this codeplex project http://features.codeplex.com/ that add an information policy to manage unicity on a column.
You could also use event receivers to achieve this (block duplicate records).
Check out this post that discusses the same question :
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/869a4ce5-2d55-40d9-9071-5795025c94a8
Florin DUCA - MCSE 2003 +Sec,MCTS conf/dev WSS3/MOSS, MCITP/MCPD SP 2010, MCPD ASP.Net 3.5, MCTS ISA 2006 - Logica Business Consulting, France
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 8:36am
i solve this solution in my previous post.
http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/7ff4730c-b0c1-4d13-8134-2449ef4525ab
November 22nd, 2010 9:06am
Thank you lots, Its work. But I am getting error when i create same record (IndexNo)
________________________________________________________
Server Error in '/' Application.
Column 'Serial Number' must have a unique value within the list.
Description:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
-------------------------------------------------------------------------------------
Regards
lasantha
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 6:01am
Well it's the standard SharePoint Error page. It should be a little more user friendly if you re-enable custom errors (I guess you disabled custom error for debugging).Florin DUCA - MCSE 2003 +Sec,MCTS conf/dev WSS3/MOSS, MCITP/MCPD SP 2010, MCPD ASP.Net 3.5, MCTS ISA 2006 - Logica Business Consulting, France
November 23rd, 2010 6:22am