Form Submission Creating Multiple Rows
Hi there,
I know this question has been asked previously in the forum, I'm hoping since that time, there has been more information around this topic.
We are leveraging Smartsheet for a core business process and would like to use the functionality of a form as it simplifies the process and removes some of the technical aspects to the end user. However, we need a single form to be able to create multiple rows of information in some cases.
This is a hurdle we've been trying to overcome in other ways, but unfortunately, we keep returning to needing this feature as part of our solution.
Are there any Smartsheet features that have been release that can help solve for this? If not, has anyone successfully been able to create multiple rows of data from a single form submission?
Appreciate any help you can provide.
Answers
-
The best add-on feature I can think of for something like this would probably be DataMesh: https://www.smartsheet.com/marketplace/premium-apps/datamesh
DataMesh allows you to pull data from sheets and row reports and remap them in sheets. If you were to use DataMesh, I would probably suggest having the columns you want in two separate reports (or DataMeshed into two separate sheets) and then combining them into one sheet but on separate rows based on unique identifiers from those reports (or sheets).
Without DataMesh, I'd struggle to think of a way to separate the rows that was completely automated.
Hope this helps!:)
-
Hi @Nekblad
I hope you're well and safe!
I've developed a couple of versions to create multiple rows.
I'm looking forward to our meeting!
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!
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.
-
Hi @Andrée Starå ,
can you please share your solutions with me as well?
my email is peleg_dorfan@contractor.amat.com
Thank you!
Peleg
-
@Nekblad Take a look at this solution that I developed:
-
Shared!
✅Remember! 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.
-
May I please have a copy of the template as well? Thanks so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives