- 07 Jul 2022
- 9 Minutes to read
Structuring your Airtable bases effectively
- Updated on 07 Jul 2022
- 9 Minutes to read
When your information is collected together in one powerful database, organizing your tables, fields, and views effectively is key for both performance and collaborator usability. Here are some best practices to keep in mind as you're architecting new Airtable bases, and powering up existing ones.
Tips for best base performance
Base performance is tied to many factors related to base design. For instance, a table with many records or formula fields will load more slowly than a table with a succinct structure. Base performance will improve as a base is simplified and these improvements should be realized automatically as changes are made. Here are a few suggestions that may help improve performance:
- Use filters and hidden fields to create more targeted views. For instance, if a table has 30,000 records, but you only need to view records created in the past week, then you will likely be able to pare down the number of records shown in the view by setting up a filter or group of filters, resulting in much faster load times.
- Consider deleting any unused records.
- Eliminate any non-crucial Formula, Linked record, or Rollup fields. Pruning the complexity of your linkages or formulas can greatly reduce latency.
- If you're making many calls to the API, consider reducing API usage or inserting a pause in between calls; high write volume can affect base performance for large bases.
Other less common, but still relevant considerations include:
- Slow internet speeds - Run a speed test to determine if this is the root cause of the slow load times.
- Corporate networks may restrict or inhibit Airtable access - Check with your organization's IT department. If possible try accessing Airtable from another network source and note any differences in performance.
- Browser extensions - Certain extensions can cause performance issues. As a first step, check to see if the issue persists in Incognito Mode with all extensions toggled off? In Chrome, Extensions can be toggled off from chrome://extensions/. Other browsers would involve similar steps.
- Check whether or not Airtable is experiencing downtime - Airtable status page
Should I combine or split tables? What about bases?
How can you tell when you should split things up or keep them together? You can identify a base that could use an efficiency tune-up by keeping an eye out for one specific thing: redundancy.
Identify redundancy that results in too many tables
Redundancy surfaces in various ways, so let’s identify common characteristics that apply in each situation. You probably have too many tables if any of your bases meet any of the following criteria:
- You have multiple tables in the same base with similar and/or identical fields that don’t use linked records.
- You have multiple tables in the same base with similar structures and uses.
- You have a table that summarizes information in other tables without using linked records in the same base.
- You find yourself copying and pasting records or table structures often.
- You have multiple tables in the same base that track different stages of projects or deals, even if those tables have different structures and fields .
- You create new tables for different time periods (e.g. weeks, months, quarters, etc.).
- You create new tables that target different platforms (e.g. social media like Facebook and Twitter).
- You create tables categorically (e.g. different types of products, music or movie genres, types of events, etc.).
- You create tables for each member of your team or for specific collaborators.
In each case, you have an opportunity to combine multiple tables into one. For example, if you create a single table for each member of the team they likely have the same structure or a similar one. Instead, you can use a collaborator field (or even just a text or select field ) to assign tasks to individual collaborators and group records to keep them separate.
Furthermore, you can create individual views that use filters to only display tasks for one collaborator at a time. You can use a separate view to see everything at once while also sharing individual views with each member of your team.
You may find it difficult to combine your existing tables if you’ve used a redundant structure for a while. For some additional step-by-step help that provides solutions to these common dilemmas, consult this support guide.
Identify redundancy that results in too few tables
Sometimes you’ll find redundancy in the opposite direction, however, and need to create an additional table (or tables) to avoid it. Consider the following scenarios to identify this type of problem:
- You find yourself entering the same information into the same table multiple times (e.g. contact information when tracking activities or information about the parent project for tasks on your to-do list).
- You have a single table that keeps track of the same thing using multiple records.
- You have a single table with more than one select field and those select fields commonly relate to one another.
In most cases, if you find yourself repeating the same data you can avoid this by creating a second table and linking records together. If you skipped the earlier sections concerning linked records, go back and check them out to see how you can easily solve these problems so you don’t wind up creating a table packed with an overwhelming amount of information.
For more help identifying instances where linked records and relationships can help save you time, check out this support guide.
Identify redundancy in bases
While you’ll find more redundancy in tables, sometimes similar problems can happen in bases. In general, you want to create your bases with a specific purpose and broad capabilities. For example, you’ll get more out of a base that functions as a CRM than a simple address book. Both have specific purposes, but a CRM provides broader capabilities.
You can identify these broader capabilities by considering the different ways you can use the core information in the base you want to create. If you start with an address book, you can turn it into a CRM by adding tables to track general activities, sales, support, and more. By linking those tables together, you not only avoid creating bases with redundant tables but you let the information in that base work together to help you accomplish more.
Using extensions to bring in more information
Airtable extensions —a pro feature —add powerful new features directly to your base in a modular way. With extensions, you can import and export information from your base in a variety of ways, create entirely unique layouts, generate graphs, and much more. You can even organize the extensions of your choosing into separate dashboards for specific audiences or uses. Let’s take a look at a few ways extensions can help you do more with your bases.
To get started, click the “Extensions” button in the top righthand corner of your base. Unless you’re working with an existing template, this will bring up an empty dashboard with a message encouraging you to create your first extension. Click “+ Add an extension” to take a look at your diverse set of options.
In the future, when you know which extension you want to use by name, you can start typing to filter your options and find it quickly without the need to scroll through everything. For now, browse through the list to get an idea of what’s available. Even if you don’t need most of the extensions right now, you’ll likely find they come in handy later on.
In a base that manages orders and invoices, you can use extensions to track time and even generate multiple styles of invoices.
The page designer extension lets you take any table’s information and create a printable layout. You can also add static text and images to your layouts when you need repeating elements like a company logo and contact information. You have control over fonts, font sizes, colors, and more. When you have a table with linked records, you can display them table format, as a list, or without any specific formatting.
When you need to track billable time, the time tracker extension provides a one-click button to handle the task for you. Whether you want to track time for tasks/projects in specific records or create new records it can handle both.
Because extensions contain a lot of visual information, you won’t want to add too many to your initial dashboard or you’ll end up scrolling through it to find what you need. By clicking the dashboard selector at the top of your extensions, you can rename it to something specific as well as create additional dashboards for other purposes.
You may find you need multiple dashboards with similar purposes when you have collaborators tracking their time individually. Furthermore, you may want to create separate dashboards for separate purposes. For example, the calendar, contact, XML, and CSV import extension can fill out their own dashboard when you need to import information of multiple types from multiple sources. The Sendgrid and Send SMS extensions work well for CRMs and marketing bases . When you need virtual meeting capabilities, you can rely on Google Hangouts and Whereby extension for direct access from your base.
Some extensions fit together in obvious ways, but your workflow may bring different types of extensions together as well. Dashboards provide a grouping structure so you can manage these helpful tools in a way that makes sense to you.
To learn more about extensions, check out this comprehensive support guide. It contains more overall information while also providing deeper dives into every single individual extension—with video demonstrations, too.
Filtered linked record fields can help limit what you see
When you use linked records to create a relationship between one table and another they will instantly have access to all of each other’s records. In many cases you’ll appreciate this freedom because you can easily access whatever you need without restriction. In some cases, however, you’ll want to impose restrictions on linked records by filtering out specific ones in order to reduce clutter, hide them from specific collaborators and/or public views, or restrict the choices available in a form.
To impose a limitation on a linked record field, you first need to create a view in the originating table—the place the linked records call home—with a filter that only displays the options you want to show up as options in the linked record field in the other table. You can create any kind of filter you want—just make sure it shows only the results you want. If you need help creating the perfect filter, check out this support guide.
Once you’ve created your filtered view, edit the linked record field. Look for the option called “Limit record selection to a view” and toggle it on.
Select the filtered view you just created from the list of options and save your changes. Now only records in that view will show up as options when attempting to add any to the linked record field in this table.
For more information on filtering linked records, check out this support guide. To learn how to use this feature to create a specific kind of tool, such as a booking system, you’ll want to read this tutorial as well.
Related video content