I want the data from a widget in separate columns.

  • Profile Image
    Aurko
    Asked on October 05, 2018 at 12:40 PM

    I want the data from a widget in separate columns. Right now, all the different answers are coming together in one column. Any way to get the data in the required format?

    Or alternately, is it possible to have the add function for a set of questions outside a grid?



    This is a re-post of a comment on How to Download Form Submissions as Excel/CSV/PDF

  • Profile Image
    Kevin_G
    Answered on October 05, 2018 at 02:14 PM

    Unfortunately, it's not possible to split the data in the widgets, due to the way how widgets are built, the data will be collected in a single place meaning that when you download the report, the data will be contained in one cell. 

    Now, if you want to have the data separated, you may add multiple fields and conditionally show them, for example, you may ask the user if a new element will be added and then show the next set of fields according to the answer. 

    Here's a guide that will help you with the show/hide conditions: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer 

    I hope this helps.