Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Entering data into multiple tables from one form

Topic Labels: Views
451 1
Showing results for 
Search instead for 
Did you mean: 


I have a table with companies and a table with contact persons in these companies. The company-table link to the person-table.

I have a form in the company-table where companies can enter their data. How can I have them also enter data for contact-person and have that data populate the person-table? When I add the person-field into the form, I only get the possibility to search and pick from existing entries - not adding a new entry.

Thanks for any help!

1 Reply 1

Welcome to the Airtable community!

You cannot do this with a single native Airtable form. Here are some options:

  • Use a third party form tool, such as MiniExtensions.
  • Have extra fields in the company table just for data entry of the person. Use an automation to create the person record with data from the company record.
  • Chain two different forms together using the re-direct url and a hidden prefill for the company record just created.