Resources & Guides
Explore our collection of tutorials, best practices, and guides to help you master Airtable and streamline your business workflows.
How Defiant CNC Streamlined Their Manufacturing Process in Airtable with an On2Air Amplify Dashboard
17-Point Airtable Data Backup Checklist ✅
How to Create a Local Offline Airtable Backup
Airtable Snapshots – Everything You Need to Know
In this tutorial, you’ll learn what Airtable snapshots are, when to use them, and how to use them to recover your data.
A 7-Step Guide to Restoring Deleted Airtable Data
Data loss in Airtable can be devastating. In this tutorial, you'll learn step-by-step what you need to do to restore your Airtable data.
Prevent Airtable Data Loss with Automated Backups
Imagine you woke up one day, sat at your computer to start working and realized you lost some or all of your valuable business data. In this article, we'll guide you through the process of scheduling automatic backups for your Airtable data using the On2Air Backups extension. We'll show you how to keep your information safe and secure, so you can focus on what matters most—running your business.
How Grassroots Grocery Combats Food Insecurity with On2Air Forms and Airtable
Learn how this thriving nonprofit organization uses On2Air Forms and Airtable to centralize operations and volunteer management to combat food insecurity.
How Charm Industrial Backs Up Mission Critical Airtable Data with On2Air Backups
Learn how Charm Industrial prevents data loss and backs up mission-critical Airtable data with On2Air Backups.
How Grow with Jen Consulting Streamlined Projects for a High-Volume Construction Company with On2Air Forms and Airtable
Learn how this consulting agency uses Airtable and On2Air Forms to streamline projects for a high-volume Construction company with easy-to-use forms to update and create Airtable data.
Gift Guide for the Airtable Fanatic
Here's your gift guide for the Airtable database-loving fanatic in your life! From the latest tech gear to unique fun gifts to the best Airtable apps, here's a list of the best gift ideas.
Airtable Extensions and Apps: An In-Depth Guide
Airtable Extensions extend the functionality of your Airtable data and allow you to use it in new ways. In this tutorial, we’ll show you what Airtable extensions are and how you can use them in your business.
How to Manage and Organize Your Airtable Extensions
If you have multiple Airtable extensions in your base, there's a simple way to manage all of them at once. Here's how to use the Airtable Extensions administration dashboard made for adding, removing, and managing Extensions.
How to Create a Summary Report in Airtable
Reporting on business information using your data in Airtable is a vital part of company operations. In this tutorial, you’ll learn how to create summary reports in Airtable, how to automate record links to a report, and how to generate a document or presentation to share the information with others.
How to Back Up Multiple Airtable Bases in On2Air Backups
Do you have an Airtable workspace with multiple important company bases? You can backup up multiple Airtable bases with a Backups Project in On2Air Backups.
How to Quickly Open any Airtable Record on iPhone
Have you ever wanted to open an Airtable base table, view, or record from your iPhone home screen? In this article, we’ll show you how to set up a home screen Shortcut widget in just a few steps.
Download a Free Airtable Template – Ecommerce Store 🛒
Download the Airtable Ecommerce Store Template for FREE today! Use this Ecommerce Airtable Base Template, created by On2Air, to store all your product data, orders, sales reports, inventory, suppliers, accounts payable, and more.
How to Build an Airtable Dashboard for Your Business in Under 10 Minutes
An Airtable dashboard is designed to provide a single interface for your company data. We'll show you how to create an Airtable dashboard with the On2Air Amplify app.
15 Airtable Design Best Practices: What Companies Need to Know
Airtable is a powerful tool to use as a central source of information for your business and your team. We’ve created this 15-point checklist of Airtable best practices to review when you’re ready to design your Airtable base.
How LKF Marketing Creates a Backup of Their Airtable Bases with On2Air Backups and Ensures Their Clients’ Data is Safe
Learn how this marketing agency uses Airtable and On2Air Backups to take care of their clients' projects and ensure their data is safe with an automated backup of their Airtable bases.
How Claribase Automatically Generates Documents using Airtable and On2Air to Save 3-4 Hours Every Week
With clients who needed automated documents using data stored in Airtable, Claribase knew they needed a better document solution. Learn how the Google Docs Function in the On2Air Actions app helped Claribase Founder and CEO, Cherry Yang, provide a time-saving option for her clients.
3 Helpful Airtable Articles (+free templates)
How to Find and Remove Duplicates in Airtable
Here’s how you can find (and remove) duplicates in your Airtable records. Sometimes, you enter in records multiple times or sometimes you just need to find duplicates of a specific record or field. The Find Duplicates option in On2Air Amplify helps you search by specific field to find any duplicate information.
Amplify Update – Permissions, Block Layouts, and more!
Gift Guide for the Airtable Fanatic
Here's your gift guide for the Airtable database-loving fanatic in your life! From the latest tech gear to unique fun gifts to the best Airtable apps, here's a list of the best gift ideas.
Sync Airtable and Google Sheets using On2Air
In this tutorial, I’ll walk you through how to sync tables from your Airtable base to a Google Sheets table using the On2Air function integration.
Automated Invoice Documents from Airtable with Google Docs (+Free Template)
In this guide, we’ll show you how to automatically generate invoices using your customer data in Airtable with On2Air Docs and Google Docs.
How to Create a Sales Contract PDF in Google Docs using Airtable
In this guide, we’ll show you how to create a Sales Contract in Google Docs and then turn it into a PDF using data from your Airtable base.
How to Connect Airtable and Google Sheets: An All-In-One Guide
In this guide, we’ll show you the many ways you can connect and use Google Sheets and Airtable together. Whether you want to sync your data automatically between the two tools, update a cell in Google Sheets after you change it in Airtable, edit your Google Sheets spreadsheet while you’re inside of Airtable, or add Sheets as a PDF, Excel, or CSV in your Airtable base, we’ll go through each of the ways you can use them together.
6 Stunning New View Types in On2Air Amplify – The Visual Editor App for Airtable
We've added 6 new view types, including editing and viewing Google Docs, Sheets, or Slides, view a list of records in a table, a full-screen option for any view type, the ability to add new linked records and add new single-select or multi-select options from your layout, global settings, easier filtering, and much more!
New Feature: Create Files in Google Docs with Your Airtable Data!
With Functions in our Actions app, you can now create new or templated files in Google Docs, Google Slides, and Google Sheets using your Airtable data!!
New Features! On2Air Actions Now Has Pre-Made Tasks for Setting Default Values, Using Financial Formulas, and Many More
New Features! On2Air Actions Now Has Pre-Made Tasks for Setting Default Values, Using Financial Formulas, and Many More
New Features! On2Air Amplify Update: Search Panel, Navigate between Tables, More Customization
New Update for On2Air: Amplify! Search panel, Table navigation, and more customization options. On2Air: Amplify is a brand new way to view your Airtable data. With custom views, a full-screen viewer, record customizer, and editor, On2Air: Amplify will change the way you use Airtable!
How to Use Integromat Webhooks in Airtable
This tutorial will show you how to add a webhook from Integromat to Airtable automations using the ‘Run Script’ option. We’ll provide you with the code to start sending your Airtable data to Integromat. When you need to send your Airtable data to multiple sources or don’t have access to a direct connection, a webhook can help you connect to various sources.
Visualize and Monitor Your Airtable Base Structure with Schemas
If your company uses Airtable as a central source for all your business operations, you probably have multiple bases and a variety of base structures. With the Airtable Schema app, you can view all field types in your base and the field relationships, such as formulas, linked records, count, and rollups.
How to Use Zapier Webhooks in Airtable
When you need to send your Airtable data to multiple sources or don’t have access to a direct connection, a webhook can help you connect to various sources. This tutorial will show you how to add a webhook to Airtable automations using the ‘Run Script’ option. We’ll provide you with the code to start sending your Airtable data to Zapier, where you can then send your data to any other app in Zapier.
Set Your Airtable Automations on a Recurring Schedule
Automations in Airtable make it easy to complete and schedule tasks in the background. You can create a scheduler for your automations using this easy setup, so your automations run on a specific day, week, or month.
Sync and Automate Your Bases in Airtable
With your Airtable bases connected and synced, you can automate a variety of processes. With this tutorial and setup using On2Air: Actions, you can sync and send data between your different Airtable bases and update multiple records at once.
The Essential Guide to Backups for Your Airtable Bases
Having a backup of the company information you’ve stored in Airtable is vital. Whether it’s in your client contracts, part of your company operating procedures, or gives you peace of mind, with this guide, you can always have a backup copy of your data outside of Airtable.
How to Manage All Your Airtable Scripts in One Place
The Airtable Scripting App brings a new level of customization for your company data in Airtable. When you start using the same scripts or the same snippets of code in multiple Airtable bases, it’s time to organize with a script management tool.
How to Display Data From Your Airtable Records on Your Forms
If you’re using forms in Airtable, there are many times you probably want to filter the records shown in your form fields and also display images or other data. In this post, we’ll cover how you can filter your forms to show users specific info and then display data from your Airtable base.
Create a Sales Pipeline Dashboard for Your Airtable Base [Includes 2 scripts]
Do you need a quick snapshot of your Sales pipeline in Airtable? With the Scripting App in Airtable, I'll show you how to create a custom dashboard displaying your Sales Funnel and Top Sales Reps.
How to Use Conditional Logic in Your Airtable Forms (Interactive Guide + Video)
With Airtable forms, you can capture data anytime and even add conditional logic to show only the most relevant fields to your user. In this tutorial, we’ll show you how to set up a form in Airtable and use conditional logic in the form to display a field only when a previous field is completed with a ‘Yes’ answer.
How to Send an Email Automatically from Your Base Using Airtable Automations
With Airtable Automations, you can email your client an ‘Invoice Paid’ email when you mark an Invoice as Paid. You don’t have to take extra steps to export the invoice and then email it to your client. In this example, we will email a client when an invoice is marked paid
How to Connect Multiple Field Records Together Using Airtable Automations
Automations in Airtable make it easy to complete basic in-app tasks. Learn how to connect multiple field records together using Airtable Automations. In this example, we link sub-projects and main projects together in Airtable.
How to Automatically Add a Set of Tasks to Each New Project Using Airtable Automations
With Airtable Automations, you can create an automation to add a checklist set of tasks every time you create a new project. This automation will save you time and monotonous manual data entry.
How to Set Default Information on Any New Record Using Airtable Automations
With Airtable Automations, you can set any new record to have the same default information each time one is created, saving you time and data entry error. In this example, we will add default information to multiple fields in an Invoice record.