Skip to main content
Solved

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

  • October 23, 2023
  • 4 replies
  • 287 views

Robert_Jurado
Forum|alt.badge.img+4

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.

Best answer by Alexey_Gusev

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


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.

4 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • October 24, 2023

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...)


Robert_Jurado
Forum|alt.badge.img+4
  • Author
  • Participating Frequently
  • 6 replies
  • October 24, 2023

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.   


Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • Answer
  • October 25, 2023

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


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
Forum|alt.badge.img+10
  • Known Participant
  • 11 replies
  • July 11, 2024

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.