logo
Documents & Forms
Microsoft 365 & SharePoint Tools
Classic SharePoint Tools
Forms
Jul 18, 2022

Create advanced forms for Airtable to add single or multiple records

Customer Support Engineer

Airtable Forms offers a quick and easy way to get data from the users, but the options are fairly limited - the form cannot be split into sections, business logic is limited, you can't use one form to add multiple records at once, and you can't integrate it with other services, for example, if you want to store attachments in your file storage. You also cannot set custom email notifications, and cannot apply any branding.

Plumsail Forms will also allow you to easily design web forms for Airtable, but also:

  1. Split form into sections using Wizard
  2. Add custom business logic with JavaScript
  3. Add multiple records at once, including DataTable option
  4. Integrate with other platforms, for example, upload attachments

To get data from the form to the Airtable, you will need to use Zapier platform and:

then select the form that you've created and populate data for a new record in Airtable:

Split form into sections using Wizard

When you design a form in Plumsail Forms web editor, you can add containers such as Tabs, Accordion, and Wizard to split the form into sections. The most popular option is the Wizard container:

1

Wizard container allows to split a form into steps, each one has to be completed before going to the next step.

Drop the container onto the form, add steps that you want a user to fill out, and then drop fields into these steps:

2

Making fields required will prevent user from going to the next step or submitting the form without filling them out:

3

Add custom business logic with JavaScript

Once you've designed your form, you can further improve it with custom JavaScript logic.

For example:

  • Hide and show sections based on previous answers
  • Make fields required only in certain conditions
  • Skip steps in the Wizard if some option is selected
  • Calculate prices and total value

Here's an article on how to handle most cases working with fields, and here's more info about the Wizard container.

Add multiple records at once, including DataTable option

Do you want to populate multiple tables at once? For example, each step in the Wizard can be sent to a different Airtable spreadsheet:

5

Moreover, you can add one or many DataTable controls to the form, and use them to populate data in different tables with multiple records at once:

6

You can find information on how to work with DataTable control in our docs.

Integrate with other platforms, for example, upload attachments

With Zapier and Plumsail Forms, you can configure integrations that will work with multiple platforms.

What if you want to also store attachments in Dropbox or Google Drive? You can do it with Zapier:

7

This will also work for other platforms and integrations, for example, you can duplicate data to Google Docs, or send emails based on submissions, the possibilities are almost endless.

Get started

With Plumsail Forms, you will be able to create custom forms for Airtable to add one or multiple records to Airtable sheets. These forms for Airtable will be branded, have conditional business logic, custom notifications, allow you to use containers such as Wizard or Tabs, and advanced controls such as Data Table or Likert Scale.

You can check out Plumsail Forms product here, it includes a free plan with a limited amount of submissions. And we’ll be glad to answer any of your questions in our community forum.