Separate product field into different columns

  • Profile Image
    chrispy85
    Asked on January 05, 2022 at 04:05 PM

    We are in the process of implementing a jot form for a group of individuals to place orders. I see that there is a report option. Is there a way to break apart the "product" section a shown below?

    When I pull the report I would have to manually separate that column?

    Please advise

    Thank you!

    1641416708_61d6080406a5c_

  • Profile Image
    JohnRex
    Answered on January 05, 2022 at 09:48 PM

    Unfortunately, there is no option to place the selected products into separate columns. Note that a column in the Jotform Table represents a single field, and since the Product List field is treated as a single field, it'll only occupy a single column in the table.

    And yes, one workaround for that is to download the data into an Excel file then manually separate the values into separate columns.

    Another workaround is to create your products outside the product list field and use regular fields such as single choice, multiple choice field, or widgets like in this example: https://www.jotform.com/answers/2275302