Skip to main content
Solved

Adding a numerical ID when a record is created

K
Forum|alt.badge.img+3

Hello!

I am trying to set up a work request form, and am stuck on one part. I’m not sure whether I need to use formulas or automations, but I’ve scoured help videos and articles to no avail trying to find what I’m looking for.

I would like to have a numerical Work Order ID (basically a consecutive numerical number) added to a record field as soon as the record is created.

Ideally, I’d love for it to take this form (Year-####), as that’s the current system we use, but I’d settle for just a unique numerical number for each new record created.

I’m sure this is simpler than I’m making it out to be, but any help would be appreciated. Thank you!

Best answer by augmented

Hi Kristen. Here’s Airtable’s autonumber field. You can combine that in a formula field with the YEAR function. However, it’s a basic solution. You may want to format the autonumber field itself to be a set number of digits (maybe with prepended zeros).

YEAR(TODAY())&'-'&{Autonumber field}

View original
Did this topic help you find an answer to your question?

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • August 10, 2021

Hi Kristen. Here’s Airtable’s autonumber field. You can combine that in a formula field with the YEAR function. However, it’s a basic solution. You may want to format the autonumber field itself to be a set number of digits (maybe with prepended zeros).

YEAR(TODAY())&'-'&{Autonumber field}

K
1 person likes this
  • K
    Kristen_Waggene
K
Forum|alt.badge.img+3
augmented wrote:

Hi Kristen. Here’s Airtable’s autonumber field. You can combine that in a formula field with the YEAR function. However, it’s a basic solution. You may want to format the autonumber field itself to be a set number of digits (maybe with prepended zeros).

YEAR(TODAY())&'-'&{Autonumber field}


Thank you! This is exactly what I needed.

NLOIA
Forum|alt.badge.img+8
  • NLOIA
  • Inspiring
  • March 30, 2025

Hi!

    Nice thread guys!

     I have the same issue: Cannot create an automatic column that generates automatica incremental row numbers.

     I already posted another thread for this, but no solution at all. (link below)

     With the solution here: YEAR(TODAY())&'-'&{Autonumber field}  I’m able to generate a partial win because it still includes a new line with the latest number of the table in the middle of these tasks.

     As in the print screen, I need that the brand new number to be correctly inserted between #7and #9, updating all other numbers below, previously created.

     I am afraid it’s not possible through formulas.

 


 

https://community.airtable.com/automations-8/how-to-automatic-create-wbs-work-breakdown-structure-aka-hierarchical-or-outline-numbering-23595

 Thank you!

Reply


Most helpful members this week

Terms & Conditions