Member-only story

Clone data in Airtable bases with Sync Tables!

Greg Vonf @ Business Automated
3 min readOct 17, 2020

--

Finally, Airtable introduced a way how to natively synchronize data between bases.

Photo by Tiffany Combs on Unsplash

Moving data between Airtable bases was one of the most requested features for a long time. Very often you might have sensitive information in some tables of your base and you might not be willing to provide access to all of its entirety. Previously the solution to clone data out of one base into another was to use external tools such as Zapier or Integromat to clone it. You can read here an article about copying Airtable data between bases using Integromat.

The Integromat solution might still be a viable option if you are on the Free Airtable plan. Free Airtable plan allows 1 sync table and you need to sync it manually. The Pro plan on Airtable allows for up to 20 sync tables per base and has an automatic syncing capability.

Creating a synced view

Sync tables in Airtable work based on views, so you need to create first a view of data that you would like to transfer to another Airtable base.

Usually, you would use a filtered view to show for example products belonging only to 1 category or group.

--

--

Greg Vonf @ Business Automated
Greg Vonf @ Business Automated

Written by Greg Vonf @ Business Automated

Greg is the founder of Business Automated, an agency helping small businesses streamline and simplify their processes. For more visit www.business-automated.com

No responses yet