Skip to main content
Question

Online registration with multi-table information

  • July 6, 2026
  • 1 reply
  • 5 views
Z

Hello all,

I am building an online registration form for clients to sign up for a Christmas Hamper program. 

The information I need to collect is the personal information of the client (i.e. name, address, income etc) and all the personal information of all household members. 

I created a base with two tables, one is the client table (for all the client data) and another table called HH_Members that holds a record for each member of the family (including name, DOB, gender etc.)

Is there a way to publish a form that can collect the client information and all the household members and store it in the respective tables?

How does one collect information with a “1 to many” relationship and store it in linked tables?

Thanks in advance for your help,

Zepppo

1 reply

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • July 7, 2026

​@Zepppo 

Unfortunately, that is one of the major limitations of Airtable. It is not possible to create new linked records from a form.

You have 3 workarounds for this limitation:

  1. On the first form, give the user a link to ANOTHER FORM which will allow them to add new records to the linked table. Then, they can come back to the first form to continue their data entry.
  2. On the first form, in the linked record field, give the user an option to choose from that is called "new record" or something like that. Then, conditionally show additional fields where they can type in the new information. Then, use an automation to add the new record into the appropriate table.
  3. However, instead of the workarounds above, your #1 best bet is to use Fillout’s advanced forms for Airtable, which already has this functionality natively built into its forms.

Fillout is 100% free and offers hundreds of advanced features that aren’t natively available in Airtable’s native forms, such as the ability to:

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Terms & ConditionsAccessibility statement