Using formulas is a critical element of building a solid database, but they can be intimidating, especially if you're not accustomed to writing formulas in Excel or similar tools.
One of the most commonly used formulas is the IF formula. This formula checks a logical value that you've assigned....
Airtable Sync allows you to now connect information across multiple databases - finally! However, the sync does come with a limitation, specifically that syncing requires data to be updated in the 'source.' This means that, while you can see the data in synced table, the underlying data...
Confession time: For as much as I love Airtable, one of the biggest things that initially drew me to the software is that it was a "no-code" platform. This fit into my skillset nicely. I understood databases and automation, but code always felt just a bit out of reach for me. So naturally, I...
One of the most difficult parts of building a relational database is in establishing the ideal database architecture. To get the intended result, it's best to start with a mapping process to help you visualize the flow of data.
This video outlines the first steps of architecture for a...
Someone in the forums recently asked about creating a weekly summary of events to be submitted in an automated email. If grabbing bulk data was possible within Zapier or Airtable automation, this would be a fairly easy thing to automate. However, bulk data isn't natively available to these...
Building a workflow in Airtable is an important part of creating scalable processes. One workflow that almost all growing businesses have is the need to receive and review job applications. In this video, I break down how you can create an application process using Airtable and also how to...
The future is looking very bright for Airtable. Not only did they receive another round of investment at $185M this week, they also released some incredible new features. The most anticipated of these is arguably what they have dubbed Airtable Sync. This new tool gives us the ability to...
Airtable has shipped some very exciting new updates for September, 2020! Check out this walkthrough as we review their new announcement and dive into the future for the software. Specifically, Airtable has focused on three new features:
- Blocks are now Apps and there's now a marketplace for...
With the new release of the Airtable Automations feature, Airtable has unlocked amazing new potential for its users. While it's still in the early stages, this feature allows us to automate from directly inside our databases, without needing to use a third-party software. But does this mean that...
The most powerful feature of Airtable is that it is a relational database. However, this very capability can often prove troublesome. More specifically, a relational database is outstanding at presenting the current state of things. However, it's not always the best fit for demonstrating...
For the past three years, I've been building my automated Airtable processes using Zapier. If you're unfamiliar with it, Zapier is a powerful tool that connects software on the internet using "If this, than that" logic. It allows you to set up processes that are governed by a set of rules. For...
In last week's tutorial, I outlined the database structure that would support an hourly consulting agency. We mapped the steps to creating the Team, linking that with Consultations and Clients. We also outlined the steps to adding a table of Invoices so that our team members can get accurately...
