Best Way - Copy a record a number of times

Question

Looking for suggestionsI want to be able to copy a record based on a number field within the original record.For example - A user enters a record for a number of pizzas on an order.&nbsp; I want the user to only create the order one time and have the system (thru automations, maybe) create the additional records.&nbsp; So if the number of pizzas was 10 on the order.&nbsp; The user would create the first record and the system would generate the additional 9 records.------------------------------Jason Beaver------------------------------

markshnier__you · Answer

So these are child lines on an order? &nbsp;And the order knows the number of lines required.&nbsp;&nbsp;I have a couple of ideas. Can you tell me what the most number of lines the solution needs to handle?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

&nbsp;So here are my two approaches.

The simplest way is to set up an automation which will create, sa6, 20 child records. The automation would be triggered by a child record being created and a summary look up from the parent telling the child record that it in fact was the lucky one which was the first child.

The automation would create say 20 children each numbered from 2 to 20 respectively. Then the last step of the Automation would &nbsp;delete any children where is their assigned child number was greater than the number of children called for on the parent record.

It doesn't sound like you would need more than &nbsp;20 or 30 based on your pizza example.

But if you did want to generalize this to a higher number. I have done automations in the past where the automation creates a record and then updates a counter to the previous value of the counter plus one. And then the last step of the automation triggers that same automation to run again. That is to say it is possible to make a looping automation that calls itself. You just have to make sure that you don't create an infinite loop and there is a condition where the automation knows when to stop running.

&nbsp;But my first suggestion is simpler to set up. Just create a fixed number of records and then the last step of the automation will delete all the extra ones that you didn't need.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jasonbeaver · Answer

The records are not child records.&nbsp; They would be parent records, so I am not sure how to create the summary field.&nbsp; Sorry, I am new to automations.&nbsp; How do you create a copy loop in automations?------------------------------Jason Beaver------------------------------

markshnier__you · Answer

It can be done but I think I would have to work with with you on a one on one basis to set that up.&nbsp; It's kinda complicated to explain it via the forum as I would have to actually build it to explain it.&nbsp; Contact me via the email in my signature line if you have a small budget available for some one on one assistance.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jasonbeaver · Answer

I was able to make it work quite easily in Pipelines.&nbsp; Thank&nbsp; you for our insight.&nbsp; It helped greatly.------------------------------Jason Beaver------------------------------

Forum Discussion

Best Way - Copy a record a number of times

5 Replies

Related Content

Roundup whole number

Using pipelines to log the date/time including the seconds of a record change

Adding number of Business Days to Date

How to Pull Employee Name and Title Instead of Record ID Number in Quickbase Pipeline

Duplicate Record Checker