I was running into a problem where I wanted my users to be able to add multiple days off for employees by just selecting a range of dates. This meant that I had to create multiple records from one form. I was able to accomplish this by using three tables.
Table 1 (just updates) - is a single record form that gets updated, but no new records are added.
Table 2 (just updates)- has a bunch of formulas in it that look back at table 1 to figure out how many records to create. My action button updates a counter here, and this initiates a workflow. That workflow takes the data off of this sheet and updates the table where this record will ultimately live.
Table 3 (creates new records)- Due to the workflow initiated by the counter in Table 2, new records are created here.
I upgraded this by just adding a parent ID and a counter to table 1. Now when I hit my action button it increases the counter on table 1, creates a new parent ID, updates table 2 with records, then adds new child records to table 3 that now has a child record ID and parent record ID, I created table 4 that now holds the new parent record.
In summary, I have one form that a user can update with a range of dates. After they finish they hit a button, and then it creates a parent record and multiple children records.
I think this would be simple to just ask for a qty for the user also.
Here’s the link to my app, have a peak under the hood