Latest Articles

How to Extract Text with the MID Formula in Airtable

Within an Airtable database, it's common to need to extract or "pull" text from a long string. There are many reasons you may want this, ranging from social media posts to contract creation. Luckily, the methodology for extracting the desired text is always the same: reference the string, find out where to start, and find a length of characters to extract.

Now sometimes, your starting position...

Continue Reading...

Why You Still Need Form Software with Airtable

Airtable Forms are a great way to quickly give external users access to enter data directly into your database. In general, Airtable has built an exceptional form feature to their software. Airtable forms are capable of many things, including:

  • prefilling form data
  • conditional fields
  • embedding on a webpage

That said, there are still some things that Airtable forms can't do. In these advanced...

Continue Reading...

Automation for Updating Dependent Task Dates

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...

Continue Reading...

Using AND OR Formulas in Airtable

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...

Continue Reading...

Top Keyboard Shortcuts for Airtable

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...

Continue Reading...

Using IF and SWITCH Formulas

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...

Continue Reading...

Build Automation Using Table Sync

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...

Continue Reading...

How to Create a Script in Airtable (without knowing code)

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...

Continue Reading...

How to Map a Subscription Business

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...

Continue Reading...

Creating a Weekly Summary of Events

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...

Continue Reading...
1 2 3 4 5 6 7
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!