Skip to main content
Question

Online registration with multi-table information

  • July 6, 2026
  • 4 replies
  • 60 views

Forum|alt.badge.img+1

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

4 replies

ScottWorld
Forum|alt.badge.img+35
  • 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 2 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.

However, instead of the clunky 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


TheTimeSavingCo
Forum|alt.badge.img+32

Simplest way to handle this is to use Fillout I reckon and it’s free for up to 1k submissions a month: https://www.fillout.com/

You could potentially handle it with just Airtable, but it’d be really clunky

 


Forum|alt.badge.img+1
  • Author
  • New Participant
  • July 8, 2026

@ScottWorld Thanks for taking the time to reply in great detail. I really appreciate it. I’ll give FillOut a go and see if I can get that to work. Thanks again. 


Forum|alt.badge.img+1
  • Author
  • New Participant
  • July 8, 2026

@TheTimeSavingCo 

Thanks for your reply, Adam. I’ll poke around FillOut and see if I can get that implemented. The 1000 submissions limit isn’t a problem as I only expect around 600 Christmas Hamper clients. 
Cheers!