- FrescoLifeAsked 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:
- JotForm SupportdavidAnswered 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:
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.