Auto populating Rows based on the number in the Qty box

Sarah Laing

Hi. Is it possible to auto populate rows based on the number I have in my QTY cell?

I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or more branding plates. I only need the branding plate # to be copied on the lines though if that makes it easier. I hope this makes sense. I have taken a screen shot of what I am meaning below. Or could this be possible by using one of those integration apps like ZAP? I have tried to make this work with ZAP but I couldn't get it to. I think I just don't know how to phase what I am needing to their AI properly. Maybe someone could help with that as well? All help is greatly appreciated!

Andrée Starå

Hi @Sarah Laing

I hope you're well and safe!

I recently developed something similar for a client to have rows created depending on the number of days.

It's a pretty advanced solution.

Do you have a budget for hiring a consultant to help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah Laing

Hi @Andrée Starå Unfortunately, I do not believe I would have a budget to hire a consultant. I wish! Thanks for you feedback though. I feel like this will end up not being something I can complete as a full automation on my own. I have a system now that is a function I have to copy and paste every time. SO I guess that will have to do.