-
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: https://form.jotform.co/61765967852877 -
David JotForm SupportReplied 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.