JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Show multiple product orders and quantity field in separate columns in the submission excel reportAsked by Julie on August 14, 2015 at 01:41 PM
I am using JotForm to process multiple product orders and all order information is stored in one single cell in the submission file. I need the products to be listed in one column and quantities ordered in another column in order to sort and calculate sales volumes. I am currently using PayPal for payment processing. If I can't solve this with PayPal, does another payment processor provide better data in the submission file? Ex. admission tickets, quantity, raffle tickets, quantity, T-Shirts, quantity.
Unfortunately, the excel report was designed to output the order details in one cell.
However, we received similar request about that and I believe it would be better to separate the orders per column, so that you can easily tally or create graphs for the orders. Although I'm not sure if we can have the order description and the quantity have separate columns, it might be too populated for the excel, but I'll attached it on my report.
Here's how I am visualizing it:
For now, you might need to manually separate each product orders in the excel file, or use a special formula. We will update you on this thread when we hear any news on this feature request.
I have exactly the same problem. I need some kind of report where I can quickly calculate the total number of items ordered, per item. If I have to start changing things manually, there's not much point in using the form in the first place - that's the whole reason why I'm looking at something like Jotform. What do you suggest???
I have moved your question to a new thread so that we can address it separately: http://www.jotform.com/answers/640722
I assume since there are no replies here in over a year, this still has not been addressed?
The quantity needs to be able to pull out in individual column. I understand keeping order details in a single column, well actually no I don't.
Please, please, please address this request soon! In my case I am selling tickets to an event, and I will have to manually write in the quantities into their own column in order to create a count, and use the data in exporting a mail merge.
I have moved your question to a new thread and you will be answered here: https://www.jotform.com/answers/970511