Solved

SharePoint list unique records

Posted on 2011-03-25
1
609 Views
Last Modified: 2012-05-11
In my Sharepoint list I have a field called ID...   Is there a way to make sure that duplicated records with the same ID can not be added?
0
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
Rafael I earned 500 total points
ID: 35225576
There should already be a field that is used internally by SharePoint called ID.  This field is unique, uneditable, and is never duplicated.  It is also usually hidden from the user.  If you click on a list item to view it, you will notice in the address bar it says something like, "..\DispForm.aspx?ID=2"

If you want to display it on your EditForm and DispForm, you need to either get SharePoint Designer 2007 to customize the form (easy), or create a content query webpart to load it into the page using JavaScript (hard).

Other than that, it is very hard to create a field that will prevent duplicate entries because you would have to manually query your list, and see if your new record's field matches an existing one (Hard/Complicated).
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question