How to separate payment information on reports?

  • SueMuldoon
    Asked on January 22, 2018 at 3:05 PM

    When I get a report in excel with online sales, it is all gathered in one cell. Is there a way to have it broke down into individual product columns?

  • aubreybourke
    Replied on January 22, 2018 at 4:15 PM

    Can you tell me which form you are talking about?

    Where-to-Find-My-Form-URL 

  • SueMuldoon
    Replied on January 22, 2018 at 4:24 PM

    https://form.jotform.com/41586881211153

  • SueMuldoon
    Replied on January 22, 2018 at 4:43 PM
    Here is a sample form:
    https://form.jotform.com/41586881211153
    When the excel sheet comes in, all the orders come in one cell.
    I would rather they came in independent cells.
    Is that possible?
    _______________________________
    Sue Muldoon
    860-394-5470
    www.suemuldoonimages.com
    www.reduxforyou.com
    www.farmersmarkettrail.com
    Follow us here:
    [1488378249742_Linkedin.png] LinkedIn [1488378365999_Instagram.png] Instagram [1488378477405_Twitter] Twitter [1488378521819_Facebook.png] Facebook

    ________________________________
    ...
  • Kevin Support Team Lead
    Replied on January 22, 2018 at 6:28 PM

    Thank you for the details. 

    Unfortunately, the payment information cannot be separated on reports, the information submitted there counts as a single field and the array of data is tied to the payment field. 

    If you would like to have products separated per cell, then you will need to use basic fields instead, perform the calculations and pass the total to the payment field, these guides will help you doing so: 

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

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

    https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field 

    I hope this helps. 


  • SueMuldoon
    Replied on January 22, 2018 at 8:43 PM
    Thank you
    Sent from my Verizon, Samsung Galaxy smartphone
    ...