What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Configurable List: Can we split data into multiple columns in generated report?Asked by markcarlock 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?
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.
Ok thanks. Is there an option with the standard fields for the user to add another line?
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.