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

    Can the product details in the submission be separated to different columns in excel file?

    Asked by nickjp on May 26, 2015 at 08:29 PM

      What I am trying to do is have people order lunch one or more days of the week.  What I would like is to have is an easy to read and gather data from my spread sheet.  This is what I get: (this would be 2 different orders from 2 different people.  Same with the example below)

    My Products: Products
    Monday Lunch  (Amount: 5.00 USD)
    Tuesday Subway (Amount: 5.00 USD, Subway: Ham)
    Total: 10.00

    _____________________________________(cell divider)
    Monday Lunch  (Amount: 5.00 USD)
    Tuesday Subway (Amount: 5.00 USD, Subway: Veggie)
    Total: 10.00



    This is what I would like to see: along with a column with the total amount collected.  What am I missing here.
    Monday 6/15    Tuesday 6/16 (Subway 6")
    Pizza  |  Turkey

             |

    ____________________________(cell)
    Pizza  |  Ham
             |


    Thanks for your help.

     

    form is still in the development stage

    Page URL:
    http://form.jotformpro.com/form/51443596079969

    order form excel create an order form create
  • Profile Image
    JotForm Support

    Answered by Charlie on May 26, 2015 at 11:33 PM

    Hi,

    The reason is that the product field is treated as one item, which means it will have one column when exported to an excel/CSV file.

    If you wish to display your products one column at a time, you can if you'll create the products using the plain form fields like text boxes and not in the payments wizard, you can perform form calculation for the prices of it by following this guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form. We can then pass that calculated price directly to your payment wizard. Here's a guide on how to pass the calculated field in your payments wizard: http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field

    I hope that helps.

    Thank you.