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

  • Profile Image
    nickjp
    Asked 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

  • Profile Image
    Charlie
    Answered 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.