Set the initial auto-increment value

#1

Is it possible to set the initial auto-increment value of a field?

With thanks, Theodore :slight_smile:

#2

Yup! Make a number field and choose auto-increment in the advanced settings.

23%20PM
Screen Shot 2021-01-25 at 6.32.23 PM.png2672×1646 335 KB

#3

Hi @sebastian.scholl and thank you,

Following setting up an auto-increment field, is it then possible to set its initial value i.e. start the increment at a specific number instead of starting the count at zero.

#4

Using the Number Field with Auto Increment doesn’t allow you to specify a starting point. However, if you wanted to create a calculated field (stored or virtual) that uses the Auto-Increment field in a calculation, you could do that.

For example:

Text Field -> Calculated -> Virtual

CONCAT(autoIncrementFieldName + 10, "-some-string").

Then your first record’s field value would be would be:

11-some-string