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.​

DFDS Logo

DFDS

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Lockheed Martin Logo

Lockheed Martin

Kongsberg Maritime Logo

Kongsberg Maritime

Philips Logo

Philips

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

Genus Breeding Ltd Logo

Genus Breeding Ltd

Workday Logo

Workday

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Jack Links Logo

Jack Links

Graham & Brown Logo

Graham & Brown

ProgramUtvikling Logo

ProgramUtvikling

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Epic Games Logo

Epic Games

Trayport Logo

Trayport

Boxit Document Solutions

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Boeing Logo

Boeing

Nottingham County Council Logo

Nottingham County Council

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Washington Department of Transport Logo

Washington Department of Transport

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Royal Air Force Logo

Royal Air Force

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

MacDonald Humfrey (Automation) Ltd. Logo

MacDonald Humfrey (Automation) Ltd.

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

DFDS Logo

DFDS

Milliman Logo

Milliman

Slicedbread Logo

Slicedbread