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
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.
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.
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
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!
