Form Submission Creating Multiple Rows

Nekblad · 03/25/24

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.

brianschmidt · 03/25/24

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!:)

Andrée Starå · 03/25/24

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!

Peleg · 05/13/24

https://community.smartsheet.com/discussion/comment/427146#Comment_427146

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

Paul Newcome · 05/17/24

@Nekblad Take a look at this solution that I developed:

https://community.smartsheet.com/discussion/119380/split-multiple-selections-in-single-form-into-individual-rows-core-product

Andrée Starå · 05/17/24

https://community.smartsheet.com/discussion/comment/435692#Comment_435692

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!

NeilKY · 11/14/24

https://community.smartsheet.com/discussion/comment/427146#Comment_427146

May I please have a copy of the template as well? Thanks so much!

Form Submission Creating Multiple Rows

Answers

Categories