# \[Solved\] How can I Create a search bar for my google sheets data? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** design, solved, beginner, help, data-viewer\ **Created:** [March 29, 2022, 8:45pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538 "2022-03-29T20:45:41Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![luke\_butcher93zk](https://avatars.discourse-cdn.com/v4/letter/l/73ab20/32.png) [@luke\_butcher93zk](https://community.thunkable.com/u/luke_butcher93zk)\ **Post date:** [March 29, 2022, 8:45pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/1 "2022-03-29T20:45:41Z")
Hey! 🙂 So I am a beginner in creating apps with this being my first one. I am making an app to help with stock take. I have been stuck for a while now on trying to create a search bar alongside google sheets. I am using a data viewer list. I am looking for the search bar to preform a search of 2 lists on 1 spreadsheet on google sheets. For example, I would type in a word ‘cladding’ or type in the 6 digit code and it would filter through the thousands of different ones and show me the ones that either had the word ‘cladding’ in if that is what I had searched for. Or the 6 digit code if I had typed that in. I hope one of you can help 🙂 Thanks, Luke 🙂 ---
**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:** [March 29, 2022, 9:28pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/2 "2022-03-29T21:28:59Z")
There have been topics on the forums about this recently. Generally speaking, you can either do the search in Google Sheets using formulas and get the result cell(s) in Thunkable or you can do all of the searching in Thunkable. You can Google _google sheets search Thunkable_ or search the forums for _google sheets search_ to get started. ---
**Author:** ![luke\_butcher93zk](https://avatars.discourse-cdn.com/v4/letter/l/73ab20/32.png) [@luke\_butcher93zk](https://community.thunkable.com/u/luke_butcher93zk)\ **Post date:** [March 30, 2022, 7:17am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/3 "2022-03-30T07:17:38Z")
Hi tatiang, I have looked through each of the topics that are already on here and none of the options have worked. Is there any way you would be able to help me step by step. I would be really grateful. Thanks, Luke 🙂 ---
**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:** [March 30, 2022, 7:23am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/4 "2022-03-30T07:23:22Z")
Hi, See this demo [Thunkable](https://x.thunkable.com/projectPage/600c2ce7f153060012143ac4) ---
**Author:** ![luke\_butcher93zk](https://avatars.discourse-cdn.com/v4/letter/l/73ab20/32.png) [@luke\_butcher93zk](https://community.thunkable.com/u/luke_butcher93zk)\ **Post date:** [March 30, 2022, 8:07am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/5 "2022-03-30T08:07:25Z")
Hi Muneer I tried this and it deleted all of the data in the google sheet, luckily I had it all backed up. ---
**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:** [March 30, 2022, 8:26am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/6 "2022-03-30T08:26:25Z")
> [@luke\_butcher93zk](#): > > it deleted all of the data in the google sheet This means you tried it before understanding the demo. First recreate something similar to the demo and when you take the grasp of the idea, implement it on your Google sheet. ---
**Author:** ![luke\_butcher93zk](https://avatars.discourse-cdn.com/v4/letter/l/73ab20/32.png) [@luke\_butcher93zk](https://community.thunkable.com/u/luke_butcher93zk)\ **Post date:** [March 30, 2022, 8:33am UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/7 "2022-03-30T08:33:31Z")
I’ve really been trying to grasp the idea of it all but I seem to have hit a brick wall. I’ve looked through all the other topics and nothing seems to work, I’m hoping someone will be able to walk me through it step by step. 🙂 ---
**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:** [March 30, 2022, 1:45pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/8 "2022-03-30T13:45:35Z")
I don’t want to speak for @muneer but if you’re needing step-by-step help, you might consider hiring someone to tutor you in Thunkable. Aside from that, you can show what you’ve tried and explain the specific steps you’re working on and ask a pointed question and someone can try to help you further. ---
**Author:** ![dentist2smileijqop7](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dentist2smileijqop7](https://community.thunkable.com/u/dentist2smileijqop7)\ **Post date:** [April 28, 2022, 6:44pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/9 "2022-04-28T18:44:10Z")
Hi I try this helpful demo Thankable but I fail to get data from 2 column [demo 2 column Thunkable](https://x.thunkable.com/copy/28d96e8eb893ae35fc43cc6ba0bc1ea0) please help me ---
**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:** [April 28, 2022, 7:19pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/10 "2022-04-28T19:19:02Z")
I updated my demo to search for both names and numbers. [See this](https://x.thunkable.com/projectPage/626ae5579feba400113e5f10) ---
**Author:** ![dentist2smileijqop7](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dentist2smileijqop7](https://community.thunkable.com/u/dentist2smileijqop7)\ **Post date:** [April 28, 2022, 7:28pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/11 "2022-04-28T19:28:46Z")
Thank you so much 😍 ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [May 16, 2022, 11:49pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/12 "2022-05-16T23:49:31Z")
One more here [Making a Search Bar](https://community.thunkable.com/t/making-a-search-bar/60939) ---
**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:** [August 14, 2022, 11:49pm UTC](https://community.thunkable.com/t/solved-how-can-i-create-a-search-bar-for-my-google-sheets-data/1808538/13 "2022-08-14T23:49:34Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.