Skip to main content
Solved

Single or Multiple Bases?

  • March 13, 2026
  • 6 replies
  • 63 views
AdamPilat
Forum|alt.badge.img+2

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

Yeah the two biggest ones are:

  1. Automations can’t create records in synced tables

     

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

 

Adam

6 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

 
Adam, Airtable Consultant - thetimesaving.company
    AdamPilat
    Forum|alt.badge.img+2
    • AdamPilat
    • Author
    • New Participant
    • March 13, 2026

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

    Adam
    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 an ‘Actions can’t be added following an action that updates a synced field’ notice:

     

    Adam, Airtable Consultant - thetimesaving.company
      AdamPilat
      Forum|alt.badge.img+2
      • AdamPilat
      • Author
      • New Participant
      • March 16, 2026

      Thanks for the additional feedback, Adam. Having automations create records is a key component to my workflows. You’ve made the decision for me. Thanks again.

      Adam
        anmolgupta
        Forum|alt.badge.img+3
        • anmolgupta
        • Participating Frequently
        • March 16, 2026

        Based on my experience, I recommend keeping all the tables in one base unless the data between departments is not shared at all (but that’s usually not the case). A customer’s data typically flows across departments. Hence, in order to have a single source of truth - keeping all the tables in one base is the way to go.

        In RDBMS terms, a base is very much like a database instance itself in which you can define relationships between different entities. But you can’t define relationships between entities belonging to two different databases altogether.

        Keep them in one base and you will have a clean and normalized database. And you are anyway planning to access the data through interfaces + forms which is another good thing. Base should not be ideally touched by end users directly.

        Anmol Gupta | Founder PhotonMan.ai
          AdamPilat
          Forum|alt.badge.img+2
          • AdamPilat
          • Author
          • New Participant
          • March 16, 2026

          Anmol, I appreciate your feedback. That has confirmed the decision. Many thanks.

          Adam
            Terms & ConditionsAccessibility statement