How to Update Airtable with a Form

There are many reasons why you would want to update Airtable data through a form. Most popular of these is the fact that it can be difficult to limit data access for the users in your Airtable database. However, if you could create a "read-only" view for them, and allow them to push a button to update data in that view, all your problems would be solved! With this approach, you can (1) eliminate the need for multiple paid users, (2) limit the data that others can view, and (3) only allow others to update specific fields.

This is a big request within the Airtable community - so much so, that some 3rd party tools have built plug-and-play solutions to help you streamline this process. And while I personally think a lot of those solutions are very solid, they aren't always necessary. In this video, I outline the six step process to creating this entire solution directly inside your Airtable database. In short, you'll want to follow these steps:

  1. Create your Data Table
  2. Create your Update Table
  3. Build a Form in your Update Table
  4. Copy/Paste the Form URL into your Data Table
  5. Create a Prefilled Form
  6. Build an Automation to Update the Data Table

Try implementing this process in your workflow to see how you can efficiently share views of your data that others can update easily!

Life is too short to fight with spreadsheets

Enter your info below to get my FREE Airtable Crash Course to discover how to use automations to get your time (and sanity) back.

Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!