SP07 - Auto_Increment Column

Question

I have a column with name "Title " and want to make my column be a auto increment (1, 1) with Calculated column option. How to do it ?

Answer 1

Best is that use ID column. It is not possible with only calculated column option. You have to set workflow for auto increment value.

Answer 2

It is possible with a Calculated Column,
but the Workflow method of incrementing is the best way to go.

If you can not do Workflows and are stuck to Calculated Columns then the full details are at:

Why you can not use [ID] : Calculated column with ID removes ID number on update

How to workaround it: Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula

DISCLAIMER This is not for the faint of heart!

Answer 3

You can use the auto increment value from the id field and put it in the formula field:

[ID]

Answer 4

Alternatives

1) Use ID

It is the best option because SharePoint ensures its uniqueness. But you can not apply business logic. It starts at 1 and increases by 1. You will have gaps when records are deleted.

2) Event handler

Create an event receiver to generate increased values according to the logic that you need. You need Visual Studio and C#.

3) Workflow

It can be an alternative. But workflows are not planning for it. The advantage is that you do not need to develop in C# as in option 2.

Important

Do not use the ID field within a calculated field: - You will have trouble inserting a record. It will work well in the modification. - It is not officially supported by Microsoft

If you need further assistance, please consult me. Greetings!