I don’t believe this is a bug. The multiple select works by writing a comma separated list of selections to the target column. So if you include commas in your choices, then naturally this will break it.
What you should do is use different columns for each of the “Values” and “Display as” options in your choice component. For example, use something such as a RowID for the “Value”, and your column that includes commas as the “Display as”.
Thank you for responding. I have written statements… sentences, so they are not necessarily easily placed in different columns. For example, a statement like this one that requires a comma.
I am trying to follow your suggestion, but I am not really clear about how to use it with sentences.
For example, these are three actual statements that are not clickable, but require commas:
- I believe God is One and is expressed through the Trinity - Father, Son and Holy Spirit. - I believe regardless of the Name given or language the Name is called in, there is one God. - I believe God is greater than human expression or description, God is all there is.
What would your suggestion be for making them selectable?
