Entering data into multiple tables from one form

[Thomas_Evensen]

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!

[kuovonne]

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.