Is it possible to set the initial auto-increment value of a field?
With thanks, Theodore
Is it possible to set the initial auto-increment value of a field?
With thanks, Theodore
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.
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