# Filter on ListView

**URL:** <https://community.thunkable.com/t/filter-on-listview/1320833>\
**Category:** Questions about Thunkable X\
**Created:** [June 1, 2021, 7:49pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833 "2021-06-01T19:49:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavel.rysula2kl6](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/pavel.rysula2kl6/32/106949_2.png) [@pavel.rysula2kl6](https://community.thunkable.com/u/pavel.rysula2kl6)\
**Post date:** [June 1, 2021, 7:49pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833/1 "2021-06-01T19:49:54Z")

</div>

Hey, I want to make an app that shows you some interesting places.  
My idea is that the user will click on things that he wants, like: toilets, place to sit etc.  
and these choices will filter some places from my database, I am not quite sure how to filter it though.

 ![image_2021-06-01_214941](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/5/a504071189a07746a3bc4cafb2a67a203a8219a1.png)

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [June 1, 2021, 8:02pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833/2 "2021-06-01T20:02:30Z")

</div>

How are you storing your data? It doesn’t matter a ton but it will help me answer you. The general idea is to create a new list each time from the filtering conditions and then display that in the list viewer.

---

<div class="post-metadata">

**Author:** ![pavel.rysula2kl6](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/pavel.rysula2kl6/32/106949_2.png) [@pavel.rysula2kl6](https://community.thunkable.com/u/pavel.rysula2kl6)\
**Post date:** [June 1, 2021, 9:06pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833/3 "2021-06-01T21:06:29Z")

</div>

I am storing it in Google Spredsheets.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [June 1, 2021, 9:36pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833/4 "2021-06-01T21:36:59Z")

</div>

So I think you can either filter directly in Google Sheets or you can pull the data into Thunkable (as you’re already doing) and create a new list with the filtered data within Thunkable. It’s probably easier to use Google Sheets formulas to filter the data.

[https://support.google.com/docs/answer/3093197?hl=en](https://support.google.com/docs/answer/3093197?hl=en)

Or if all you want to do is get the data from a **single** row or column based on a value (e.g. “Snacks”) that shouldn’t be too hard to do in Thunkable.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:22pm UTC](https://community.thunkable.com/t/filter-on-listview/1320833/5 "2024-11-08T13:22:07Z")

</div>