How can I separate multiple answers in a check box field?

  • gemai
    Asked on October 26, 2015 at 10:05 PM

    Hi there

    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.

    Cheers

       Gema

  • Sammy
    Replied on October 27, 2015 at 4: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

    =split(C3,char(10))

    The char(10) is the ASCII equivalent of a new line, you should get a result similar to the screenshot below.

    How can I separate multiple answers in a check box field? Image 1 Screenshot 20

    Please let us know if this addresses your scenario.