Setting custom field as primary key instead of auto-generated record ID in Airtable

Other Questions Airtable
1

I’m working with an Airtable database that has this structure:

Business Name    Code
Alpha Corp       001
Beta Inc         002
Gamma LLC        003

I want to use my existing Code column as the main identifier for each record, but Airtable keeps creating its own automatic Record ID field. Is there a way to make my custom Code field work as the primary identifier without losing the data I already have? I’ve tried a few things but they end up replacing my original values. Any suggestions on how to handle this properly?

2

hey, looks like you’re stuck. truth is, you can’t switch the auto-record ID in Airtable. but try turning your Code into a formula field that references itself. it’ll look like your main ID without messing up your existing data. hope this helps!