Skip to main content

Can interfaces connect with and draw data from multiple bases?

  • August 3, 2022
  • 3 replies
  • 530 views

Forum|alt.badge.img+4

Creating a CRM and I was hoping to create a master interface to act as a management dashboard and draw from multiple different bases. Is this possible? or does all the information have to be in one base under different tables?

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • August 4, 2022

An interface can only pull from one base.

However, you can sync views from other bases to a single destination table (or multiple destination tables) in a base. Then you can pull your interface from there.

However, note that the data will be read-only in your destination table, so that may be a dealbreaker for you. Also, when you sync bases, there is a maximum number of syncs that you can setup.

Your best bet would probably be to create your dashboard in another app — something as simple as Google Sheets or Microsoft Excel, or something as complex as Databox or Tableau — and then use Make to automate the sending of your data from Airtable to those other tools.

There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. 

Also, if you have a budget for your project and you’d like to hire an expert Airtable consultant to help you create this, please feel free to contact me through my website: Airtable consulting — ScottWorld.


Forum|alt.badge.img+6
  • Participating Frequently
  • August 5, 2023

Any plans to change this with the new mobile interfaces. It's a real draw back not allowing multiple bases in one interface.


Forum|alt.badge.img+3
  • New Participant
  • March 8, 2024

Any plans to change this with the new mobile interfaces. It's a real draw back not allowing multiple bases in one interface.


Honestly it really is. I don't understand why inter-base tables is such a difficult task. The only reason I have for an interface is to use multiple tables across bases. Otherwise I might as well use the tables themselves. I would like one interface for our team using compiled information from all of my bases not 10 different bases and the same number of interfaces