Forms that need to incorporate multiple line entries

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Forms that need to incorporate multiple line entries

We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible

As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed

Are we able to set up a Smartsheet form to replicate this please?

I look forward to hearing from someone!

Many thanks

Comments

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

    Hi Trevor,

    A possible workaround could be to have two forms. First, they fill in the main form and then the part rows. For each part, the form would reload.

    Make sense?

    Would that work?

    I hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

     

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

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

    To add:

    The main form completed > Loads the part form > completed > Loads the part form again and so on.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hello Andrée,

    Yes, maybe not ideal but that might possibly be workable for us.

    Do you have an example so that we could see what exactly you mean?

    Many thanks

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

    Happy to help!

    Can you email me at [email protected], and I'll share an example with you?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hello Andrée,

    Did you get my email reply?

    Many thanks

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

    Hi Trevor,

    Which one? wink

    I got one that it would be too confusing, and I replied that another option could be to create a sheet template and have the rows automatically moved to the order sheet.

    Did you get that one?

    Would that work?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hello Andrée

    Yes, and thought I'd replied to that one too! Must have got lost on route to you?!

    Very much appreciate your input into this but I couldn't work out how it would physically work for us. Maybe you could show me by a quick screen share or bullet point list, could you?

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

    I'm always happy to help!

    I'll share something later in the week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hello Andrée,

    Can you send me your solution example? This may help me break up a very long form into two parts. Ideally, it would be better if I could use logic (if they select "yes" to a question, then the remainder of the form fields would unhide). However, I don't think this is an option in Smartsheet right now.

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

    Hi Ann Marie,

    I just shared the template with you.

    It's two forms.

    • The main form to fill in the order data (Opens the Part form when submitted)
    • The part form to add all the parts for that order (Reloads after each submission)

    Another option could be to create a sheet template and then have the rows automatically copied to your order sheet.

    Let me know how it goes!

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree, if you are using 2 forms, would not that create 2 separate records in the sheet?

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

    Hi @Ella

    It will create multiple records.

    The first form is for the primary information, and that row will be colored through conditional formatting.

    The second form is for adding one part in the order for each form submission.

    Make sense?

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree it makes sense, but I am curious how are they going to match the 2 records created in the sheet? Don't they have to resubmit some of the info from the first form via the second form as well?

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

    For this use-case, they didn't need to match, so it will be the separator that would split the orders.

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.