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.
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?
If you don't mind recreating the form, you can use regular fields for your products. Assign those fields calculation values if needed:
Add up those values or perform further calculations on them:
Then pass that total to your 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.