Method for auto generating X # of records?

Question

I'm dealing with 2 tables: Opportunities &amp; Orders.Current Functionality: Opportunity Status = 'Closed Won' triggers QB action to create an Order.
I've added a field '# of Orders' to the Opportunity form. And I'd like to (somehow) use that field to be a variable for creating X quantity of Orders.How is this best accomplished?Thanks!
&nbsp;------------------------------Ryan Parr------------------------------

ryanparr · Answer

The only thing I've come up with is to create a second application to send Opp Data to, whenever there's a value other than Null in the # of Orders field. Then have that second app run a specific webhook, based off of the # of Orders field, to write records back into the originating app. If there's an easier way, let me know!

------------------------------
Ryan Parr
------------------------------

markshnier__you · Answer

I'm sure that there are several ways.One way is to have an Automation trigger with say up to 49 almost identical steps (of course) fewer if you would never need 49 orders.&nbsp; &nbsp;Each step of the Automation would create 1 record and would number [Sequence Number] field from 1 to 49 as they are created.Then the last step would compare a lookup value of the #&nbsp;of orders to be created to the sequence number for the orders just created and delete all the ones that are too high.&nbsp;​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

see my post below------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

donlarson · Answer

Ryan,The new pipelines tool will supposedly do a For Next loop.&nbsp; It is not clear when that will be available to everyone.&nbsp; Check out the recorded webinar from Wednesday for some glimpses.------------------------------Don LarsonPaasporterWestlake OH------------------------------

ryanparr · Answer

I saw that during the webinar. I need to understand what sort of pricing will be tied to it before we bank on it. But I loved what i saw. At least there are a few options for pulling it off. Thanks for all the help, guys!!

------------------------------
Ryan Parr
------------------------------

Forum Discussion

Method for auto generating X # of records?

Related Content

PDF Document Generator, automatically attached to a record

Custom Record Titles

Generate a number

Using Grid Edit to Edit Multiple Records at Once

Record Details