JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How can I separate multiple answers in a check box field?Asked by gemai 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.
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.