May 26, 2022 12:38 PM
Hello, I have uploaded a column with text string within quotes so that Airtable would populate the color combo multi-select options. But the quotations still appear with the text string. Is there anyway to remove or hide the quotations in the color combo multi-select field?
May 26, 2022 01:01 PM
Hi @Z_Teams ,
I cannot think of a simple way to do this in Airtable short of manually changing each entry to remove the quotations. I would suggest that you undo that Multiselect option and clean up your text in another application. Excel and google sheets have a convenient find and replace feature that should make quick work of it. Once you have it cleaned up redo the steps you took to create the select field.
May 26, 2022 09:44 PM
@Z_Teams Just manually remove the quotes from the multi-select’s “customize field type” settings, and it will affect all of your records as well.
May 27, 2022 06:56 AM
It works for me, and that is how multi-selects are designed to work. But if you are having difficulty, then I would recommend converting your multi-select field to a linked record field instead.
May 27, 2022 07:40 AM