Comma hack that works in multiple choice selection

Community Resources
1

My team found a hack, that allows the selection of Multiple choices, for selections that include a comma.

The hack was to use a special character, that looks like a comma, but is not the same.

If you see the screen below, the commas look identical, but one is created using special characters.

1600×529 74.5 KB

But when you split, you will also need the special character as well.

You can make a copy of the sheet here to try:

This is how it looks like on Glide:

image
image1740×976 69 KB

Have fun!

3 Likes
2

@ThinhDinh I would move this in Community Resources

2 Likes
4

Thanks for sharing!

1 Like
5

I have to comment on this, sorry. This strikes me as an incredibly fragile hack, and I would never consider using it, nor would I allow it to be used in any of my Apps. It’s also completely un-necessary. The proper way to deal with this is to use RowID for the choice value.

4 Likes