0

Is there a way to add new unique auto-generated ID for every new item added to a custom list? I would like the numbering to start at 300 as I will be uploading data to the list which already have been allocated a unique ID.

Many thanks

Harminder Singh
  • 565
  • 5
  • 22
Louise13
  • 79
  • 10

1 Answers1

0

List already had an auto Id field. This starts at 1 and auto increment as new entry is added.

You can create a calculated field and use a formula like

= 300 + [Id]
Amal Hashim
  • 28,306
  • 5
  • 31
  • 61
  • 2
    Just beware that using Id in calculated columns is not reliable: http://sharepoint.stackexchange.com/questions/22977/how-to-use-calculated-field-to-retrieve-the-id-of-the-item-in-the-sharepoint-200 – Robert Lindgren May 24 '16 at 14:22
  • The SharePoint auto ID is out of sync with my created ID due to testing and deleting dummy data, so I can use it, – Louise13 May 24 '16 at 14:29
  • Which is your SharePoint version? – Amal Hashim May 24 '16 at 14:30
  • Using a workflow to generate it would be more reliable, calculated columns with the ID column is horribly unreliable. – Eric Alexander May 24 '16 at 14:43
  • HI there, can you tell me how to create a workflow to do this? I would like my numbering to start from 300 – Louise13 Jun 14 '16 at 14:50