- raiderdramaAsked 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?
- JotForm SupportBDAVIDAnswered 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.