For a multiple select field on a Drupal webform, only the first choice is recorded on the Google Spreadsheet.

When I use a multiple select field on a Google Form, the Google Spreadsheet is able to list multiple values (separated by commas) within one cell.

How do you get a Drupal webform to send multiple select values as a comma separated list to the Google Spreadsheet?

Comments

charlie-s’s picture

charlie-s commented
Assigned: Unassigned » charlie-s
Category: support » feature

This is not currently available, but it certainly should be. Multiple values should, in my opinion, be detected and inserted into a single cell as a comma separated list. Are there any other considerations to take into account?

escoles’s picture

escoles commented

If I understand the problem correctly, a potential workaround would be to create "multi-select" elements that have only a single element. (This is in fact what you need to do in order to make a checkbox-list Section 508 compliant.) If you create a select with only one element, using checkboxes, will it work?

charlie-s’s picture

charlie-s commented

That would probably work just fine, and then you'd have a column for each checkbox, i.e.

Apples | Oranges | Bananas
   x        o         x

That might even be more "recommended" than a comma separated list, which is probably not very useful.

LaurenW’s picture

LaurenW commented

I am also interested in a feature that would pull over a comma separated list for multiple selections, as having a separate selection for each item would greatly complicate and enlarge my Google Doc. Just wondering if anyone is still looking into creating this feature as I don't have the program knowledge to create a patch.

Thanks!

charlie-s’s picture

charlie-s commented
Issue summary: View changes
Status: Active » Closed (fixed)

This now works via a simple line break in the Google Sheet.