a·gen·tic a·gil·i·ty

Unique ID in SharePoint list

TL;DR; SharePoint lists include a built-in unique, auto-generated ID column. Enable its display in list settings to show unique IDs for each item without custom solutions.

Published on
1 minute read
Image
https://nkdagility.com/resources/IydVW3AXWCp
Subscribe

This seams to be a common problem, and one that I get many calls from users about:

Unique ID in SharePoint list

I have a query with our Sharepoint site and was advised that you were probably the best person to ask.

I have created a list under:

http://sharepoint/sites/department/Lists/ListName/AllItems.aspx

I need the first column (Issue ID) to be an automatically generated number but can’t seem to get it.  Would it be possible for you to take a look and advise?

You can’t add a new unique auto-generated ID to a SharePoint list, but there already is one there! If you edit the “All Items” view you will see a list of columns that do not have the display option checked.

There are quite a few of these columns that exist but that are never displayed, like “Created By” and “Created”. These fields are used within SharePoint, but they are not displayed by default so as not to clutter up the display. You can’t edit these fields, but you can display them to the user. if you check the “Display” box beside the ID field you will get a unique and auto-generated ID field displayed in your list.

Technorati Tags: SP 2007   Answers   SP 2010   SharePoint

Subscribe

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

NIT A/S

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Schlumberger Logo

Schlumberger

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Graham & Brown Logo

Graham & Brown

Alignment Healthcare Logo

Alignment Healthcare

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Teleplan Logo

Teleplan

Freadom Logo

Freadom

Slicedbread Logo

Slicedbread

Lean SA Logo

Lean SA

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Philips Logo

Philips

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

Hubtel Ghana Logo

Hubtel Ghana

Deliotte Logo

Deliotte

Akaditi Logo

Akaditi

CR2

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Royal Air Force Logo

Royal Air Force

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Nottingham County Council Logo

Nottingham County Council

Washington Department of Transport Logo

Washington Department of Transport

Philips Logo

Philips

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

Lockheed Martin Logo

Lockheed Martin

Kongsberg Maritime Logo

Kongsberg Maritime

Epic Games Logo

Epic Games

Sage Logo

Sage