What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    My form has multiple products and multiple sub options.

    Asked by susantjipto 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
    JotForm Support

    Answered by david 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.