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.
Separate Product Items and Total into two columns in Excel ReportAsked by anamaineforms on August 14, 2014 at 02:30 PM
I have two questions:
1. JotForm Submission Report
In the submission report (Excel) the Total amount is listed with the product in the Products column.
Ex: Student: No Early Bird Rate (Amount: 45.00 USD)
Is there a way to create a separate "Total" column next to "Products" column on the spreadsheet that shows the amount?
It would be something like this:
Student: No Early Bird Rate (Amount: 45.00 USD)
2. Item ID on PayPal Pro Report - please see: http://126.96.36.199/Doc-Vault/report.xls
On the PayPal Pro transaction report there are fields (columns) that are passed from JotForm. I believe one of the fields is "Item ID". I want to add data to this field - I want to use it as a hidden field. Where in JotForm do I find it?
There are also other fields in the PayPal transaction report, the address fields (highlighted in red) is there a way to populate these through the JotForm form?
The reason for this request: my client wants to use one PayPal Pro account for different forms with separate JotForm accounts. One person will be managing PayPal Pro and that person needs to know which transaction is from which form(account). This person doesn't want to get any JotForm notifications. So adding hidden field on forms is not going to help.
What I want is a field(s) other than transaction fields that can be passed to PayPal Pro. Or if you have a recommendation/work around for my needs.
The Excel spreadsheet: yellow highlights = had data but removed them for security reason.
Thank you for your help!
With regards to your first question, unfortunately, that is not possible. Product Items and Total are currently into a single column and there is no way you can edit it in your Jotform dashboard. We can send a request to our developers if you want to.
Your second question has been moved here: http://www.jotform.com/answers/416431. Please kindly check.
Just happened to come across this post. I was also looking to break each product down into separate columns, as well as the total. If the developers can work on this for a future release that would be extremely helpful. We have to manually separate each product right now and it's a bit time consuming.