-
JustinAsked on June 24, 2020 at 8:31 PM
For questions that allow multiple responses (such as a checkbox), I would like the csv export to show responses within each cell with commas after each item the form response checked off. For example, if the form question is:
What are your favorite colors?
[] Red
[] Blue
[] Green
And if someone responds that they like all three colors by checking them all off, I would like the export for that cell to show:
Red, Blue, Green
Currently, I see this within a cell when exporting the form responses:
Red
Blue
Green
-
Mike_G JotForm SupportReplied on June 24, 2020 at 9:45 PM
I would like to apologize for any inconvenience, but there is no option to update the output of the Multiple Choice field in the exported Excel/CSV file within the form.
A workaround is to pass the value to a Short Text field in the form using conditions and refer to that Short Text field in the Excel/CSV file.
Reference Guide: How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition
Feel free to let us know if you need any further assistance.