How to create a multi-product purchase option that can then be exported with a different cell for each product purchased

  • skatelikeagirl
    Asked on October 10, 2017 at 7:29 PM

    I am trying to create a product option where a customer can select several items to be added to their cart:

    1507677166form 1 Screenshot 10

    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:

    1507677345form 2 Screenshot 21

    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:

    https://www.jotform.com/answers/417096-Purchase-Order-field-all-products-are-in-single-cell-when-exported-to-Excel

    And it seems the original issue was brought up in 2012, but I do not see a resolution



  • John_Benson
    Replied 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:

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

    Let us know how it goes. Thank you.