[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SharePoint list unique records

Posted on 2011-03-25
1
Medium Priority
?
613 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 2000 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

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

649 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