Adding a numerical ID when a record is created

[Kristen_Waggene]

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!

[augmented · Accepted solution]

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}

Airtable Support

Autonumber field

An autonumber column automatically generates a unique, automatically incremented number for each record. Autonumbers can be helpful when you need a unique identifier for each record, or when using ...

[Kristen_Waggene]

Thank you! This is exactly what I needed.