Help

Re: Duplicate base and keep record ids

Solved
Jump to Solution
1302 1
cancel
Showing results for 
Search instead for 
Did you mean: 
cgduzan
4 - Data Explorer
4 - Data Explorer

Does anyone know of a way to duplicate a base while keeping the record ids the same?

We are trying to set up a "staging" instance of our Airtable tables but we have references to the record ids outside of Airtable. This causes all of the references break because new records ids are generated when we duplicate the base.

Is there any way around this?

Thanks,

Chris

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

It is not possible to keep record IDs (or any of the ids) the same when duplicating a base. Can you set up your system to reference records by name or some other property?

See Solution in Thread

3 Replies 3
kuovonne
18 - Pluto
18 - Pluto

It is not possible to keep record IDs (or any of the ids) the same when duplicating a base. Can you set up your system to reference records by name or some other property?

Thanks for the quick response!

Unfortunately, it would take some re-architecting to reference a different field.

I may look into creating a script that grabs another unique value from the table and uses that to map to the correct record id in the staging table.

BenFortunato
6 - Interface Innovator
6 - Interface Innovator

I am running into a similar problem. Did you find a workaround? In general setting up a staging environment with airtable seems to be an afterthought. We are going to move to supabase so we have something a bit more robust, but this is a whole process since we'll have to create a front end for all our interfaces.

The only thing that I can think of is storing the id in a text field and then referencing that instead of the airtable record.id. That way you are still referencing the "id" but instead of accessing that through the build in property you are accessing it through a text field named id or uid if you want to distinguish it.