Generate rows equal to number from form

Dewhirst

Hello,

I'm trying to use a form to submit the number of rows that I want to populate, and I'm not too sure how, or if it's possible, to do so.

Essentially I'm looking to use the Auto Number column to generate ID's for a given number parts that I'm making. For example, I will make 3 parts today, enter "3" in the Form, then have the attached Sheet populate 3 rows with ID's 001, 002, 003. Then the following day say I'm making 4 parts, I enter "4" in the form and have 4 new rows populated with 004, 005, 006, 007.

I can get the Form to populate a single row, but I'm not familiar enough with smartsheet functions to get any further.

How might I go about this?

Cheers

Paul Newcome

You would need to use a 3rd party app, the API, or the premium add-on Bridge to accomplish this.

Paul Newcome

You would need to use a 3rd party app, the API, or the premium add-on Bridge to accomplish this.

Andrée Starå

Hi @Dewhirst

I hope you're well and safe!

It's pretty advanced, but I recently developed a similar client solution.

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!