I’m new to AirTable so forgive me if this has already been answered.
Is it possible to create one form that will enter records into two different tables?
I am making a form to enroll a student. The first 4 fields, Name, village, birth date will go into a table of students. The next 4 fields: semester, year, study group would go into another table as these would differ from year to year.
Thank you in advance for considering my question.
Rob
+29It isn’t possible to have one Airtable form feed into two different tables.
If you have a Pro subscription, you can chain Airtable forms together–clicking the submit button for one form automatically redirects to a second form for a new table.
However, for a better user experience, you might want to use a third party form integration, such as JotForm.
+352025 Update:
Your best bet for doing this would be to use Fillout’s advanced forms for Airtable, because Fillout will allow you to add linked records to your form, which would enable you to instantly create records in 2 tables simultaneously.
Even better, Fillout offers hundreds of advanced features that Airtable doesn’t natively offer in its forms, such as updating Airtable records from a form and much more.
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
It isn’t possible to have one Airtable form feed into two different tables.
If you have a Pro subscription, you can chain Airtable forms together–clicking the submit button for one form automatically redirects to a second form for a new table.
However, for a better user experience, you might want to use a third party form integration, such as JotForm.
Thank you for your response. Very helpful to know that it is impossible so that I can stop trying to figure it out.
Rob
+352025 Update:
Your best bet for doing this would be to use Fillout’s advanced forms for Airtable, because Fillout will allow you to add linked records to your form, which would enable you to instantly create records in 2 tables simultaneously.
Even better, Fillout offers hundreds of advanced features that Airtable doesn’t natively offer in its forms, such as updating Airtable records from a form and much more.
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
@Rob_Cahill, just to clarify: It’s only “impossible” using Airtable’s native features that are built into a single form.
But there are tons of different workarounds for this, because this is a very common request that many people need.
@kuovonne and I outlined only 3 workarounds above. But there are many more workarounds as well, in addition to the 3 listed above.
For example, you could capture the data from a single form, and then create a JavaScript automation, an Integromat scenario, or a Zapier zap to parse out the data for you into separate tables.
You might even be able to do what you want with On2Air: Forms, but I would ask @openside about that.
So you have tons of options for making this work. :slightly_smiling_face:
p.s. If you have a budget for this project and you’d like to hire an expert Airtable consultant to figure this out for you & program it for you, feel free to send me a private message. :slightly_smiling_face:
Thanks ScottWorld.
If this question is pretty common, it might be something AirTable should look at making available on down the road a bit. I can see how it would be really useful.
We are working in an environmental education program in Guatemala with a shoe-string budget but if you are interested in giving us a hand ‘pro-bono’ I’d accept. There are only a couple design issues that still need to be resolved.
thanks
+2Hi Rob,
In 2025 this is absolutely achievable in 2025 with Fillout.
In the gif below, you’ll see how a single form submission creates records in two separate tables.
This is quite straightforward to set up. Feel free to reference my templates below, and let me know if you need help setting it up.
Fillout template: https://www.fillout.com/templates/create-students-and-guardians
Example Airtable base: https://airtable.com/invite/l?inviteId=invGbxuJjd9YmowYb&inviteToken=590c8c9d26cb5145e7f584d608402493259429d573b7b87b27381962c0653f50
Best,
Bryan
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.