Can You Use Multiple Forms for One Table in Airtable

You are building an onboarding system in Airtable to make sure no details from a new hire are missed when they join. You want all the information you collect to land in one table so it is easy to manage.

To do this you decide to use a form.

But you soon realize that not every role requires the same information. Some jobs need certifications. Others need equipment. A few need something different.

At first you think about putting all the fields into one form and dividing them into sections. The new hire would only fill in the section that applies to their role. But this makes the form unnecessarily long and confusing.

So you start considering another option.

What if you create different forms for different job profiles. Each form would only include the questions that are relevant to that role.

The wording would also match the role which makes it easier for the candidate to complete the form.

This brings you to the key question. Can you have multiple forms that all feed into the same table in Airtable?

Airtable allows multiple forms

Yes, you can have multiple forms feeding information into the same table in Airtable.

A form is simply a way to create a new record. Every time someone submits it, the answers are added as a new row in the connected table.

Because of this, you can create as many forms as you need and point them all to the same table. Deleting or editing a form will never affect the records that already exist.

Airtable lets you create up to 50 forms in a single base, so as long as you stay within that limit you are free to build as many as you want.

One form with conditional visibility

If you would rather not manage multiple forms, there is another option. You can use conditional fields inside a single form.

To do this, click on a field while editing your form. On the right-hand side you will see an option called Visibility. This is where you can decide when that field should appear.

For example, you could add a rule that says the certification field should only show if the candidate type is Software Developer. That way the question only appears for the people who need to answer it.

Keep in mind that if your form needs to handle very different sets of questions, you will still need to include all of those fields somewhere in the form.

Conditional visibility hides the fields that are not relevant, but everything still exists on the page.

You can also group fields into sections to keep things organized. Just note that conditional visibility for entire groups of fields is only available on the Business and Enterprise plans.