Exporting to Excel

  • Profile Image
    SheilaBradleyBooks
    Asked on September 12, 2017 at 02:48 PM

    Hi.  I love that I can export my submissions into an excel spreadsheet.  Is there a way to separate the products ordered into their own columns?  At the moment it is putting all the products and quantities in one column.  This makes it difficult to see and organize.  It there a way for each product to have its own column?

    thanks!

  • Profile Image
    david
    Answered on September 12, 2017 at 03:12 PM

    Currently, any data that is captured in a single field is exported to a single cell in spreadsheets.  If you would like to have separate products and options exported in separate cells, it would require setting up your products and options outside of the payment field. 

    This can be done using whatever type of fields best suits your options.  Number fields for quantity options, checkbox fields for multiple selections, single select fields for single choice fields etc. 

    Once you have your options set up, you can assign calculation values to options:

    https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Then perform calculations on those values and other forms entries:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    Once you have your total, you can pass that total to the payment field:

    https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field

    This way, you products and options won't all be contained in a single field.