How to manage tasks from multiple bases?

We are setting up Airtable to manage multiple projects and multiple teams. Each project has its own Base, and each Project Base has its own task list.

Is there a way to see all tasks across all projects in one place?

One of the main problems we are trying to solve is to find a way for each team member to see all of his or her tasks in one place even though they are located in various bases.

Thanks for the help and suggestions.


Hi @Jason_Dunn,

Yeah, this is a great question and one that I’ve spent a little time thinking about, although no actual implementation as yet. However, I have implemented a multi-base search engine for internal use at one of my clients and it smacks of similar functional requirements such as a unified index of bases and their tables.

Observations …

  • To achieve a single roll up of tasks by team member, it probably makes sense to do that in [oddly] a dedicated tasks base.
  • There are other questions to consider in terms of security - i.e., should a task base contain all tasks for all team members that are easily viewed by member responsibility, project, milestone date, etc?
  • I suspect a well-crafted Integro integration model could be used to capture all tasks and replicate them into a unified base/table, although, my gut tells me an API process might be an approach worth considering (I have a hammer and I want to pound all things API ;-). I would certainly make an attempt to prototype this using Integro or Zapier first.