Creating multiple child records based on a # field in the parent

Question

Hello Community!&nbsp;Okay so I am looking to set up a system where once a new record gets created in a parent table that includes a numeric field in the record, it will create "X" number of child records equal to the value listed in the numeric field ID.&nbsp; Is this possible?I am sorry if my description makes no sense.&nbsp; An example is below.Contract Record is Created (Parent Table) with a field in the form that is titled "# of related contract amendments" and say that field is equal to 6.&nbsp; We would want 6 records created in a child table related back to the parent.&nbsp;What is the best way to do this?&nbsp; Pipeline?&nbsp; Automation?&nbsp; I am just not sure how to get the #&nbsp;of related records created to equal exactly what the user inputs into the numeric field within the parent record.Any help is appreciated!​------------------------------Joshua Case------------------------------

markshnier__you · Answer

There are multiple solutions.&nbsp; What is the most #&nbsp;of records you would possibly need to create as that would affect my suggested solution..------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

The low tech solution would be to have an Automation to create 30 or if you like 49 children. Each Action in the Automation will populate a field with the child number, from 1 to 30. You can copy Actions, so it's not too painful to set up.

Then lookup the # children required from, the parent to the children, and add a last step to delete children when their counter # is greater than the # of children required.

There are fancier methods which are a bit harder to setup which would have a better user experience as the children would get created quicker, but this low tech method could be good enough.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

markshnier__you · Answer

OK, sure.Make a helper table called Automation Focus.&nbsp; Add 1 record. Make a field called [Record ID# of Focus Parent]. Make a field called [#&nbsp;of children required].Make a new table called with say 100 records called Children Source in it and number them from 1 to 100.&nbsp; You can use the Record ID# for this purpose as long as you create the records and then stop anyone from deleting records, even the Admin.&nbsp; You can import from excel to create the records and populate a dummy fields to be deleted.Make a relationship between Automation Focus and the&nbsp; Children Source to lookup the&nbsp;&nbsp;Make a lookup from the Automation Focus for&nbsp;[Record ID# of Focus Parent] and [#&nbsp;of children required].&nbsp;Make a saved table to table import to map from Children Source to the child table but limit where sequence #&nbsp;is less than or equal to the #&nbsp;children required.Lastly make a formula URL button to do three steps.Populate Automation focus&nbsp;Run the ImportRedisplay the record.If you want the records to automatically populate the children whe&nbsp; the parent is created, then this can be done in an Automation.ie populate the Automaton focus&nbsp;Run the import.​​​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

joshuacase · Answer

Let's say at worst 29.------------------------------Joshua Case------------------------------

joshuacase · Answer

Any way to describe the fancier method?&nbsp; The example you provided is good and can be done quickly but I need to create the most streamlined experience for the end-users that's most effective and delivers the exact number of child records based on the parent's data.&nbsp; I like a challenge and I don't mind a difficult setup.------------------------------Joshua Case------------------------------

Forum Discussion

Creating multiple child records based on a # field in the parent

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

create pipeline to create new records based on current record

Add button to create record in different app

Modify multiple rows within the same group using Single Record ?