Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Unique Autonumber across all table

Topic Labels: Formulas
Solved
Jump to Solution
6479 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is possible to have a unique id number from autonumber function across all tables?,
For example:
If I create a new record on table A, that record must be 1; but if I create another new record on table B must be 2

1 Solution

Accepted Solutions

Not as you’re describing. Autonumber’s functionality is frustratingly limited. But if you’d like unique identifiers associated with each record across any number of tables, you could do one of the following:

Use 'Record ID’
Each record already has a unique identifier. It’s a hash generated by Airtable’s backend tools. You can see it in a field by creating a formula field and entering RECORD_ID() in it. I’m not sure if it’s possible for a hash to be reused across multiple tables, but I’d imagine it’s unlikely. If you’re worried see the next section.

Create a Custom ID
If you’d like more control over the ID name, you could add words onto an autonumber. For example, the name of each table. That way even if multiple tables have the same number, their respective names will ensure a unique value. It might look like this:

First Table

Autonumber (autonumber)
1
2
3

Custom Record ID (formula)
FirstTable1
FirstTable2
FirstTable3

Formula:
"FirstTable"&{Autonumber}

See Solution in Thread

1 Reply 1

Not as you’re describing. Autonumber’s functionality is frustratingly limited. But if you’d like unique identifiers associated with each record across any number of tables, you could do one of the following:

Use 'Record ID’
Each record already has a unique identifier. It’s a hash generated by Airtable’s backend tools. You can see it in a field by creating a formula field and entering RECORD_ID() in it. I’m not sure if it’s possible for a hash to be reused across multiple tables, but I’d imagine it’s unlikely. If you’re worried see the next section.

Create a Custom ID
If you’d like more control over the ID name, you could add words onto an autonumber. For example, the name of each table. That way even if multiple tables have the same number, their respective names will ensure a unique value. It might look like this:

First Table

Autonumber (autonumber)
1
2
3

Custom Record ID (formula)
FirstTable1
FirstTable2
FirstTable3

Formula:
"FirstTable"&{Autonumber}