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

UPDATE: I WAS WRONG

You can’t do this…

However, there is a hack…

Let’s say you wanted to start incrementing records from 19. When you create your workspace, go ahead and create 20 dummy records in your table with the auto-increment field. Then destroy all those records. After that, you’ll have effectively configured your database to start incrementing numbers starting at 20.

#5

You can’t do it with Auto increment fields. See the screenshot attached.

01%20PM
Screen Shot 2021-03-09 at 5.50.01 PM.png733Ă—347 20.2 KB

#6

You can’t do this…

However, there is a hack…

Let’s say you wanted to start incrementing records from 19. When you create your workspace, go ahead and create 20 dummy records in your table with the auto-increment field. Then destroy all those records. After that, you’ll have effectively configured your database to start incrementing numbers starting at 20.