Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Reset "ID" to Zero - Can it be done?

  Asked By: Zoe    Date: Feb 19    Category: Sharepoint    Views: 9423

I have a document library set to automatically increment a document number and
it works great thru all my testing. Each time a document is added, the library
assigns the next sequential number to it. I used calculated fields and a
custom-workflow for it. This is how I did it:

First create a new field called FormId, then in SharePoint Designer create a
workflow to run when a new item is created, leave the Condition field blank and
under Action, select Update Item, FormId = (current item) ID. This workflow
will now copy the ID field to the FormID field.
Next, change both your calculated fields to run against the FormId field instead
of the ID field:
ID Set
=IF(FormID<10,"000",IF(AND(FormID<100,FormID>=10),"00",IF(AND(FormID<1000,FormID\
>=100),"0","")))
Incremental Form ID ="P"&ID Set&FormID
This will result in the assigning an incremental number to a new item when it is
created.

My problem is that now that I am done with testing, I want to start loading in
real documents, but I want to start over again and have the first document
be 1 . How do I do this?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Ebony Perkins     Answered On: Feb 19

As far as I know you can't reset  this ID without deleting and recreating the
document library. It is managed internally by the system and can't be changed
programmatically.

 
Didn't find what you were looking for? Find more on Reset "ID" to Zero - Can it be done? Or get search suggestion and latest updates.




Tagged: