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

  • Profile Image
    Asked 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.  


  • Profile Image
    Answered on June 12, 2014 at 06:13 PM


    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.