My form has multiple products and multiple sub options.

  • Profile Image
    Asked on February 16, 2017 at 10:27 AM

    My form has multiple products and multiple sub options. All product details came over to Excel in one column, I need a way to parse them out into its own column. What's the best way to do that?

    This is a re-post of a comment on How to Export Form Data to Excel

  • Profile Image
    Answered on February 16, 2017 at 12:46 PM

    I believe the setup you are looking for is a bit more complex than the payment field allows for.  For more complex setup's like yours, I would recommend using regular fields like text boxes, number fields and checkboxes to create your products and options.  You can then assign though options calculation values:

    You can then total up the options and multiply costs by quantities selected using a calculation field:

    That final total can then be passed to your payment field:

    This will allow for much more control over add on options and such rather than having to charge for the other options in another form.  Selections and options will also be exported to spreadsheets in individual cells.