Generate rows equal to number from form
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
Best Answer
-
You would need to use a 3rd party app, the API, or the premium add-on Bridge to accomplish this.
Answers
-
You would need to use a 3rd party app, the API, or the premium add-on Bridge to accomplish this.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!