# Filter Google sheet Data and show the result in a DVL
**URL:** https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841
**Category:** Tutorials and DIY Guides
**Tags:** google, community, data-source, data-viewer, tips
**Created:** [November 26, 2021, 3:44pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841 "2021-11-26T15:44:01Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 3:44pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/1 "2021-11-26T15:44:01Z")
Just wanted to share this trick to filter data in a DVL
For Example, if I have a sheet with numbers and names then I need to add another column to be the condition to filter by
In this example I have a number column and a name column and the 3rd is the search column.
In a separate sheet have the same two column headings
In the row immediately below the heading of the first column, enter this function
**=filter(Sheet1!A2:B7,Sheet1!A2:A7=Sheet1!C2)**
Now in Thunkable, add a DVL and bind it to the second sheet. Have a button to update the search column in the first sheet. When the value of this cell is updated the second sheet will reflect the filtered data.
You will need to **refresh** the DVL to get the filtered results
Hope you find it useful.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 3:47pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/2 "2021-11-26T15:47:44Z")
This is equivalent a vLookup, right? In this use case, anyhow?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 3:49pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/3 "2021-11-26T15:49:30Z")
> [@jared](#):
>
> This is equivalent a vLookup, right
You could say a **code-less vLookup** ðŸ¤
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 3:52pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/4 "2021-11-26T15:52:50Z")
Nice use case and example here! How well does this work if 100 people want to complete different filtered lists at the same time.
ie Is this a scalable solution?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 3:59pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/5 "2021-11-26T15:59:59Z")
If you are asking about multi-user operation, Then you will not be able to establish such a trick because Thunkable, in one way, does not allow dynamic change of `Data Source` to be able to give each user a session. In the other hand, Google sheet is a collaborative app which means it is built in a way that when you change a cell others in viewing the same sheet get a reflection of the change.
I created a `Google Apps Script` to give me a snapshot of the sheet as a JSON set to go around it. But that was a pure HTML/JavaScript/AppsScript project. I did not try it with Thunkable.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 26, 2021, 4:06pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/6 "2021-11-26T16:06:17Z")
Makes sense! And good points there!
A scaleable solution requires the use of filtering on the backend or in the client itself.
I find FB perfect for this but not easy for all to use. I’d love to set up some examples sometime soon.
Airtable has good filtering via the api also as does xano or backendless.
I’d love to see a filter by block for the firebase calls one day.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [November 26, 2021, 4:14pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/7 "2021-11-26T16:14:04Z")
> [@jared](#):
>
> Airtable has good filtering via the api
I made a similar trick for Airtable to perform filtering in the table side.
See this Airtable view that shows students in specific grade
The selected grade is stored in a separate table
If I change it to another number, let’s say 5
The view of the students table becomes:
Hope that help members in the community.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:13pm UTC](https://community.thunkable.com/t/filter-google-sheet-data-and-show-the-result-in-a-dvl/1635841/8 "2024-11-08T13:13:30Z")