What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    We're setting up an order form. When a person orders more than one of the same item, will the database reflect one line (one order) or multiple lines

    Asked by dansimrell on June 12, 2014 at 04:51 PM

    Here's our issue.  We want people to be able to order multiple units, but right now, each unit is individually packaged and must be shipped individually.  We are using Endicia for mailing lables and need one label for each unit.  They will all go to the same person, but Endicia only recognizes each order line in the spreadsheet.  

    Hmmm.

    order form multiple lines
  • Profile Image
    JotForm Support

    Answered by jonathan on June 12, 2014 at 06:13 PM

    Hi,

    To clarify, every time the form is submitted, it will be equivalent to one line/row of record in the database. Simply put, one submission equals one submission line. You can see this in your form's submissions page.

    I checked your form http://www.jotform.com/41626564233958 , and there was only one item in the Product list. When you submit this form, there will be one item/product only in the submission data.

    If you add multiple item in your Product list and allow multiple selections, the submission result will still capture the multiple selected items on the same line (meaning same submission)

    But you can actually make the user re-submit the form multiple times also and let them choose different item every time. This way, although it will be different line(each submissions), the main information like names, email.. so on will still be the same, but the items selected will be different each time. This makes your submission database have multiple lines for each selected item.

     

    Hope this help. Inform us if you need further assistance.

    Thanks!