How to Display Data from Two Airtable Bases into One Interface

You’ve been using Airtable for a while now and set up two separate bases to manage your data. Over time, as your work evolved, you started to realize a lot of the information is actually quite similar and probably should live in just one place.

But since both bases are an important part of your daily workflow and have been used for so long by many people, you simply can’t scrap them and start fresh with a single unified base.

Now, you want to create a dashboard that combines data from both bases so you can see the full picture in one place. But Airtable interfaces only allow you to pull data from one base at a time. So how do you achieve this?

The solution is to create a new base that serves as your dashboard base. Then, you sync data from both of your original bases into this new one.

You have a couple of options for how to set this up.

You can sync each source into its own separate table if you want to keep the data from each base separate and organized.

In a dashboard, pages can be set up with multiple groups, and each group can pull data from its own source table. But you cannot combine data from multiple tables into a single group. So if your data is in separate tables, you’ll need to use multiple groups on your dashboard.

Or, if the tables have a similar structure, you can sync both sources into the same table in your dashboard base. This allows you to combine all the data into a single chart or report more easily.