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

  • Profile Image
    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?

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

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

    1514269524Screen Shot 2017-12-26 at 7.31

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

    1514270747Screen Shot 2017-12-26 at 7.35

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

    1514270847Screen Shot 2017-12-26 at 7.35

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

    1514270894Screen Shot 2017-12-26 at 7.43

    Then you can pass that calculation to payment field:

    1514271018Screen Shot 2017-12-26 at 7.55

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

    1514271126Screen Shot 2017-12-26 at 7.50

    Hope it helps.

    Let us know if you have any further questions.

    Thank you!

  • Profile Image
    Brydon
    Answered on December 26, 2017 at 09:38 PM

    You are great!   Thanks!