Configurable List: Can we split data into multiple columns in generated report?

  • Profile Image
    markcarlock
    Asked on February 01, 2017 at 10:55 AM

    I have the configurable list widget on my form and when I download the submissions in excel I'm wondering if there is a way to separate each field such as item, cost, total cost, in it's own column in excel.  Right now it puts it all together so I can really get much data from the way it's laid out.  Maybe there is a better widget to use for this?  Also is there a way for the total cost to calculate automatically? 

  • Profile Image
    Mike
    Answered on February 01, 2017 at 11:36 AM

    Unfortunately, we do not have any built-in option to split the Configurable List widget data into multiple columns in Excel. Some basic calculations are available within a Spreadsheet widget, but submitted data will be still in one column.

    To get separate columns and calculations you might consider using standard fields.

    How to Perform Form Calculations

    Thank you.

  • Profile Image
    markcarlock
    Answered on February 01, 2017 at 12:56 PM

    Ok thanks.  Is there an option with the standard fields for the user to add another line?

  • Profile Image
    Kevin_G
    Answered on February 01, 2017 at 01:14 PM

    If you need the info to be separated in columns in Excel then you will indeed need to use basic or quick fields, there is not a way to multiply these fields and you will need to add all the set of fields manually. 

    You could add a radio button, for example, and ask your user if a new set of fields will be added and then based on the answer you could show the new set of fields. 

    Here's a guide that will help you to achieve this: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Hope this helps.