# Select the user from a choice list to use as a filter of a list **URL:** \ **Category:** Ask for Help\ **Created:** [June 19, 2024, 10:10pm UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247 "2024-06-19T22:10:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [June 19, 2024, 10:10pm UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/1 "2024-06-19T22:10:30Z")
apologies for the unclear subject line. the workflow I need to finish is thus: 1. assign instructions to specific students (working) 2. Create lessons for specific students (working) 3. Now I need a form that lets me: a. select a user b. view the current list of assigned instructions for that user (I currently only have this working when I am using the user profile name and using “viewing as ” c. select which of those assigned instructions I’d like to add to the current lesson (multi-choice radio buttons) This seems simple but I don’t see a way to use the current name from the student choice selection to filter the list of assigned instructions. I realize their is a nested link between only show me assigned instructions when i select the name. I could simplify this but just showing all instructions but wanted to know how to filter the list. thanks ---
**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 19, 2024, 11:52pm UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/2 "2024-06-19T23:52:15Z")
When you select a name, it should be writing the chosen name to a user specific columns in one of your tables. You should be able to use that column value to create a relation, which can be the source of your collection. Or you can simply filter the collection by the choice component value (screen value). ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [June 20, 2024, 12:18am UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/3 "2024-06-20T00:18:29Z")
Thanks Jeff. Is there a video/document that shows how to filter by the choice component value? I would imagine the best source of names would be my user table. I’ve created a column in my instructions table called filterName. When I pick a name, Glide writes the selected name to the first row of my instructions table. Is that the required data for a collection filter to dynamically update the list based on selecting different users? ---
**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, 2024, 5:02am UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/4 "2024-06-20T05:02:54Z")
No videos that I can think of off the top of my head. The setup should be pretty straightforward. A detail screen can only be attached to one row. When you select an item from the choice component, it’s written to a column in the row of the table that the screen is attached to. From there you either create a relation using that selected choice and set the source of your collection to that relation or you set the source of the collection to the entire table and then set a filter on the collection based on the ‘Screen’ value of the column the choice component is writing to. Personally I prefer the relation method. A choice component can be sourced from any table. The column that the selected choice is written to is based on the table and row that the screen is attached to. ---
**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\ **Post date:** [June 20, 2024, 9:27pm UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/5 "2024-06-20T21:27:12Z")
thanks Jeff. will unpack this. I have it working with hardcoded values its the inability to access the related colum fields in the filter is where i get stuck. Will go over the info provided. ---
**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, 2024, 9:36pm UTC](https://community.glideapps.com/t/select-the-user-from-a-choice-list-to-use-as-a-filter-of-a-list/74247/6 "2024-06-20T21:36:41Z")
If you provide screenshots of what you have, we can better help.