Thank you all for your help and contributions. I am new to Glide too, as @padthai2go, and that’s why I initially faced that problem.
I finally came up with 2 solutions, one inside Glide and the other one in Airtable:
As @Jeff_Hager explained, a Joined List column will convert the array to a single value that can be used anywhere in glide that only accepts a single value. This is done directly inside Glide (even though the table is in Airtable).
It’s possible to do exactly the same thing inside Airtable too with a formula. It’s not called Joined List in Airtable and does not allow to change the separator (unless another formula does).
Now that would have been nice to have a component in Glide that displays directly the result as pills (in a way Glide does it aliready in the data editor).
Late answer but the multi-select column from Airtable appears correctly in Glide data editor
It’s just that there is no component that deal with it directly in Glide layouts. It requires a workaround.
To continue the discussion, we have solved the first problem of reading and displaying the data coming from an Airtable Multiple select column in Glide layouts.
But the second problem remains: How to write in an Airtable Multiple select column from a Glide Add form or a Glide Edit form ?
Well, I think it’s impossible.
From my tests (but I’m just a beginner with Glide), the only solution I found is:
Build an addtionnal table containing the values of the “Multiple select” column (this table is often called Choices in Glide examples)
Change the field type in Airtable from “Multiple select” column to “Link to another record” column and link to that new Choices table. Then it will be possible in Glide to read and write to that field.
My conclusion: if you are using Airtable with Glide, do NOT use a “Multiple select” column in Airtable IF you need to WRITE in that column from Glide.
Just following this up, is there already any solution on glide to work with “multiple select” columns from Airtable (w/o workaround)?
I still have this problem that the data are shown in the data editor but not in the layout/in website.
Interesting is that the “Filter by” detects the missing column data (category).
Thanks for help.
PS: I read all the workaround above…
New Glide user here - I also have the same challenge! I have a multi select and single select table base in Airtable. The only fields that Glide picks up are the text only columns from Airtable.
Can anyone confirm
If Glide supports Airtable single select or multi select fields
If yes, please explain like I am 5 on how to set this up in Glide
I have read the above but no idea what joined link columns are and the date was 6 months ago so may have changed.
In the Glide Data, the data is there for the test record but I cant see a way to get this added to the app? It only lets me work with the single text fields
I don’t have a solution for this, especially with multi-select, but I suspect this is the issue. Glide sees an array and normally you can’t write to an array. Things get really weird when you try to make Glide work with columns that are highly specific to Airtable and not any of the other types of databases.
I don’t know if I would consider it a bug. The multiple select Airtable column is an array column and Glide does not write to arrays. That’s always been the case with Glide. Your trying to mix Airtable specific column types with Glide, and it’s not always going to work.
Like I said, I don’t have a solution, and I don’t think it’s a bug. If anything, it would be a feature request because it’s working as expected.
If it were me, I would let a multi-select choice component write to a basic text column type in the comma delimited format that it always has written as. Then split that delimited list into an array with a split text column. That’s how Glide works. I wouldn’t use some of those column types that are unique to Airtable. Anytime I use an external data source such as google sheets, I try to use it purely as a database. If possible, I try not to do to anything fancy in the google sheet, because I’m just storing data there. I know that’s not always the case with Airtable, especially if users also interact directly with the Airtable, so that makes it more difficult to have a user friendly interface in Airtable as well as Glide.
Ultimately, I personally wouldn’t even use an Airtable multiple select column. I would replace it with a normal text column. Then Glide would be able to see and write to it normally.
