# Filter list of full names in googlesheet and view results in Data Viewer List **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [November 26, 2024, 7:24am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234 "2024-11-26T07:24:39Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![majidfareed1977](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@majidfareed1977](https://community.thunkable.com/u/majidfareed1977)\ **Post date:** [November 26, 2024, 7:24am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/1 "2024-11-26T07:24:39Z")
Hi, I have a list of full name list in google sheet (full name means: first name, father’s name and family name), in the app, there is a text input block to search about a name, where the user can enter any part of the name, i.e, either first name, father’s name of family name, then the result should appear in the data viewer list with all Full names that contains the text value of the text input block. next step is to click on the required name and retrieve all data about this name. I did it already but the display of the results takes very long time I need your supports folks to make a bit faster Note: length of current database is 550. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c2586a0261c41905f5cd51e9f822a51e9f4f65cd.png) ---
**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:** [November 27, 2024, 3:46am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/2 "2024-11-27T03:46:47Z")
I would try creating a formula in Google Sheets to filter for the name you input. Display the filtered data on a separate sheet which you sync to your Data Viewer List. ---
**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\ **Post date:** [November 27, 2024, 3:09pm UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/3 "2024-11-27T15:09:42Z")
I had the same issue with many of my apps. Recently Thunkable added a block for filtering data, but i didn’t have the chance to test it yet - maybe you can try that one out. The solution it helped me the most, was to invest a bit of more time in the Splash Page, and trasfer all the Google Sheets Data into a Local Database. During the loading time the app was downloading all the data and creating the same database but in Local. In the Local Database the response is much faster. Hope it helps ---
**Author:** ![majidfareed1977](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@majidfareed1977](https://community.thunkable.com/u/majidfareed1977)\ **Post date:** [November 27, 2024, 9:08pm UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/4 "2024-11-27T21:08:23Z")
thanks, will try this but the point jump to my mind, what if more than one user used the app at the same time, how google sheet will react !!!? ---
**Author:** ![majidfareed1977](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@majidfareed1977](https://community.thunkable.com/u/majidfareed1977)\ **Post date:** [November 27, 2024, 9:09pm UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/5 "2024-11-27T21:09:36Z")
what is the name of this block for filtering data? indeed working on local database is much faster and at the same time will save the source db from being accessed by several users at the same time ---
**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:** [November 28, 2024, 12:35am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/6 "2024-11-28T00:35:51Z")
There can be problems trying to manage user data for multiple people in a Google Sheet. For that, I use a Firebase Realtime Database with cloud variables instead. If I was going to use a Google Sheet, I would make sure that each user had a unique value in their row that I could search for each time they login or use the app. But I don’t recommend it! ---
**Author:** ![majidfareed1977](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@majidfareed1977](https://community.thunkable.com/u/majidfareed1977)\ **Post date:** [November 28, 2024, 6:54am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/7 "2024-11-28T06:54:44Z")
> [@tatiang](#): > > Firebase thanks for the tip, I didnt use Fiberbase before, will give it a try… thanks ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [February 26, 2025, 6:55am UTC](https://community.thunkable.com/t/filter-list-of-full-names-in-googlesheet-and-view-results-in-data-viewer-list/3369234/8 "2025-02-26T06:55:26Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.