Dec 23, 2021 11:51 PM
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?
Dec 24, 2021 12:05 AM
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.
Dec 24, 2021 12:34 AM
problem with this is that my source base is updated automatically. So a copy will drift out of synch quickly.
Dec 25, 2021 05:12 AM
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.
Aug 03, 2022 12:10 PM
Hey @DanielP you could use Whalesync’s Airtable x Airtable sync to accomplish this. It supports linked records across synced tables.