- BarryPlantAsked on October 05, 2016 at 11:44 PM
I would like use the configurable list widget in for the forms we use in our group. The only issue is when we need to download the information into Excel it put all the information into 1 cell so we may have 5 different questions that need to be answered and we can't have them all in the same excel cell.
Is there a way we can have use configurable list but have the information in different cells.
- JotForm SupportChriistianAnswered on October 06, 2016 at 01:38 AM
Unfortunately there is no option to automatically have the data from the configurable list stored into different cells. Each widget in the form is considered as one field, so even though the configurable list can have multiple data, it is still considered as one field, and as such these data will still go in a single cell in the Excel file.
The only way you can have the data into multiple cells is to manually split them after you have downloaded the Excel file. You can achieve this by using the Convert Text to Columns feature from Excel. Here's how: Split text into different columns with the Convert Text to Columns Wizard
If you need further assistance, please let us know.
- BarryPlantAnswered on October 06, 2016 at 01:40 AM
Thanks for this, would you have happen to know a widget we could use that will allow multiple entries on on the same line where the information is split in excel automatically?
- JotForm SupportChriistianAnswered on October 06, 2016 at 01:57 AM
Unfortunately all the widgets that allow multiple entries will have the information in one cell only. There is no widget available that lets you automatically split the information into multiple cells.
If you want the data to be stored in multiple cells in Excel, you will have to use the regular form fields (textbox, textarea) found in your form builder.