Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoSo these are child lines on an order? And the order knows the number of lines required.
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You6 years ago
Qrew Legend
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 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 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.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.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JasonBeaver6 years agoQrew CadetThe records are not child records. They would be parent records, so I am not sure how to create the summary field.
Sorry, I am new to automations. How do you create a copy loop in automations?
------------------------------
Jason Beaver
------------------------------- MarkShnier__You6 years ago
Qrew Legend
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. It's kinda complicated to explain it via the forum as I would have to actually build it to explain it. 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------