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

6 Replies

Related Content

New Form - Show Create Record button

Managing record access for multiple data levels

Bulk create child records from selection list

Multiple reference proxy fields help

Button: save the new record and edit the new record

Recent Discussions

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API