Entering data into multiple tables from one form

Hi!

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!

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.
1 Like