How can I utilize existing unique identifiers in Airtable?

Other Questions Airtable
1

I have an Airtable base containing the following details:

Company     Unique_Identifier

  A         123
  B         456
  C         789

I’m trying to configure the Unique_Identifier field as the record ID. Currently, Airtable generates an automatic Record ID which conflicts with my existing identifiers. I would like to keep my unique identifier without losing data or having to remove the existing ID field. Can anyone provide guidance on how to achieve this?

2

Hey Dave! As a workaround, you can link the Unique_Identifier field with a formula field. Use the formula to create a unique identifier from your existing one. This won’t overwrite the automatic Record ID but will keep your data intact. It’s a neat trick I’ve seen folks use in Airtable!