Skip to main content

Are Airtable Record IDs unique across Tables? Across Bases?

  • February 11, 2018
  • 4 replies
  • 67 views
R
Forum|alt.badge.img+3

I’m curious to know if record IDs like reciw1K6rcYbpRN0o are unique for a table, unique for a base, or unique across bases for an organization.

    4 replies

    K
    Forum|alt.badge.img+4
    • Kasra
    • Inspiring
    • 192 replies
    • February 11, 2018

    Hi Roman,

    They are currently globally unique, but you shouldn’t count on this being the case in the future. We may change them to only be unique within a base, so it would be best to always store the base ID (begins with app) alongside the record ID in external systems.

    R
    Forum|alt.badge.img+3
    • Roman_Scher
    • Author
    • Participating Frequently
    • 8 replies
    • February 11, 2018

    Hi Roman,

    They are currently globally unique, but you shouldn’t count on this being the case in the future. We may change them to only be unique within a base, so it would be best to always store the base ID (begins with app) alongside the record ID in external systems.


    Thanks Kasra!

    Is it correct then that record IDs are never reused within a base, even after records are deleted?

    K
    Forum|alt.badge.img+4
    • Kasra
    • Inspiring
    • 192 replies
    • February 12, 2018

    Thanks Kasra!

    Is it correct then that record IDs are never reused within a base, even after records are deleted?


    That’s generally true, but we can’t guarantee that outside of your plan’s data retention period.

    C
    Forum|alt.badge.img+1
    • cgarv16
    • New Participant
    • 1 reply
    • March 5, 2023

    hey @Kasra it would be great if we could access the base ID from within a formula function to allow for creating a globally unique record ID


    Terms & ConditionsAccessibility statement