Skip to main content
Question

How to add multiple child records to an unsaved parent based on user choice for the number of child records added

  • October 19, 2020
  • 0 replies
  • 65 views

Is there a formula URL where I can add multiple child records based on a number chosen by the user before the parent is saved?

I have two tables - Quotes (parent) and Quote Line Items (child). On the Quotes table I have an editable embedded report so they enter quote line items directly on the Quote. On Quotes I also have a field called "# of Line Items." I want the user to choose the number of quote line item child records that they want, click the button and have that save the parent Quote and create the number of child quote line items that they have chosen. No information needs to be brought to the child but the Record ID# and Quote Name.

Thoughts? Thanks!
Dawn

------------------------------
Dawn Rene
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Dawn
This can be done but before I weighed in to provide suggestions, why are you asking for this? Why not just let the users enter the child records in Grid Edit mode?  Are you aware that you can add records in Grid Edit mode?

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