What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Using PayPal for multiple products - Excel report puts them all in one cellAsked by raiderdrama on December 02, 2016 at 02:36 PM
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?
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.