- markcarlockAsked 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?Page URL:
- JotForm SupportMikeAnswered 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.
- markcarlockAnswered 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?
- JotForm SupportKevin_GAnswered 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.