# AirTable database to Glide not transferring all info **URL:** \ **Category:** Ask for Help\ **Created:** [June 19, 2022, 11:13pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259 "2022-06-19T23:13:55Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [June 19, 2022, 11:13pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/1 "2022-06-19T23:13:55Z")
Hi All, I’m trying to create an app from an AirTable database and all of the information isn’t transferring… actually, some of the most important information because it needs to be filterable. Any advice here? I signed up for the Starter plan for this purpose. Thanks so much! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 19, 2022, 11:45pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/2 "2022-06-19T23:45:04Z")
Can you specify what types of columns are not transferring over? ---
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [June 19, 2022, 11:57pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/3 "2022-06-19T23:57:22Z")
Sure! In AirTable, they’re considered “Multiple Choice” because the main thing about my database is that it’s filterable. So it’s about TV shows and films. I want people to be able to filter “Hulu”, “Netflix”, etc., so one of the columns is called, “Where To Watch”… none of that information is transferring over. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 20, 2022, 12:57am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/4 "2022-06-20T00:57:55Z")
@Robert_Petitto might need your insight here. It looks like an “array column” is not transferring here. Do you have any ideas? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [June 20, 2022, 3:35am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/5 "2022-06-20T03:35:06Z")
Ya…multiple choice fields in AT should come in as array columns in Glide. ![CleanShot 2022-06-19 at 23.32.49@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7fd8adcc9dd0473246138c334df72fdf98336996.jpeg) Is that not what’s happening? ---
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [June 20, 2022, 3:09pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/6 "2022-06-20T15:09:49Z")
![Screen Shot 2022-06-20 at 11.07.08 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43e35e29e2c56212fc10d645a2d212459f09a3c7.jpeg) Unless I’m missing something- no? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 20, 2022, 3:40pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/7 "2022-06-20T15:40:59Z")
Do you see the data in the data editor? Are you trying to place an array of multiple values into a component that only accepts a single value? What exactly are you trying to do with that array of values? ---
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [June 20, 2022, 4:39pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/8 "2022-06-20T16:39:39Z")
![Screen Shot 2022-06-20 at 12.37.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87b13eb9a0ba876c59f4f0c15c0fe51744aa4063.jpeg) Yes, that information does appear in the data editor (I believe)… it just doesn’t transfer to the app. I want to show those items so that people can filter them. I tried to drag and drop it into the app, but it didn’t work. I want people to be able to filter by Netflix or Series and come up with only certain shows/films. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 20, 2022, 5:46pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/9 "2022-06-20T17:46:59Z")
Since it’s an array, you’ll need to convert it to a single value. You should be able to do that by creating a Joined List column and point it directly at that array column. That will give you a single delimited list of services that you can then use for filtering. The problem is that you are trying to place an array of multiple values into a component that can only hold a single value, so you first need to convert it to a single value using the Joined List column in the data editor. How exactly are you trying to filter your list of shows? That may determine if more (or something different) needs to be done to get the filter to work. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 21, 2022, 12:24am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/10 "2022-06-21T00:24:19Z")
If it works like a normal array column then she can just point the in-app filter (assuming she’s using this) to that array column. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 21, 2022, 12:35am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/11 "2022-06-21T00:35:03Z")
Didn’t know that worked with the in-app filter. Good to know. ---
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [June 22, 2022, 1:02am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/12 "2022-06-22T01:02:51Z")
Maybe I’m not understanding correctly, but I don’t want only one option in the app. I want there to be multiple choices. Would the “Joined List” column have to be in AirTable? That information is in a column in AirTable called, “Where To Watch.” ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 22, 2022, 1:56am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/13 "2022-06-22T01:56:03Z")
Maybe it would help to explain how you intend to use the values for filtering. I understand the purpose of which service a show is streaming on, but how do you intend to use the data? You mentioned that you want to use it for filtering, but you also appear to be trying to get it to display on the detail screen? How is it supposed to look? I could probably feed you a bunch of different answers for different situations, but it would help to have a better understanding of what you want to achieve and how you want it to work. ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [June 22, 2022, 2:52am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/14 "2022-06-22T02:52:57Z")
#underratedcommentoftheweek ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [June 22, 2022, 2:56am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/15 "2022-06-22T02:56:47Z")
If you haven’t already, you may want to first verify your data via the data editor. If you haven’t been there yet, it’s the first option at the top of the screen. Check for the columns on the appropriate table to see if you have the correct data. ![Screen Shot 2022-06-21 at 9.54.49 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b09a616a0bdbbb608ce431c55a64ff35da7a0111.png) ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [June 22, 2022, 3:00am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/16 "2022-06-22T03:00:20Z")
Oh dang, it looks like you’ve already done this! I see your screenshot now. It appears that I’m developing a bad habit of replying first and then reading everything… Given your screen shot, would the user select and report/confirm/edit the streaming service on the show’s page, or is there another higher level page that the user would use a filter to select a service and then see all of the appropriate shows? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 22, 2022, 3:05am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/17 "2022-06-22T03:05:27Z")
> [@NFNHello](#): > > Oh dang, it looks like you’ve already done this! I see your screenshot now. It appears that I’m developing a bad habit of replying first and then reading everything… Join the club 🤣 ---
**Author:** ![CarlyFrankel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carlyfrankel/32/44020_2.png) [@CarlyFrankel](https://community.glideapps.com/u/CarlyFrankel)\ **Post date:** [July 3, 2022, 11:44pm UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/18 "2022-07-03T23:44:24Z")
SO sorry for delay here! My full-time job has kept me pretty busy and this is my side project I’m looking to MAKE a job. So, the whole idea is that it’s a filterable database for womxn-led media. SO, the filtering is important. The user would go to the main page, filter say, “HULU” under the “Where To Watch” column, filter, “SERIES” under “Type”, and the ONLY projects that should come up for them are items under those filters. Does that make sense? I guess short answer is the second option 😄 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 4, 2022, 1:00am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/19 "2022-07-04T01:00:27Z")
So you would want “Where To Watch” to be a filter and “Type” to be another filter? These 2 filters should co-exist? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 4, 2022, 3:45am UTC](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259/20 "2022-07-04T03:45:43Z")
This might be a worthwhile video to watch. > [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932): > > [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 > > > **Version 1** > > > > \https://www.youtube.com/watch?v=rtbFccDKuH0\ [Next page](https://community.glideapps.com/t/airtable-database-to-glide-not-transferring-all-info/43259.md?page=2)