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.


  • Profile Image

    Show multiple product orders and quantity field in separate columns in the submission excel report

    Asked 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.

    Page URL:
    http://www.jotformpro.com/form/52235238672961

    excel product separate columns and
  • Profile Image
    JotForm Support

    Answered by Charlie on August 14, 2015 at 04:43 PM

    Hi,

    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.

    Thank you.

  • Profile Image

    Answered by Jen  on August 17, 2015 at 02:11 AM

    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?
    ??
  • Profile Image
    JotForm Support

    Answered by ashwin_d on August 17, 2015 at 07:02 AM

    Hello Jen,

    I have moved your question to a new thread so that we can address it separately:  http://www.jotform.com/answers/640722 

    Thank you!

  • Profile Image

    Answered by swalker286 on October 24, 2016 at 08:14 PM

    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.

    https://www.jotformpro.com/form/53054767066965

  • Profile Image
    JotForm Support

    Answered by ashwin_d on October 24, 2016 at 10:50 PM

    Hello swalker286,

    I have moved your question to a new thread and you will be answered here:  https://www.jotform.com/answers/970511 

    Thank you!