How do I create unique record ID's?

I’d like each record in my table to have it’s own unique ID.
I’ve tried the “Autonumber” field type, but record numbers don’t stay unique when I filter and change views.
I’m sure there’s probably a simple way to do this … but unfortunately I don’t know how.
Can anybody shed some light please?
Many thanks in advance.
Btw, Airtable is awesome!!

Hey there, Andy - This should be quite straightforward, because all of your records has its own unique ID, and in order to surface it in your table, you can just use the following formula:


Hope that helps! Screenshot 2020-01-25 at 11.04.25

Thanks for this, just done it :~)
The ID’s seem to be quite large complex numbers (eg; recjXtxBLtwLJZcMB)
is there a way that I can simplify them so that they are just a few characters, for example 3452, MH475, MJ44 etc, something like this?

1 Like

So you want it to be unique, but not too unique? :joy:

Yeah - The best way for you to do this would be just to take the last 5 characters, I guess… But ultimately you’re not going to be able to do much better than what Airtable has done here.

I’d suggest you combine the last 3 or 4 characters of Airtable’s record ID with another string in your base…I’m not quite sure what your use case here is.

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.