Sign in to submit new ideas and vote
Get Started

Multiple Line Entries with one Form Submission

It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team.


As of now, form entries can only create singular row entries on sheets.

Tags:
70
70 votes

On Roadmap · Last Updated

While we can't yet provide a timeframe for release, we're very happy to share that this is in our future plans. We know this would be particularly helpful in reducing overhead for those filling out forms, making forms a more effective tool. Keep commenting on this post to explain how you would use this or what you would expect to happen - your feedback is appreciated!

«13

Comments

  • Lili6917
    Lili6917 ✭✭
    edited 04/23/24

    Using Smartsheet for QC sample submission. Some end users may have 10 different samples to submit- having to fill out the form 10 times is not an efficient use of time and there are many redundancies in each entry. Would be great for entry of one form fillable field to be able to have multiple lines of text that are then copied over into multiple entry lines within the intake sheet. Thanks for consideration!

  • kccheng
    kccheng ✭✭
    edited 11/13/24

    I have one use scenario that external collaborator need to create multiple lines through intake forms. Now they need to repeat this process one by one, if they need to create 50 lines, they need to create intake forms 50 times. We need a new feature to create multiple line via a single form.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 11/13/24

    Hi @kccheng

    I hope you're well and safe!

    I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

    Would that work/help?

    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.

  • Forms need to be able to generate multiple rows based on the information inputed.

    For example: I work in a laboratory and I create a number of "plates" for each project. Each plate has identical information except for a few columns which can be altered manually. If I'm going to create eight plates, there needs to be an optional section on the form that causes it to generate eight entries rather than submitting eight forms. I can do this with a few lines of code in excel, it will take very little effort to implement.

  • Monicacraven
    Monicacraven ✭✭✭✭✭

    It would be just as helpful if a user could choose after submission to "Submit another response" that way they don't have to go back to the original link, they could stay in smartsheet and submit over and over again?

  • Hey @Monicacraven

    This is currently possible! 🙂

    In the Form Settings, you can have the form "reload" after it's been submitted so they can stay on the same page and submit the form multiple times.

    Here's more information: Manage Form Display and Submission Options

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • Monicacraven
    Monicacraven ✭✭✭✭✭
  • Carrie Barnett
    Carrie Barnett ✭✭✭✭

    We use Smartsheet to create class schedules - some courses have 20 classes that need to be scheduled - it would be great if all 20 classes could be created with the same form submission, thereby creating 20 rows in the collecting sheet. Right now, we have to use sheets for data entry so that we can see the entire schedule for one "course block". It makes for much more work on the back end.

  • AEForrest
    AEForrest ✭✭✭

    Hi Carrie, can you provide more context on this issue so that someone can suggest a solution?

    Do you want the form to be used by the teacher or the student? Are the classes already scheduled and then just need to be chosen?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Carrie Barnett

    I hope you're well and safe!

    I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

    Would that help/work?

    I hope that helps!

    Be safe, and have a fantastic weekend!

    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.

  • Carrie Barnett
    Carrie Barnett ✭✭✭✭

    Hi @AEForrest - sorry for the delay in my response, and thanks for giving it some thought! We work with a few outside partners that schedule our classes using their "instructors" (teachers) and locations. The form would be used by our partners' schedulers to tell us the date, time, location, and instructor for each session within a course block. One course block has 20 sessions, each of which results in its own row in the collective "main class schedule" which is then published (connected to another system) for learners to enroll in the course block or individual sessions. Where I'm trying to get to is that our partners submit one form that creates 20 rows in the receiving sheet. Let me know if that doesn't make sense.

  • Carrie Barnett
    Carrie Barnett ✭✭✭✭

    Hi @Andrée Starå , sorry for my delayed response - I appreciate your thoughts on this. I am trying to get the schedule for all 20 classes on one form submission, so that it creates 20 rows in the receiving sheet that can then be ushered through the approval process.

  • @Andrée Starå I am setting up a form to do something similar. Setting up a form for our distributors to sing up for training. Want them to be able to sign up with a main contact and then add several participants, with each being on a separate line. I did setup 2 forms, so that the main info is entered, and then the form to load the participants is loaded after the initial submission. However, that means those lines leave the main contact blank. Is there a way to autoload the main contact info to those rows?

  • This definitely needs to become a feature. We are trying to collect information that needs to be listed in different rows vs different columns. With not being able to do this via a form, I am having to send out an excel doc to collect this information and then have it sent back.