Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using auto numbering

372 0
Showing results for 
Search instead for 
Did you mean: 

I use an auto numbering algorithm to assign client ID # to each new client.
I need to convert my existing client database into Airtable with the existing ID # but need all new entries to use an auto assignment. (I see that Airtable will not allow me to enter the ID number in the field if I have it formulated to auto-number, so I cannot override it). So, how do I convert my existing records and then auto number within the same field?

Also, my current ID schema is “0660” followed by the 2-digit year followed by a 2 digit auto number. For example, the last client I signed in 2019 (using previous database application) was 06601953. I need my first client for this year to be 06602001 and all remaining this year to be 02, 03 and so on. What is the formula for that?

0 Replies 0