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

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Lean SA Logo

Lean SA

Emerson Process Management Logo

Emerson Process Management

Boeing Logo

Boeing

Qualco Logo

Qualco

Deliotte Logo

Deliotte

Healthgrades Logo

Healthgrades

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Ericson Logo

Ericson

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Bistech Logo

Bistech

Big Data for Humans Logo

Big Data for Humans

Trayport Logo

Trayport

Epic Games Logo

Epic Games

MacDonald Humfrey (Automation) Ltd. Logo

MacDonald Humfrey (Automation) Ltd.

Slaughter and May Logo

Slaughter and May

Slicedbread Logo

Slicedbread

Philips Logo

Philips

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Ghana Police Service Logo

Ghana Police Service

Washington Department of Transport Logo

Washington Department of Transport

Nottingham County Council Logo

Nottingham County Council

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

NIT A/S

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Trayport Logo

Trayport

Epic Games Logo

Epic Games

Lean SA Logo

Lean SA

Deliotte Logo

Deliotte