# A choice column in the DATA GRID component **URL:** \ **Category:** Ask for Help\ **Created:** [September 23, 2025, 11:17pm UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565 "2025-09-23T23:17:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [September 23, 2025, 11:17pm UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/1 "2025-09-23T23:17:45Z")
Hello Gliders! I am building an app for a restaurant which has 10 locations and each location has three areas where employees work: Kitchen, Lounge and Office. The manager of each location will assign employees and work hours in each area using a Data Grid component. All locations are using the same glide table called Scheduling. In the layout, the manager selects his location and then sees the scheduling in 2 data grids: Kitchen and Lounge. **The first column of each data grid is the name of the employee and it is a choice component so that the manager can choose among employees only of that location and area. But the problem is that there is NO FILTERING** **option** in the data grid columns (please see image attached). How can I solve this issue? ![a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/881698cfcb3928fc4be3c5c97b5c15396feae15d.jpeg) ---
**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:** [September 24, 2025, 12:44am UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/2 "2025-09-24T00:44:02Z")
Create a Query column, use the selected location as a filter, and use that as the source of the choice column. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [September 24, 2025, 3:12am UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/3 "2025-09-24T03:12:26Z")
Hello Darren thanks for your comment. But tried that already… the source cannot be a query column, it does not show as an option in the configuration window. ---
**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:** [September 24, 2025, 4:00am UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/4 "2025-09-24T04:00:37Z")
It does for me… ![CleanShot 2025-09-24 at 11.58.41@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e839463d3ad52793f0b57fad8bc0480f6c6fb0e.png) BUT… in my testing the Choice option doesn’t work at all in the Data Grid, in the sense that it can be configured but nothing can be selected. So something is not right. I’m going to do some more testing. ---
**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:** [September 24, 2025, 7:39am UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/5 "2025-09-24T07:39:19Z")
@mbraunperu - after doing some more testing with this, I have identified a bug (which has been reported). You _can_ select a Query column as the source for a choice column in a Data Grid - as long as it is a multiple match Query. BUT… there is a bug in the Data Grid that doesn’t allow you to select any items. So until that bug is fixed, I think you are a bit stuck. One possible workaround would be to use a helper table to construct a list of options based on the selected location, and then use that as the source. That’s a bit fiddly, but I expect it would work. Update: I tested the above workaround, and it does work. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [September 24, 2025, 4:50pm UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/6 "2025-09-24T16:50:18Z")
Thanks a lot Darren! Based on your experience, how long do reported bugs take to get fixed, approximately? ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [March 26, 2026, 1:06pm UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/7 "2026-03-26T13:06:15Z")
Think I have just come up against this bug… Any news on when it will be fixed? ---
**Author:** ![Makedonix](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makedonix/32/79832_2.png) [@Makedonix](https://community.glideapps.com/u/Makedonix)\ **Post date:** [March 27, 2026, 11:18am UTC](https://community.glideapps.com/t/a-choice-column-in-the-data-grid-component/84565/8 "2026-03-27T11:18:32Z")
Had the same problem, still not fixed