- supernetAsked on January 25, 2018 at 10:12 AM
I want to create a form with a table in it that allows for both text input and drop down box selection. How would I go about doing this? Example is below:
- JotForm SupportdavidAnswered on January 25, 2018 at 11:17 AM
If you want different field types, using a configurable list widget would be the way to go:
Though it may require using multiple widgets due to the widget of your table.
- supernetAnswered on January 25, 2018 at 12:33 PM
I used that widget, but it puts everything from the widget into one cell when I download the submissions in Excel format. I tried the Text to Columns option in Excel, but it will not separate the headers from the input. So I cannot work with the data it provides. Am I missing something?
- JotForm SupportdavidAnswered on January 25, 2018 at 01:40 PM
Any data collected in a single field will be exported in a single cell in spreadsheets. This includes when using an input table. The only way to have them separated by default would be to use separate fields for each input.