Latest Articles

How to Track Time and Labor in Airtable

Working with contractors can get complicated, especially when you ask them to submit their hours and timesheets. Not only that, but you also need to manage multiple rates over time, especially if you want to properly promote the best of your talent pool.

If tasked to build this in Airtable, our first inclination will often be to directly link a table of Rates to a table of Contractors -...

Continue Reading...

How to Use Webhooks with Airtable

In many cases, automation is fairly straightforward to build. Simply connect your software, choose your trigger and actions from a list, and away you go! However, sometimes the specific thing you're trying to automate doesn't already have a trigger established. There are an unlimited number of possibilities here, but let's use the example of pushing a button in Airtable. At present, there...

Continue Reading...

How to Track Digital Goals in Airtable

With the dawn of a new year, comes new goals and planning. If you're ready to shift to tracking your goals digitally, look no further than this Airtable tutorial.

In this video I showcase this template to track OKRs inside of Airtable. OKRs, or Objectives and Key Results are a popular way to track goals and the different levers that will drive the desired...

Continue Reading...

How to Capture Payment Info in Airtable with Automation

Getting your cashflow organized is a vital step for running a successful company. Quite often, businesses have money coming in from multiple places and they lack the ability to get a clear picture to the health of the overall business. Thankfully, Airtable is a great solution for consolidating all this information.

This particular video walks through the steps to building an automation with a...

Continue Reading...

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...
1 2 3 4 5 6 7 8
Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!