- gemaiAsked on October 26, 2015 at 10:05 PM
My checkbox field has a number of options. If the user chooses more than one option, all the ticked options appear concatenated in the field in my integrated Google sheet. How can I add a separator (i.e. ",", ";"...) between options?
Without separators, the concatenation is a 'new' (and wrong) value in my graphs generated from the Google sheet.
I found a thread about this issue but it's quite old and I can't see the examples anymore.
- SammyAnswered on October 27, 2015 at 04:23 AM
At the moment it is not possible to specify the delimiters for the check-boxes, the default delimiter used is a new line.
You can however us a formula in google spreadsheet to split the entries to new columns using the new line as the delimiter.
The formula is as follows
The char(10) is the ASCII equivalent of a new line, you should get a result similar to the screenshot below.
Please let us know if this addresses your scenario.