Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Is there anyway to start the default ID column from specific number? For example start from 2151 instead of 1? Or is there any way to fill the items with values in order to reach 2151 in ID field and then stop filling automatically?

share|improve this question
add comment

5 Answers

ID can not be changed, but you can create another column for this ID purpose but remember you cant use ID column in calculated field so I would suggest you to go for ItemAdded event receiver, and in the event receiver you can do something like

item["NewID"]=item.ID+2150;

You can also achieve this using workflow if you dont want to use event receiver for this purpose

share|improve this answer
add comment

Maybe it's possible to use the document id feature? Here a link to a resource: http://msdn.microsoft.com/en-us/library/ee559302%28v=office.14%29.aspx

share|improve this answer
add comment

You cannot create column named ID. It is by default created by SharePoint itself. You cannot even rename it.

share|improve this answer
add comment

Or you can write a console application with a for cycle, which inserts 2150 entries into your list, then you can delete those entries. This way you will have an empty list where the standard ID column starts from 2151. But I suggest you do this only if you want to test some specific scenario in a test environment.

For a real business scenario, where you need a column that counts from 2151, you should consider something like @Diptarag's answer.

share|improve this answer
add comment

Following Norbet's advice, but instead of a console app, you could use an easy powershell script to loop through, add the item and then delete it. That'll get you to the ID number you want. It'll be taxing on SP/SQL (adding and removing) but it'll work.

However, I like Diptarag's advice more, just create a new field and perform the calculations your self.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.