# Multiple Clickable Dropdown list

**URL:** <https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030>\
**Category:** Ask the Community\
**Created:** [July 5, 2022, 12:18pm UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030 "2022-07-05T12:18:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adan\_Alnoor](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Adan\_Alnoor](https://connect.superhuman.com/u/Adan_Alnoor)\
**Post date:** [July 5, 2022, 12:18pm UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/1 "2022-07-05T12:18:27Z")

</div>

![image](https://global.discourse-cdn.com/coda1/original/3X/b/4/b449a1e2b294a351b43530a7b0dfb49624e1d134.jpeg)

 ![image](https://global.discourse-cdn.com/coda1/original/3X/5/5/55620a9397a2dd2e7cd5c843a0067fce00b0bcad.jpeg)

Hi.

I am trying to create a database table which can be used to display data from four levels. The following is what i want do do

1. Choose Level 1 option ‘’ CONCRETE WORKS ‘’

2. This will Show only Level 2 items linked to Level 1 item

3. Choose one of Level 2 item and it will show all level 3 items under it

4. Choose one of Level 3 item and it should be able to show all level 4 items under it.

5. Choose one of the level 4 item under it.

6. In a separate table we should be able to see the all items chosen from level 1 to 4.

---

<div class="post-metadata">

**Author:** ![Federico.Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico.stefanato/32/21115_2.png) [@Federico.Stefanato](https://connect.superhuman.com/u/Federico.Stefanato)\
**Post date:** [July 6, 2022, 10:48am UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/2 "2022-07-06T10:48:16Z")

</div>

Hi @Adan_Alnoor ,  
please find here an example of how the data could be organized and all lookup levels accordingly.  
Have a look at item settings in the lookup columns.

Just be aware that - according to your practical use-case - it might need to provide some UI guidance (see the conditional formatting for inconsistencies) for there is no automatic “trigger” to reset previous values.

https://coda.io/embed/pX88qYRLjo/_sut7W?viewMode=embedplay

I hope this helps.  
Cheers!

---

<div class="post-metadata">

**Author:** ![Adan\_Alnoor](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Adan\_Alnoor](https://connect.superhuman.com/u/Adan_Alnoor)\
**Post date:** [July 6, 2022, 11:25am UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/3 "2022-07-06T11:25:53Z")

</div>

Thanks

Please can you allow me full control of the solution, i can only view it

---

<div class="post-metadata">

**Author:** ![Federico.Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico.stefanato/32/21115_2.png) [@Federico.Stefanato](https://connect.superhuman.com/u/Federico.Stefanato)\
**Post date:** [July 6, 2022, 1:29pm UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/4 "2022-07-06T13:29:29Z")

</div>

@Adan_Alnoor ,  
if you click on the three dots at top left (see screenshot below) you can copy the whole document and change it as you like.

 ![image](https://global.discourse-cdn.com/coda1/original/3X/b/9/b9643d907e1d32bd2b74680378fad4d1125d8261.png)

---

<div class="post-metadata">

**Author:** ![Adan\_Alnoor](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Adan\_Alnoor](https://connect.superhuman.com/u/Adan_Alnoor)\
**Post date:** [July 8, 2022, 12:23pm UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/5 "2022-07-08T12:23:58Z")

</div>

> [@Federico.Stefanato](#):
>
> Just be aware that - according to your practical use-case - it might need to provide some UI guidance (see the conditional formatting for inconsistencies) for there is no automatic “trigger” to reset previous values.

Thanks.

i was able to replicate the formulas and filters. kindly help on how to reset the values if you choose something else in level 1

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [October 6, 2022, 12:24pm UTC](https://connect.superhuman.com/t/multiple-clickable-dropdown-list/32030/6 "2022-10-06T12:24:13Z")

</div>

Closed on October 6, 2022, 12:24pm UTC

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