Using PayPal for multiple products - Excel report puts them all in one cell

  • Profile Image
    raiderdrama
    Asked on December 02, 2016 at 02:36 PM

    Hello!

     

    I love using your tool and have created a very user friendly form for my customers.

     

    I'm looking for help in adjusting the data that I receive on the backend.  My form uses PayPal Integration to sell several products, including tickets to a play, meals, etc.  When I download the Excel report of all of my submissions, it is putting all of that data into one cell on my spreadsheet, but I would like to see each purchased item in a different column on the spreadsheet.  Is that possible?  Is it a change in how I download the data or do I need to change the way my form is built?

     

    Thanks,

    Jill Dalton

  • Profile Image
    BDAVID
    Answered on December 02, 2016 at 05:46 PM

    Unfortunately, that is not possible since the payment integration is considered as one field, therefor all the selected items are displayed in one cell.

    As alternate workaround, you could separate your product into native fields(Drop downs, text box, check box, etc), and assign them a value if needed: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Then perform calculations to gather the total from those fields: https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form

    And finally pass the total amount to your PayPal integration in order for the user to pay: https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field 

    In that way, each product will be shown in separate cells of your Excel report.

    Please note that the details of the purchased items will not be passed to PayPal page, only the total amount.

    Let us know if you have more questions, we will be glad to assist you.