# I wish to create a Search bar which will return very specific values from a GSheet **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [December 5, 2021, 5:51pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137 "2021-12-05T17:51:59Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 23, 2021, 5:34pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/21 "2021-12-23T17:34:29Z")
Hi @muneer, I have now again start from scratch and have recreated the blocks as per one of your earlier instructions by copying the blocks and applying my relevant info/ data. **My app link:** [https://x.thunkable.com/projects/61a4d8facd6a4c0011c5f134/6f222a98-901d-4a11-847e-419f7b11038a/designer](https://x.thunkable.com/projects/61a4d8facd6a4c0011c5f134/6f222a98-901d-4a11-847e-419f7b11038a/designer) The app I copied from was called “Search DVL DnD UI copy”. See link below: **Your blocks** [https://x.thunkable.com/projects/61a9204825ab2900e37974db/4274ad8c-2327-4343-bd8b-1004df961ca9/blocks](https://x.thunkable.com/projects/61a9204825ab2900e37974db/4274ad8c-2327-4343-bd8b-1004df961ca9/blocks) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fd88a31bc226499dc9bc3693d9bb9fefc8fb3962.png) **My blocks** now look like this: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a3f45237bf16f50c4a0beb5d792b6101c0d502c8.png) The “Get row object from” block has a dovetail connector so I don’t know where to put it. Also, after my app has completed a search, it returns a “Matched: 0” message even though the data record is present in the spreadsheet. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/3/f32279c14cbd8ca8829406027efb578a5bfe0eb5.png) My REG column has been bound to the DVL (DVL2). As you can see below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/4/b4a4e5b0c464b9aeae124d29e43a0aae8dd77663.png) My “FVRegList” Sheet is the equivalent of your View List Sheet in your example. Again, see below: **My Sheet** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/6/06b733b99ad254acd910b01e879c1dd883292670.png) **Your Sheet** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d9f32c2703b3caf27504c61c52af628a7e557813.png) My Google Sheet (MAN First Visits) is the equivalent of your “Master Table” see examples: **My Google Sheet** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/158148fd9de59a45b2c3eb38af37a06eea1fbf47.png) **Your Master Table** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/8/e84fc2a9ae34eb4173d391c1670a79961ebe016a.png) Could you please compare the sheets and tell me what exactly is wrong between the two and if possible could you offer a solution? In your last message you wrote: " I didn’t get what you want. If you want to search then you can search in one of the columns that you bind to the DVL and then when you get what you search for then use the `row ID` in the DVL and use it for get the full row of the Google sheet using the `Get row` block from the `Data Source` drawer. Have you tried this?" I cannot see how, or where, to attach the “Get row object from (DVL) in (Sheet\*) block” [quote=“muneer, post:19, topic:1647137”] `Get row` block from the `Data Source` [/quote] into my blocks. or how to " > [@muneer](#): > > use the `row ID` in the DVL and use it for get the full row of the Google sheet I really appreciate you trying to help but I cannot see where I am going wrong? Sorry about the length of this message. Andos. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 23, 2021, 6:34pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/22 "2021-12-23T18:34:27Z")
Will look at it tomorrow my time and see what I can do to demonstrate to you how to make it work. However, I will need sample data from your side to work with. You can provide the data as a Google sheet or a CSV file if you want. **I will not be able to check your project without a copy of the Google sheet that you use for the search.** ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 25, 2021, 1:34am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/23 "2021-12-25T01:34:05Z")
Hi @muneer, below I have sent you a link with an exact copy of my “ **FV** ” tab data (-called “ **FV-sample** ”) from my **Google Sheet called “MAN First Visits”** so you have data to work with. **Please note** that rows 1 & 2 are not to be included in the “Where the data starts” section in the Data Source setup. **The data starts on Row 3**. Please do not delete any of the rows as there is an “arrayformula” attached and this would cause your source data to error. > **[MAN First Visits](https://docs.google.com/spreadsheets/d/1fsyPJ5vfrzw1EdoxDMZ0fB_S_YB0rUrjpEvNahjPZ8Y/edit?usp=sharing)** > > FVENTRYFORM > > Timestamp,REG,C/N,TYPE,DATE,CALLSIGN,FRAME/REG,REMARKS > StringFilter,NoFilter,CategoryFilter,DateFilter,StringFilter,NoFilter,NoFilter > 08Feb2018,OE-LQM,3824,A319,08Feb2017,EZY 81LY,REG > 08Feb2018,OK-PET,4258,A319,08Feb2018,EWG... Many thanks. Andos ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 25, 2021, 10:59am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/24 "2021-12-25T10:59:47Z")
As for starting for the **3rd** row, you can see the setup in this image ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/4/a4280dd2a9784254436a3bbecac4f92b3e622255.png) As you can see in the `Data Source` connection, I chose to start from row **3** instead of the default **2**. I have created a minimal project from your original project to show only the search and also added a sample `Label` to show the data in the selected row. [https://x.thunkable.com/projectPage/61c4c2897b7b9d0010f6bc23](https://x.thunkable.com/projectPage/61c4c2897b7b9d0010f6bc23) ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 4:36pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/25 "2021-12-27T16:36:50Z")
Hi @muneer, many thanks for the suggested solution. You’ve made it seem so simple. Though there are a couple of things I don’t understand the logic behind… The first one is what does the “j” mean from the variable section? Why do you use “Title Wrappers” and " Layout Wrappers" ? Also, I have copied your copy into my main Project MANFVScreen but all I get is the loading icon. It was showing for over 30 mins before I stopped the action. I never saw a list from my spreadsheet appear. (-just the loading icon). Is this because there are nearly 2,000 records in my Google Sheet? If so, is there a way to speed up this search? If it is not the number of records, could you please tell me this can be resolved.? The user will not wait over 30 minutes for the screen to load so I wonder if I have misunderstood something? With my “very limited” knowledge I cannot see anything I’ve done differently to your latest suggestion. Please view my version at the link below: [https://x.thunkable.com/copy/09170ffc7dde62ec14808bffaca3aea9](https://x.thunkable.com/copy/09170ffc7dde62ec14808bffaca3aea9) Andos. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 27, 2021, 4:59pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/26 "2021-12-27T16:59:18Z")
First things first, If the solution I provided worked as expected then the first action from your side is to remove the sample `Data Source` and use your original `Data Source` with 2000+ records in my project and see that it works. I don’t have access to your full list table and therefore will not be able to judge the performance of the app. Second, I see from your project that you have the following `Data Sources` in the app ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/9/f9f69caf31276f52e64481636f9aeb6dee895165.png) But your code in the search screen refers to a `Data Source` that is not listed. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/aee2d39fd435606e74d33478b0051faa11f9c141.png) The `Loading Icon` is by default hidden. You have not hide it. That is why it is showing. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 8:48pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/27 "2021-12-27T20:48:20Z")
HI @mumeer, my replies are in **bold type** … > [@muneer](#): > > If the solution I provided worked as expected then the first action from your side is to remove the sample `Data Source` and use your original `Data Source` with 2000+ records in my project and see that it works. > > **Your solution did work but was not showing any data. As you have suggested, I have replaced your sample data with my original Data Source of 2000 records and my data appeared which means that I have done something wrong. But, I have noticed when I search for a row that is between Row 150 and Row 220, it takes about seven seconds for that row to be displayed. Any row after about Row 280 doesn[t seem to display. I have looked at the Data Source preview link ( Click to view the data") and it only shows the first 100 rows (obviously as a sample preview).** > > I don’t have access to your full list table and therefore will not be able to judge the performance of the app. > > Second, > I see from your project that you have the following `Data Sources` in the app > > ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/9/f9f69caf31276f52e64481636f9aeb6dee895165.png) > > But your code in the search screen refers to a `Data Source` that is not listed. > ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/aee2d39fd435606e74d33478b0051faa11f9c141.png) > > **The reason for this muneer, is that I had manually rewritten your blocks and design into my original MANFVScreen where the Source Data Google Sheet (MAN First Visits) exists.** > > **I have now linked the original data to your solution Screen Data. Please link below:** > > **[Thunkable](https://x.thunkable.com/copy/1fb6373979c40a9037cb83a26dddbfc1)** > > The `Loading Icon` is by default hidden. You have not hide it. That is why it is showing. **I have now hidden the “Loading Icon”.** **I have now completely adhered to your advice but as I previously mentioned, It takes a really long time for the search to complete if the record search is beyond Row 100. (It takes about 7 seconds to complete a search beyond Row 150 to Row 220. Does Thunkable only load about 100-150 rows at a time, or is it because of the amount data in the Source Google Sheets?** **Thanks muneer** **Andos.** ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 27, 2021, 9:02pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/28 "2021-12-27T21:02:38Z")
> [@muneer](#): > > I have now linked the original data to your solution Screen Data. Please link below: Thunkable will remove the connection to your `Data Source` and therefore I cannot access your data unless you shared the actual Google sheet. See what I get ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/a/9a9808eabbdda7251acb3ba530e180c6302d42f4.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/4/f41dbef88b629995e44836561dde148bba35b2b1.png) ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 9:21pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/29 "2021-12-27T21:21:29Z")
Hi @muneer, how do I link the actual original Google Sheet to you?. I don’t have an address to link to . Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 9:23pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/30 "2021-12-27T21:23:49Z")
Hi @muneer, let me know if I have linked it correctly. > **[MAN First Visits](https://docs.google.com/spreadsheets/d/1fsyPJ5vfrzw1EdoxDMZ0fB_S_YB0rUrjpEvNahjPZ8Y/edit?usp=sharing)** > > FVENTRYFORM > > Timestamp,REG,C/N,TYPE,DATE,CALLSIGN,FRAME/REG,REMARKS > StringFilter,NoFilter,CategoryFilter,DateFilter,StringFilter,NoFilter,NoFilter > 08Feb2018,OE-LQM,3824,A319,08Feb2017,EZY 81LY,REG > 08Feb2018,OK-PET,4258,A319,08Feb2018,EWG... Andos. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 27, 2021, 9:38pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/31 "2021-12-27T21:38:06Z")
Check this [https://x.thunkable.com/projectPage/61ca295782be4c01a096dab0](https://x.thunkable.com/projectPage/61ca295782be4c01a096dab0) This demo is using a `List Viewer` instead of the `Data Viewer List`. Connect your data source and check the response. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 10:37pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/32 "2021-12-27T22:37:10Z")
Hi @muneer, I know this might sound a daft question but where is the place I attach my source data to? Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 27, 2021, 10:55pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/33 "2021-12-27T22:55:39Z")
Hi muneer, I’ve figured it out and I’ve got your list version up and running the delay issue has improved greatly for the better… I am now going to try it in my **MAN First Visits** screen. Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 28, 2021, 12:36am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/34 "2021-12-28T00:36:39Z")
Hi @muneer, I have now applied your solution to my “MAN First Visits” in my app and have noticed that after the screen opens, it takes about 8 seconds for the list to appear. But I can tell that the list is still loading in the background because when I scroll down the list on my device or on the PC the scrolling ends at around the Row 70. When I wait for about 20 seconds, or so, I can scroll a further 10-15 rows. I know it’s not my devices because my mobile is brand new and one of fastest on the planet and my PC is a performance spec machine. I’ve also noticed that your version runs a lot faster than mine but I cannot understand why. I cannot find any discrepancies between mine and yours so what could it be? Could you please check my work using the link below? The only thing I’m wondering, is it because my app has lots of screens? If not, is there any other way to improve the load times because eventually there will be 10’s of 1000’s of in the Google Sheet within in a few years. Many thanks, Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 28, 2021, 1:38am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/35 "2021-12-28T01:38:23Z")
Hi @muneer, I have found my mistake. I somehow missed a block out (Doh!). All appears to be working well now though I do have a couple more questions to ask … 1. If I wanted to make the column header text Labels in Labels 1-7 invisible and only appear after a search result has been found. How would I do that? 2. If I were to duplicate the **MAN First Visits** screen onto the **MAN FV Entry** screen and amend it so that when a search has been performed and the result has been clicked on. It would allow the user to amend/update or delete that entry. Also, would it be possible to add **New Entries also**? All this would be done using my **FVENTRYFORM** tab on my **MAN Fiirst Visits Source Google Sheet**. See link here: [MAN First Visits - Google Sheets](https://docs.google.com/spreadsheets/d/1fsyPJ5vfrzw1EdoxDMZ0fB_S_YB0rUrjpEvNahjPZ8Y/edit?usp=sharing) Many thanks, Andos. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 28, 2021, 3:06pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/36 "2021-12-28T15:06:34Z")
See this video. This is the response I get from the search demo I made > **[Search MANFV (video)](https://drive.google.com/file/d/1NICxhQoo6SKw_YrwVCnCrQMuGBGZtZxr/view?usp=drivesdk)** > > Google Drive file. I admit there is a time to load all 2500+ rows but the search is working better than expected. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 28, 2021, 4:07pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/37 "2021-12-28T16:07:30Z")
Hi @muneer, that is exactly what I am now getting. 👍 You’re a genius!! I don’t suppose there is a way of resolving my last two questions related to this topic… 1. If I wanted to make the column header text Labels in Labels 1-7 invisible and only appear after a search result has been found. How would I do that? 2. If I were to duplicate the **MAN First Visits** screen onto the **MAN FV Entry** screen and amend it so that when a search has been performed and the result has been clicked on. It would allow the user to amend/update or delete that entry. Also, would it be possible to add **New Entries also**? All this would be done using my **FVENTRYFORM** tab on my **MAN Fiirst Visits Source Google Sheet**. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 28, 2021, 4:17pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/38 "2021-12-28T16:17:35Z")
> [@andos-avlog](#): > > If I wanted to make the column header text Labels in Labels 1-7 invisible and only appear after a search result has been found. How would I do that? You can treat them the same way you treated the `Loading Icon`, keep them hidden by default and only show them in the code block in `item click`. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 28, 2021, 5:09pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/39 "2021-12-28T17:09:38Z")
Hi @muneer, I shall try that…! Andos. ---
**Author:** ![andos-avlog](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/andos-avlog/32/122340_2.png) [@andos-avlog](https://community.thunkable.com/u/andos-avlog)\ **Post date:** [December 28, 2021, 5:34pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/40 "2021-12-28T17:34:47Z")
Thanks @muneer that works brilliantly! And finally, my last part of my question/ problem… > [@andos-avlog](#): > > If I were to duplicate the **MAN First Visits** screen onto the **MAN FV Entry** screen and amend it so that when a search has been performed and the result has been clicked on. It would allow the user to amend/update or delete that entry. Also, would it be possible to add **New Entries also**? All this would be done using my **FVENTRYFORM** tab on my **MAN Fiirst Visits Source Google Sheet**. Thanks, Andos. [Previous page](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137.md?page=1) [Next page](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137.md?page=3)