Creating multiple records with one form submission

[Bishoy_Gaid]

Hi all,

I do property inspections and wanted to create a template where I can fill out every time I do an inspection but it can create multiple records. For example, here are the main items I inspect (doors, walls, drains, landscaping, etc) And I would like to fill out a form that can create a different record for each of those items. Is that possible at all?

Thanks in advance!

[Justin_Barrett]

Yes and no.

Yes, Airtable can be tweaked to create multiple records after a form has been submitted, but it’s not a built-in feature. Each form submission only creates a single record. To do the multi-record system will require an automation triggered by the new form record. Most likely it would need to create those extra records somewhere other than the table where the form adds its records, although with the right setup it may be possible to keep everything in a single table and not create an endless loop of records triggering records triggering records.

[HannesK-ME]

Hi there, 

Hannes from the miniExtensions team here! Our form gives you the ability to add multiple records to a table (or different tables) using linked record fields. You could have a form for each inspection you do. This would go in an inspections table. From there, you link to separate tables for each item you inspect. Those linked record fields would then be added on the form, and this way you could go through each step and create a separate record for each main item, which will all be linked to the inspection in the inspections table. This is likely the cleanest way to set this up, and would provide excellent traceability later on, while still keeping each item separate.

You can try this out with a free account now! 🙂