Solved

SharePoint list unique records

Posted on 2011-03-25
1
603 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now