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

    How can I create an order form for many items?

    Asked by FrescoLife on August 16, 2016 at 10:26 AM

    I currently have an order form built that provides a great end user experience - they get to select from multiple items and the form provides an updated total live based on their order.  However, when I receive the order on the backend (through a Google Doc spreadsheet), each order is lumped together in one cell and I have to manually separate the items -- so that I can total each item from all customers.  Is there a way to do this in either the reporting or the design of the form?

    Page URL:
    https://form.jotform.co/61765967852877

    order form create an order form create items
  • Profile Image
    JotForm Support

    Answered by david on August 16, 2016 at 11:31 AM

    If you don't mind recreating the form, you can use regular fields for your products.  Assign those fields calculation values if needed:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Add up those values or perform further calculations on them:

    https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form

    Then pass that total to your payment field:

    https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field

    This way, all your products will be separate fields and sent to the spreadsheet in different columns.  It will also give you much more freedom to set up products how you'd like.