Skip to main content

Syncing views from multiple tables without losing linked records

  • December 24, 2021
  • 4 replies
  • 51 views

Forum|alt.badge.img+9

Let’s say I have a Base with 2 tables “people” and “countries”. The people table contains a “country” column that links to the “country name” column in the countries table.

Now I want to sync the grid view in BOTH tables to a new base (so that the new base also contains 2 tables). At the moment, I do this 1 table/view at a time, and in the process I lose the links between the tables (so that the “country” column in the people table ceases to be a linked record and becomes plain text).

Is there any way to sync multiple/linked tables without losing the links?

4 replies

Databaser
Forum|alt.badge.img+25
  • Brainy
  • 868 replies
  • December 24, 2021

Hi @DanielP and welcome back to the community!

You could just copy the base itself if you don’t have to merge the data with other, already existent data. Otherwise, I don’t think it’s possible.


Forum|alt.badge.img+9
  • Author
  • Inspiring
  • 14 replies
  • December 24, 2021

Hi @DanielP and welcome back to the community!

You could just copy the base itself if you don’t have to merge the data with other, already existent data. Otherwise, I don’t think it’s possible.


problem with this is that my source base is updated automatically. So a copy will drift out of synch quickly.


Justin_Barrett
Forum|alt.badge.img+21
  • Inspiring
  • 4647 replies
  • December 25, 2021

To confirm what @Databaser said, this isn’t currently possible, at least not without building your own re-syncing system that recreates links between the synced tables in the destination base.


matthew_b
Forum|alt.badge.img+17
  • Known Participant
  • 64 replies
  • August 3, 2022

Hey @DanielP you could use Whalesync’s Airtable x Airtable sync to accomplish this. It supports linked records across synced tables.