Multiple Line Entries with one Form Submission

Eric D

As a quick hack, you can also hit the back button in your browser to display the previously submitted form and then make necessary changes for the next row submitted , hit Submit.

Sara Kouba

https://community.smartsheet.com/discussion/comment/372154#Comment_372154

Can you post your solution here instead of people needing to email you to get the information? My work email is pretty locked down so that isn't really an option for me.

Genevieve P.

Hi @Sara Kouba

There's a post in the Best Practice topic that may be what you're looking for: Split Multiple Selections In Single Form Into Individual Rows (Core Product)

Andrée Starå

https://community.smartsheet.com/discussion/comment/432356#Comment_432356

I planned/plan to!

Daphne Zhou

Hi @Andrée Starå Could you be able to share your solution to my email at daphnezhou@nuralogix.ai, thank you.

beckyb27

https://community.smartsheet.com/discussion/comment/427915#Comment_427915

this is actually the only solution that works for what I need. I literally just did this (back buttoned the form submission) for 20 different people. My example: We have a form that people fill out when they complete a training. If everyone in my office takes the same course and we just want to give them credit for it without each person having to go in and submit a form, one form that allows me to put multiple names (and creates a different line for each of those names) is needed. The example I can think of is sending an email to multiple people, each email address is separated by a semi-colon, but each individual gets the email individually.

Andres 2 form solution (and perhaps I just don't understand what it is doing) seems to put parent and child lines.

Melody Kellogg

Also interested in the solution mentioned by @Andrée Starå. Would you be willing to post it here or email it to me at melody.kellogg@libraries.ok.gov?

Paul Reeves

@Andrée Starå

I hope you are doing well. Would you mind sharing your form solution with me, paul.reeves@hmhco.com? I am very curious how you are keeping or retrieving core information, and using conditional logic.

Thank you,

Paul

InvitedChaos

This would be a phenomenal feature for those of us looking to use a Smartsheet for collecting things like purchase orders requests. Currently, our users have to submit a form for each item requested, which is highly tedious when a request needs to be made for several items with the same vendor, project code, requestor name and department, end use, etc. Using a workaround to accommodate multiple items also causes challenges for auto-numbering, as there is no way to create only one ID number for a group of such items.

Fast-track this for Gov use, too, please!

Thanks!

LindaB_2019

I am also interested in the solution suggested by @AndreeStara. We need a form that has fields for all members of the team who need to review a document, and we need each reviewer to populate as a child line. Is this possible, or could it be considered in the road map. If you have suggestions or need more information please contact me @ lbumgarner@rhythmlink.com. Thank you.

Sean Flannagan

This would be a great option. We have providers put in product information,but we'd like to split out each product into a different line w/ the same client infomation, or if they do payment plan, to be able to separate each payment connected to the sale on a different line so payments could be tracked, applied and balanced in the month. Can't wait for this one.

SoS | Dan Palenchar

Hello everyone,

It's great to see this feature has been added to the roadmap. In the interim I recorded a video showing how to populate multiple Sheets with a single form entry, hope it helps!

https://www.youtube.com/watch?v=Ah1XrCAkhUc

Laura G

This would be a massive feature update! I gave up with using Smartsheets for my solution and moved to MS Forms. Happy to look at this in SS when it comes available.

Cierra

I would love this for multiple dates, is that possible?

Andrée Starå

https://community.smartsheet.com/discussion/comment/461780#Comment_461780

Hi,

I hope you're well and safe!

Yes! I have developed very advanced client solutions populating multiple rows with different dates and similar. (Advanced on the backend, easy for the client)

How would you need it to work more specifically?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!