Latest Articles

How to Sync Airtable with Google Contacts

One of the most popular use cases for Airtable is to build a CRM to run your business. Practically all CRMs have a table that stores CONTACT data - names, emails, phone numbers... most business requires transactions between humans (I give you this, you give me that). However, your Airtable CRM isn't always the easiest thing to access. Perhaps your on the road and you want to call a client - or...

Continue Reading...

How to Consider Averages in Airtable

Calculating Averages is an essential part of database design, but there are several options to choose from when setting up your ideal structure. How will you decide which 'type' of average to create for your database? Well, it generally starts with knowing your options, including pros and cons for each choice.

In this video, I walk through a few different ways to calculate averages inside your...

Continue Reading...

How to Trigger Airtable Automations on a Specific Schedule

Every automation starts with a trigger - the set of conditions that must be met in order to "turn on" your automation. However, sometimes you need your automation to occur on a specific date or time. For example, perhaps you want to run a report on Fridays at 6pm, or maybe you want to send an email every Wednesday at noon. This type of trigger is often referred to as a "Scheduler," but setting...

Continue Reading...

Airtable Template for Christmas Cards

Airtable is a fantastic tool for managing processes in your business and life. One thing that I track in it every year is sending holiday cards. It's arguably an older tradition, but I love taking time every year to sit with my family and recap the great things that occurred. We then compile this in our holiday newsletter that gets printed off at FedEx.

The part that we manage with Airtable is...

Continue Reading...

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

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

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!