How to separate products of the payment field and set them as headers in CSV report?

  • Profile Image
    Asked on December 25, 2017 at 10:25 PM

    I need to put each product as a header in the CSV file and the option as the data in the row.   Is there a way to set this up?

  • Profile Image
    Answered on December 26, 2017 at 01:32 AM

    I assume that you are referring to the products of your payment field. Unfortunately, that is not possible. All products will be placed inside of the single row inside of the CVS report. You will have to separate them manually. 

    If you want to have each product in a separate column inside of the CSV report, you will have to recreate your form and set the products outside of the payment field using the basic form elements. In this case, you will also have to perform the calculation inside of the form and pass the calculation to the payment field. This guides can help you to achieve that:

    How to Perform Form Calculation Using a Widget

    How to Assign Calculation Value

    How to Pass a Calculation to a Payment Field