Skip to main content
Question

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

  • June 25, 2020
  • 0 replies
  • 45 views

Forum|alt.badge.img+6
Hello Community! 

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.  Is this possible?

I am sorry if my description makes no sense.  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.  We would want 6 records created in a child table related back to the parent. 

What is the best way to do this?  Pipeline?  Automation?  I am just not sure how to get the # 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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
There are multiple solutions.  What is the most # of records you would possibly need to create as that would affect my suggested solution..

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