# How to change the options for pickers based on other columns data

**URL:** <https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622>\
**Category:** Ask for Help\
**Created:** [October 4, 2021, 6:47am UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622 "2021-10-04T06:47:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![YOUNGMIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/youngmin/32/31663_2.png) [@YOUNGMIN](https://community.glideapps.com/u/YOUNGMIN)\
**Post date:** [October 4, 2021, 6:47am UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622/1 "2021-10-04T06:47:00Z")

</div>

Hi,

I have two columns, class and teacher.  
Class A and Class B have different teachers assigned to each.  
I have also two pickers to select class and teacher.  
If I choose Class A in the first picker, I want my second picker to show options of teachers only assigned to Class A not whole teacher list.  
How can I have this function?

---

<div class="post-metadata">

**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:** [October 4, 2021, 6:58am UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622/2 "2021-10-04T06:58:56Z")

</div>

You should be able to filter in this case using Screen Values

> **[Screen Values](https://docs.glideapps.com/all/reference/values/screen-values)**

---

<div class="post-metadata">

**Author:** ![YOUNGMIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/youngmin/32/31663_2.png) [@YOUNGMIN](https://community.glideapps.com/u/YOUNGMIN)\
**Post date:** [October 9, 2021, 10:14am UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622/3 "2021-10-09T10:14:26Z")

</div>

Is there any way to use a screen value in screen? or can we have another way to filter in in a screen mode?

---

<div class="post-metadata">

**Author:** ![YOUNGMIN](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/youngmin/32/31663_2.png) [@YOUNGMIN](https://community.glideapps.com/u/YOUNGMIN)\
**Post date:** [October 9, 2021, 10:40am UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622/4 "2021-10-09T10:40:55Z")

</div>

I got it by myself.  
I made two tables for 1st choice option and 2nd choice option and relate them.  
Thanks, anyway!!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-to-change-the-options-for-pickers-based-on-other-columns-data/32622/5 "2024-01-17T16:50:05Z")

</div>