Generating multiple records from a single form submission for a group activity

If I understand you correctly, you need the following:

1) Children table - non-session specific child info
1) ChildSession table - child-specific session info
2) Sessions table - non-child specific session info

And you need a link field to link the ChildSession into a child, and another to link it to a Session.

You need two forms:
1) To record a new session, first without children
2) To record ChildSessions, where you add child-specific info.

And then, to show the general Session info as part of the ChildSession table, you need to define Lookup fields, that allow you to attach the fields of the linked table to the related record.

You can also define a Groups table for info that is the same across sessions, and keep the date, time etc. in that table.

Hope this helps 🙂

-- Best, Milan - Automable.AI Free Airtable consultation

Hey @Bel_Porto!

You might find this crazy, but...... there is no way to achieve that using Airtable native forms without clunky workaround. I submitted this exact feature request some time ago, so feel free to upvote it to get the Airtable team working on this.

However! A solution does exist: Fillout. Fillout's free plan is super generous, and it has a native integration with Airtable. By using their forms, you'll be able to create linked records.
Under your use case, you would create a form for creating a record for the Sessions table, but within it you would allow the creation of new Child Sessions (following with architecture described by @Milan_Automable).

Might sound overwhelming but it is not! Just let me know if you need any help setting this up, and we can hop on a brief call.

Mike, Consultant @ Automatic Nation 

@Bel_Porto 

Yes, as @Mike_AutomaticN pointed out above, your best bet is to use Fillout's advanced Airtable forms for this, because Fillout lets you create and edit linked records from a master form. Fillout is also 100% free.

I give a demonstration of this functionality on this Airtable podcast episode, and note that Fillout has gotten way more advanced since the time I created that podcast episode. For example, at the time of that podcast, Fillout didn’t offer editing of linked record fields, but now it does! 🙂

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

While I'd third the Fillout Form recommendation, one concern if you're working in the States could potentially be HIPAA compliance. While Fillout is GDPR compliant, when I reached out to them in the fall inquiring about HIPAA (a sincere concern with my org and preventing me from advocating for further Fillout use) they said it was on the roadmap, but as far as I can tell nothing's been added on the topic since. Just something to be aware of 👍