I need to put each product as a header in the CSV file and the option as the data in the row.

  • Brydon
    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?

  • Nik_C
    Replied on December 26, 2017 at 1:52 AM

    Unfortunately no, that is not possible when products are represented with Payment field:

    1514269524Screen Shot 2017 12 26 at 7 Screenshot 10

    The workaround would be to use drop-down fields for example:

    1514270747Screen Shot 2017 12 26 at 7 Screenshot 21

    To represent each product, where options of dropdown will be the actual products and calculation values prices:

    1514270847Screen Shot 2017 12 26 at 7 Screenshot 32

    We do that for each product and sum them with form calculations widget:

    1514270894Screen Shot 2017 12 26 at 7 Screenshot 43

    Then you can pass that calculation to payment field:

    1514271018Screen Shot 2017 12 26 at 7 Screenshot 54

    And this is how the products will be shown in CSV:

    1514271126Screen Shot 2017 12 26 at 7 Screenshot 65

    Hope it helps.

    Let us know if you have any further questions.

    Thank you!

  • Brydon
    Replied on December 26, 2017 at 9:38 PM

    You are great!   Thanks!