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.
Is there a way to separate fields of the Configurable List widgets in reports?Asked by bkbarnes 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.
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
If you have any questions, let us know. Thank you.
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?
@RMFAregistration: I will address your issue here: https://www.jotform.com/answers/1003465.