# Filtering external database with query parameter? **URL:** \ **Category:** External Collections, Custom Actions & Collections\ **Created:** [July 15, 2022, 9:16pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545 "2022-07-15T21:16:39Z")\ **Posts on this page:** 11\ **Page:** 1
**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, 9:16pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/1 "2022-07-15T21:16:39Z")
I’m using sheetdb as an external database. I am at a quitting point trying to understand how to get my “horizontal list” to filter my “card list”. The query parameters don’t make any sense to me and I am open to any and all help. A tutorial would help the best, video or screenshot. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 16, 2022, 8:36am UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/2 "2022-07-16T08:36:12Z")
Hi @kylehillian, Check this out : [Filtering API Lists - #4 by dilon\_perera](https://forum.adalo.com/t/filtering-api-lists/25471/4) If it still doesn’t works is it possible share a video about your setup and preview? ( You can use [Loom](https://www.loom.com/) ) Thank you ---
**Author:** ![kylehillian](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kylehillian](https://forum.adalo.com/u/kylehillian)\ **Post date:** [July 19, 2022, 3:12pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/3 "2022-07-19T15:12:55Z")
Thank you so much @Dilon. That did help me solve part of my problem. Now I’m facing some confusion making my different list connect. ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/d/b/db63cf3634b04cebbbfe54ad3e609cf81dee7dde.jpeg) ![Screen Shot 2022-07-19 at 5.12.05 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/b/bb5cc71ff8e4c9da5fad3d132ff0983a2210f5ef.png) ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 20, 2022, 6:14am UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/4 "2022-07-20T06:14:03Z")
The both lists connected to the same collection? Can you send some screenshots of that sheet? ---
**Author:** ![kylehillian](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kylehillian](https://forum.adalo.com/u/kylehillian)\ **Post date:** [July 20, 2022, 5:21pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/5 "2022-07-20T17:21:48Z")
Yes sir, both list are connected, this is what my sheet/collection currently looks like. Once again, THANK YOU for helping me with this. ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/d/1/d14e67033c20c6b5b94e1c6ada561d7de4d8cd3f.png) ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 20, 2022, 5:33pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/6 "2022-07-20T17:33:38Z")
You can add a input component on this screen and make it smaller and make it transparent so users don’t see it and name it with a good name for search it easily and then you can add a Change Input value action ( you can find it in the More section once you tried to add a action ) on the horizontal chip list ( the top list ) and then for the input in the action you can select that added input from magic text that you can find from Other components section and for the value you can add current thrift \> type of thrift store from magic text. And in your card list ( the list that is after the horizontal list ) you can add the filter and add that input for the value in the query! If you can’t figure it out you can send the URL of a copy of that spreadsheet, this sheet only with that information and I’ll make a video tomorrow and will send it here! ---
**Author:** ![kylehillian](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kylehillian](https://forum.adalo.com/u/kylehillian)\ **Post date:** [July 20, 2022, 6:08pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/7 "2022-07-20T18:08:04Z")
> **[Google Sheets: Sign-in](https://accounts.google.com/v3/signin/identifier?dsh=S990320053%3A1673463875171341&continue=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F13t3LtBPk8IO5I3fhkyaP58GzcFbOCQcg86d-fB46xyM%2Fedit&followup=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F13t3LtBPk8IO5I3fhkyaP58GzcFbOCQcg86d-fB46xyM%2Fedit<mpl=sheets&osid=1&passive=1209600&service=wise&flowName=WebLiteSignIn&flowEntry=ServiceLogin&ifkv=AeAAQh4lFmPhoyP15aKUBY0AebPd3z4XsgLRcFmZq9_4XpI57xkzcEbwpxxyzgZYtehr93sk3kK0)** > > Access Google Sheets with a personal Google account or Google Workspace account (for business use). Here as a link to my google doc, the sheets video you linked had great information, but I was am still missing something I just dont know what in oder to follow the steps to completion. I know I’m getting closer I just dont know what I am missing. Thank you again. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 21, 2022, 9:33am UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/8 "2022-07-21T09:33:33Z")
Thanks for sharing the Spreadsheet! Check this video : [Filter Sheets - Type of Thrifts.mp4 - Google Drive](https://drive.google.com/file/d/1DuuWBulT4YOUxIteaLAsJSCRJURfVEqg/view?usp=sharing) ---
**Author:** ![kylehillian](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@kylehillian](https://forum.adalo.com/u/kylehillian)\ **Post date:** [July 23, 2022, 2:51pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/9 "2022-07-23T14:51:47Z")
Man THANK YOU SO MUCH. I would not have been able to do this without you. 🙏 ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 23, 2022, 4:02pm UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/10 "2022-07-23T16:02:58Z")
Awesome Dude! Good Luck! ---
**Author:** ![MARKtools](https://avatars.discourse-cdn.com/v4/letter/m/7ba0ec/32.png) [@MARKtools](https://forum.adalo.com/u/MARKtools)\ **Post date:** [June 7, 2023, 4:49am UTC](https://forum.adalo.com/t/filtering-external-database-with-query-parameter/29545/11 "2023-06-07T04:49:31Z")
@Dilon Hi! Thanks for all this! Just wondering if you know what characters the guy in that helpful video had after the column title and ?? Thanks!!