A chain of events is a difficult thing to plan out when (as in most cases) things are subject to change. For this reason, I rarely attempted to build solutions with this level of granularity in Airtable. Specifically, TASKS usually rely on a dependency to be completed before they can begin. Like a row of dominoes, if one task gets removed or changed, the whole chain will suffer...
Logic Formulas are an important formula type to understand. The output of these formulas, while not very helpful in a vacuum, is often used in tandem with many other formulas. Therefore, building solid logic formulas is a vital skillset for all Airtable users.
This video showcases the two most popular logic formulas: AND and OR formulas. These formulas work in very similar ways, both of them...
Have you ever watched someone work inside a software and their fingers moved so quickly you couldn't even keep up with them? I was one of those users in Excel - in my previous life I used Excel for about 90% of my work and I was fast! Getting fast in a software isn't done by accident - there are deliberate steps you can take to improve your speed. To get faster, your primary...
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. If the logical value is 'true' then the formula spits out one output - if it's 'not true' then a...
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 can't be edited without going to the source base. As you might imagine, this limitation makes...
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 took to Airtable immediately. But slowly and over time, Airtable has been introducing bits of code into...
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 subscription business. I start with a mapping tool (Whimsical) to build my mind-map. From there, I transition...
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 platforms... so then how can we build an automated process?
The secret lies in linking these records to...
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 automate the creation of managerial review.
Of course, review is a semi-manual process. There will always...
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 connect data across our Airtable bases (databases)!
If you find yourself creating the same tables in...
50% Complete
Get our FREE Airtable Crash Course delivered to your inbox!