Is there a way to separate fields of the Configurable List widgets in reports?

  • bkbarnes
    Asked on July 19, 2016 at 10:52 AM

    In our form we have a section entitled "family info" in which they add several bits of information...

    First Name, Last Name, Gender, Age, Volunteer Area

    When I run an Excel or CSV report all that information appears in one column on the report.   I need to be able to separate them into different columns.  Is there a way to do this, or rework the form to allow this.  You will notice that I also need to ability to dynamically add for "family members" as needed.

     

    Thank you,

    Bryan

  • Jan
    Replied on July 19, 2016 at 2:54 PM

    I believe you are referring to the Configurable List widget. As I understand, you want to have a separate columns for each form field in the Excel Report. 

    Is there a way to separate fields of the Configurable List widgets in reports? Image 1 Screenshot 30

    Unfortunately, this is not possible in Excel or Google Sheets. The generated Excel file will create a column or a single cell for each form field. If you want to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel. Here's a related link: https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    The Configurable List widget will show up in a table separated by columns if you use the Grid Report. Please check this guide on how to create a Grid Report.

    Is there a way to separate fields of the Configurable List widgets in reports? Image 2 Screenshot 41

    If you have any questions, let us know. Thank you.

  • RMFAregistration
    Replied on December 4, 2016 at 1:48 PM

    Hi, 

    This an issue I'm dealing with right now, and I thought this 'Text-to-Columns' function in MS Excel would sort things.  However, the additional rows (in the configurable list) end up just being additional columns rather than rows.  It looks to me like there isn't really a good way to download the information entered into the configurable list for use in MS Excel (and eventually into MS Access which is what I want to be able to do).  Or am I missing something?

    Karen

  • Welvin Support Team Lead
    Replied on December 4, 2016 at 2:52 PM

    @RMFAregistration: I will address your issue here: https://www.jotform.com/answers/1003465