Dear,
We have a Sharepoint list that uses the ID value to generate a unique number using a workflow.
The list was ok, however after deleting a row, the ID value keeps increasing like the example in the picture. Instead of attributing the ID 110, it gives the number of row that have been created so far, which is 120.
Any ideias?
You can still use that system. Â Just don’t delete items. Â You can “close” those items you con’t want to see anymore by giving them a status field. Â You can set up another view for those “closed” items to move to.
I have a formula that takes the column ID (based on the creation order) to generate a unique number that goes in our documents.
Is there anything that I can do in order to still use this system?Â
That is correct. Deleted items still increment and are not deleted. They are moved into the two stage recycling and may need to be recovered, so no overwriting.
Take a look in the list attached:
I only have 7 items and it starts counting on 9! It is considering the previous items that I have created and deleted.
Is that correct?
That is correct functionality for an ID column, if you want a total count use a calculated field that equals the count+1, but realize if you create an item, then delete a different item and add one again, they will have the same number. That is why ID increments Total created and does not consider deletions.
