How to separate payment information on reports?

  • Profile Image
    SueMuldoon
    Asked on January 22, 2018 at 03: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?

  • Profile Image
    aubreybourke
    Answered on January 22, 2018 at 04:15 PM

    Can you tell me which form you are talking about?

    Where-to-Find-My-Form-URL 

  • Profile Image
    SueMuldoon
    Answered on January 22, 2018 at 04:24 PM

    https://form.jotform.com/41586881211153

  • Profile Image
    SueMuldoon
    Answered on January 22, 2018 at 04: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

    ________________________________
    ...
  • Profile Image
    Kevin_G
    Answered on January 22, 2018 at 06: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. 


  • Profile Image
    SueMuldoon
    Answered on January 22, 2018 at 08:43 PM
    Thank you
    Sent from my Verizon, Samsung Galaxy smartphone
    ...