This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’d like to be able to choose a custom starting number for the auto-incrementing number field - I have existing records that already have a unique ID # associated with them, but they don’t start at 1.
Not sure when, or if, they will implement this - but a workaround would be to combine your existing ID #s with an auto number field to generate a new, combined ID# that auto increments.
For example, if you have your existing ID# starting number, let’s say 100 for the example, you would make an auto number field, and then another new formula field which would look something like this:
100+{NewAutoNumberField}
Which would then create new auto numbers starting at 101.
Or check this thread from a while back for some ideas in the interim:
This doesn’t seem like a good solution, though. This results in numbers 1001 through 1009, and then would begin 10010 through 10019, eventually resulting in 100100 through 100199, etc.
Hi there,
I have an another solution by creating another table with just one record and using one automation.
Create Table (“Table 3” in my exemple)
Calculation Field = “Number” + 1
-Create an automation
Trigger : When a record is created (in your main table)
Action1 : Find Record in “Table 3” with “Name = NumAuto”
Action 2 : Update record (main table) with “Field to auto-increment” = “Table 3” Calculation Flield
Action 3 : Update record (Table 3) With field “Number” = Field “Calculation”
I hope i had well describe my solution (english is not my native) and this will help people