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

  • Profile Image
    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

  • Profile Image
    Jan
    Answered on July 19, 2016 at 02: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. 

    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.

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

  • Profile Image
    RMFAregistration
    Answered on December 04, 2016 at 01: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

  • Profile Image
    Welvin
    Answered on December 04, 2016 at 02:52 PM

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