Skip to main content
Solved

Single or Multiple Bases?

  • March 13, 2026
  • 3 replies
  • 12 views

AdamPilat
Forum|alt.badge.img+1

Hi! I’m a first-time poster here. I hope the below makes sense. Here goes.

I’m a Marketing Coordinator and we have a team of 6. I am redesigning our Airtable base, so that it aligns with best practices and utilises the functions within Airtable more efficiently. Currently everyone works directly from tables, with no interfaces or automations. I have a fairly good understanding of Airtable and it’s capabilities. Our team has deliverables associated with multiple departments and with many external partners. I am starting from scratch, building workflows and the likes, having inherited the Airtable space.

Departments include:

  • Product
  • Sales
  • Partnerships (including events)
  • Customer Service
  • Retail

Requests include tasks for:

  • Social Content
  • eCommerce
  • Web and SEO
  • Photography and videography
  • Print and digital design (for catalogues, sales conferences, specialty customer product promos, website, etc.)
  • Photo and video processing, editing and creation

My question is; would it be suitable to have all tables relating to each department in one base? Or build bases for individual departments and link them? Teams in those departments will ideally use interfaces and forms to request tasks, that will be turned into projects, or campaigns, and at times cross paths. Mostly each of the marketing team members will work on individual aspects of those requests to reach a common goal.

Sorry. Long-winded, I know. But I’m in two minds.

Thanks in advance.

Adam

Best answer by TheTimeSavingCo

Hm, you mention that it crosses paths at times and so I’d recommend keeping them all in one base.  Multiple bases is doable, but ime syncing stuff between bases is more trouble than its worth due to the limitations around automations and synced tables

The main thing that might change the calculus is if a specific department’s data might cause us to break record limits, and in that case yeah I’d say build it in multiple bases with an eye on how to maintain continuity

 

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hm, you mention that it crosses paths at times and so I’d recommend keeping them all in one base.  Multiple bases is doable, but ime syncing stuff between bases is more trouble than its worth due to the limitations around automations and synced tables

The main thing that might change the calculus is if a specific department’s data might cause us to break record limits, and in that case yeah I’d say build it in multiple bases with an eye on how to maintain continuity

 

AdamPilat
Forum|alt.badge.img+1
  • Author
  • New Participant
  • March 13, 2026

Hmm, great point, and advice, Adam. I’ll do more research into the limits. Thank you.


TheTimeSavingCo
Forum|alt.badge.img+31

Yeah the two biggest ones are:

  1. Automations can’t create records in synced tables

     

  2. Automations that update synced tables get hit with a ‘Actions can’t be added following an action that updates a synced field’ error: