Help

I want to move a table to a different base, is it possible to keep the link information?

Topic Labels: Base design Data
Solved
Jump to Solution
3130 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Jurado
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table in a base, but I want to move this table to a different base.  However, I am using it as a linked table in other tables' fields.   Is it possible to move this table to another base and keep the linked record information on the other tables?  Or it will break the links?

Thanks in advance.

RJ
1 Solution

Accepted Solutions

Primary/Foreign keys relation exists 'under cover' and rely on record IDs.
If you want to preserve relations with high accuracy, you can add formula RECORD_ID() in your table and reflect it in foreign tables via lookup.
By way, if you paste a list of record IDs into link field, and these IDs exist in linked table, Airtable will turn it to real links.

See Solution in Thread

4 Replies 4
Alexey_Gusev
13 - Mars
13 - Mars

Hi,
You can copy instead of move. But if you need to delete a table from source base and save lookup info, edit lookup fields and turn them into static form (text, number, etc...)

So if I really want to move this table out of the base, I will lose the foreign link to this table.   

RJ

Primary/Foreign keys relation exists 'under cover' and rely on record IDs.
If you want to preserve relations with high accuracy, you can add formula RECORD_ID() in your table and reflect it in foreign tables via lookup.
By way, if you paste a list of record IDs into link field, and these IDs exist in linked table, Airtable will turn it to real links.

Rutger
6 - Interface Innovator
6 - Interface Innovator

another option is to sync a table to the new base. After the table is synced simply delete the sync and convert to un-synced table.