- skatelikeagirlAsked on October 10, 2017 at 07:29 PM
I am trying to create a product option where a customer can select several items to be added to their cart:
In this instance the product is for different weeks and locations of camp. When I export the form entry however, all products appear in a single cell rather than seperate cells:
This makes it extremely difficult when trying to sort out attendance for different camps, as well as makes it difficult when trying to reconcile accounting. I also do not want to have to have my customer fill out and complete multiple of the same form to be able to purchase multiple of the same item as the form needed is extensive.
As you can only create one section for products, I am not able to make these separate fields for export. Is there some other way to set this up so that each product purchased is exported as a separate line or cell?
I found this previous question:
And it seems the original issue was brought up in 2012, but I do not see a resolution
- JotForm SupportJohn_BensonAnswered on October 10, 2017 at 10:37 PM
Unfortunately, there is no way to get the payment details split into multiple columns on the Excel report. However, you can try to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel:
Let us know how it goes. Thank you.