Method for auto generating X # of records?
I'm dealing with 2 tables: Opportunities & Orders. Current Functionality: Opportunity Status = 'Closed Won' triggers QB action to create an Order.
I've added a field '# of Orders' to the Opportu...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'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. 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 # of orders to be created to the sequence number for the orders just created and delete all the ones that are too high.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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. 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 # of orders to be created to the sequence number for the orders just created and delete all the ones that are too high.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------