# Dependant dropdown lists

**URL:** <https://community.glideapps.com/t/dependant-dropdown-lists/67486>\
**Category:** Ask for Help\
**Created:** [November 2, 2023, 6:51pm UTC](https://community.glideapps.com/t/dependant-dropdown-lists/67486 "2023-11-02T18:51:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![satyabansahoo2000](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/satyabansahoo2000/32/65983_2.png) [@satyabansahoo2000](https://community.glideapps.com/u/satyabansahoo2000)\
**Post date:** [November 2, 2023, 6:51pm UTC](https://community.glideapps.com/t/dependant-dropdown-lists/67486/1 "2023-11-02T18:51:11Z")

</div>

How to make a choice component dependent on another choice component? I have 2 sheets in the workbook, Employees Sheet contains ‘Department’ and ‘Name’, Report Sheet contains ‘Date’, ‘Department’, ‘Name’, ‘OT Hours’. I want to create 2 choices components here, 1st one to get unique options from ‘Department’ and 2nd is based on that Department give me the list of Employees under that particular department.

---

<div class="post-metadata">

**Author:** ![Christopher\_Geyer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_geyer/32/85766_2.png) [@Christopher\_Geyer](https://community.glideapps.com/u/Christopher_Geyer)\
**Post date:** [November 2, 2023, 8:02pm UTC](https://community.glideapps.com/t/dependant-dropdown-lists/67486/2 "2023-11-02T20:02:29Z")

</div>

Hey,

In the second drop-down field via “Options” you simply place a filter on the values ​​to be selected in the second drop-down field: in this case the department would be your filter and the value displayed would be the employees in these departments.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 9, 2023, 8:03pm UTC](https://community.glideapps.com/t/dependant-dropdown-lists/67486/3 "2023-11-09T20:03:06Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
