Weekly Tip: Try to keep everything in one base as much as possible

When to use multiple bases vs tables

Let’s say you have a base for tracking your real estate deals

There are multiple tables here, including the Properties, Clients and Deals tables, which are linked

.

Now you want to add a task tracker to the process.

Your first instinct may be to create a new base for tasks. But this is not ideal

• Down the line, you may want to link tasks to deals, and then will have to deal with the overhead of base sync

• As the number of bases increase in your workspace, it can be hard to keep track of all the bases you have floating around, keeping all associated data in one base as much as possible makes this much easier

So instead, we recommend you add tasks as a new table in your existing base

This makes linking way easier!

If your bases are small, we’d recommend consolidating your bases into one sooner rather than later- it’s much harder when things are complex.

Hope you find this tip useful! Subscribe for weekly tips like this in your inbox

Need help with consolidating bases into one?

Or need general help in your automation/Airtable/low-code setup? To work with us, contact us here

More resources

• https://support.airtable.com/docs/getting-started-with-airtable-sync