# Lists and Filtering external database - SheetDB

**URL:** <https://forum.adalo.com/t/lists-and-filtering-external-database-sheetdb/21553>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [January 3, 2022, 9:05am UTC](https://forum.adalo.com/t/lists-and-filtering-external-database-sheetdb/21553 "2022-01-03T09:05:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jvmartincobos](https://avatars.discourse-cdn.com/v4/letter/j/e0b2c6/32.png) [@jvmartincobos](https://forum.adalo.com/u/jvmartincobos)\
**Post date:** [January 3, 2022, 9:05am UTC](https://forum.adalo.com/t/lists-and-filtering-external-database-sheetdb/21553/1 "2022-01-03T09:05:01Z")

</div>

Hi guys!

How are you? Hope all of you find well.  
First of all, sorry for my english (I´m a Spanish speaker).

I´m creating a concerts and festivals app with an external datase and I have some difficults with Select Menu and filtering list. I´m using SheetDB to connect the Google Sheets database with Adalo.

The Select Menu problem: each event have a gender and city so The Select Menu shows every gender and city (duplicates). I wanna show every gender and city once. Same problem for gender and city lists:

I was thinking in a possible solution: connect another Google Sheets database which exclude duplicates with a formula but I don´t know if the results will be linked:  
 ![Captura de pantalla 2022-01-03 a las 9.47.39](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1bd1360d8d1dee06d1af8178b6152a9d10be7ada.png)

The filtering problem: don´t show the results of the select menu. I was trying with Adalo Filters but don´t work (the screens and data are linked). In this video I show the setup and I try with three genders. The three options shows the same results:

Any ideas?

Thanks in advance!  
Best,

---

<div class="post-metadata">

**Author:** ![kylehillian](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kylehillian](https://forum.adalo.com/u/kylehillian)\
**Post date:** [July 15, 2022, 8:47pm UTC](https://forum.adalo.com/t/lists-and-filtering-external-database-sheetdb/21553/2 "2022-07-15T20:47:03Z")

</div>

Can you possibly send what your external database looks like. I’m confused on how to input in the query para what I need to filter. I am not a coder and I’m just trying to learn.  
Thank you.