# 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:** 18\ **Page:** 5
**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:** [January 19, 2022, 2:16pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/81 "2022-01-19T14:16:40Z")
There are 3 ways how to control what components to be effected (for example, convert to capitals) and what components do not get effected. I have demonstrated this in the following project. [https://x.thunkable.com/projectPage/61e81c46ac097800100daec1](https://x.thunkable.com/projectPage/61e81c46ac097800100daec1) This should answer your question about how to leave **remarks** field without capitalization. Again the same is true for the function that test if all fields are filled and not empty. ---
**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:** [January 19, 2022, 10:07pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/82 "2022-01-19T22:07:35Z")
Hi @muneer, many thanks. I shall let you know how I get on. 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:** [January 20, 2022, 12:26am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/83 "2022-01-20T00:26:40Z")
Hi @muneer, I’ve just tried “ **Option2** ” first in my project and the result now omits the “ **Remarks** ” column on the **Google Sheet**. However, when I type **lower case** into the “ **Remarks** ” field it is still converted into **UPPER** case and entered into my **Google Sheet** as such (see below): My lower case entry into the “ **Remarks** ” input box in the app: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/7/477ec9a92987adb4ff5a248fd893c8341cf49579.png) When I click “ **Save** ” it is converted into **UPPER** case: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/0/b0c8c1b76f3c0c729e176f838e8b532f3d4e1869.png) The enter in my Google Sheet ( **row 1735** ): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/4/84d5a2317be8d089e5ab21a0165e2180d2062a0f.png) Here are my blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/0/403233be5c538f95098136a3229dc0229ef2d15a.png) I thought put the **Option2** blocks in the wrong place so I tried placing in the “When button clicked…” ( **AddRecBtnSave** ) this just **negated the omission function** of **Option2’s** blocks. See below: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/7/d7d183514a530369a3016023f43b45b99a65dab0.png) ============================================================================= I then tried Option1 by adding **Option1’s blocks** to the “ **Button1 click** ” blocks First, with no text in the " **Remarks" input box** but no entry was made to the **Google Sheet**. (See my app image & blocks below): ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/c/ac9ce9f8d0a83c7a5223be47eada9f758f63ea2a.png) Blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e618d3b82849582711832702befa83187dac2d12.png) I then tried making an entry into the “ **Remarks** ” input box and the entry was made successfully into the **Google Sheet** but still in **UPPER** case. Am I actually placing the blocks in the correct place(s)? **I really do not know what I’m doing** I am getting really confused. 😟 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:** [January 20, 2022, 8:52am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/84 "2022-01-20T08:52:58Z")
If you selected **option2** then you need to do the change in **TWO** functions. No other changes required. Change the **AreAllFilled** function and **MakeAllCaps** function. Make sure the changes is what is explained in the demo project. ---
**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:** [January 20, 2022, 12:30pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/85 "2022-01-20T12:30:48Z")
Thanks @muneer, I will 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:** [January 20, 2022, 1:00pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/86 "2022-01-20T13:00:06Z")
Hi @muneer, could you please tell me if I have the function blocks “ **AreAllFilled** ” and “ **MakeAllCaps** ” correct? I have now decided on **Option2** but when I leave the “ **Remarks** ” input box empty no entry is made to my **Google Sheet**. When there is text in the “Remarks” input box, the **Remarks** text is now showing as “ **lower case** ” but so is the “ **DATE** ” text. ( **See row 1742** in my Google Sheet below:). My blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/d/adc80f883866e461220c649df8368b2b469d70b8.png) My Google Sheet: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/9/4975d1c88b73734c806594f50b83edd8a49ff497.png) 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:** [January 20, 2022, 3:26pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/87 "2022-01-20T15:26:00Z")
Dear @andos-avlog Please next time copy only the required function or piece of blocks. Copying the whole screen makes the code unclear/blurred. From what I see in the **AreAllFilled** , you are trying to check for an impossible condition. Please look at my example and use the same type of blocks. The block you used is **wrong**. ---
**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:** [January 20, 2022, 4:29pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/88 "2022-01-20T16:29:56Z")
Hi @muneer, my apologies. I’ve been using the view of all the blocks because I do not know where I am going wrong. I hope the image below is better. How do I make your blocks ( **AddRecBtnSave** ) fit into the “ **AreAllFilled** ” function? Also, is it **ok to have 2 “When AddRecBtnSave click” controls** for the same button? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f28fb5d0e7fa2389532c87229349056a1b805c22.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/1/214ee5b14b2a89f5e09a37215dac35d3ae77c675.png) 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:** [January 29, 2022, 8:59pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/89 "2022-01-29T20:59:49Z")
Hi. @muneer, did you receive my previous post? 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:** [January 30, 2022, 6:50am UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/90 "2022-01-30T06:50:37Z")
I haven’t seen anything from you over a week. Have you fixed this and the other function for CAPS? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/8/38a2c5eb3b13df4a2eb9c363882ac3b6056f6a39.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:** [January 30, 2022, 4:37pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/91 "2022-01-30T16:37:57Z")
Hi @muneer, obviously a misunderstanding as I have been waiting to hear from you regarding my previous 3 messages. The **CAPS issue has been resolved**. However, the issue regarding the user being able to optionally leave the **"Remarks**" blank is not. Currently, the issue is that no entry can be made into the **Google Sheet** if the “ **Remarks** ” input field is not filled in. The problem from your last suggestion was that I cannot see a way of inserting the “ **AddRecBtnSave/Click** ” blocks into the “ **AreAllFilled** ” function block. I am also already using an “ **AddRecBtnSave/Click** ” function elsewhere. I am not sure if this is allowed. See below: Also, is it **ok to have 2 “When AddRecBtnSave click” controls** for the same button? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f28fb5d0e7fa2389532c87229349056a1b805c22.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/1/214ee5b14b2a89f5e09a37215dac35d3ae77c675.png) 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:** [February 1, 2022, 3:34pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/92 "2022-02-01T15:34:23Z")
Hi @muneer, I am still awaiting your reply. 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:** [February 1, 2022, 4:16pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/93 "2022-02-01T16:16:06Z")
I’m not sure what are you waiting for from me. You previously said that you settled for the **exception method** which makes sense in this case and it should work will. You also decided not to use **functions** and use the code blocks directly in the button **click** which is a personal choice but sacrifice clarity and ease of debugging. You also mentioned that the **CAPS issue is resolved** and due to the fact that the **exception method** would work the same in both cases the other issue should be solved in exactly the same way. From the screenshot you provided you have completely missed up the function **AreAllFilled** and now it has no value but it is still used in your code. If you do not provide clear description of the changes you made then we will work in circles. ---
**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:** [February 1, 2022, 4:51pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/94 "2022-02-01T16:51:59Z")
Ok @muneer, you asked: > [@muneer](#): > > I haven’t seen anything from you over a week. > > Have you fixed this and the other function for CAPS? > ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/8/38a2c5eb3b13df4a2eb9c363882ac3b6056f6a39.png) I replied: Currently, the issue is that no entry can be made into the **Google Sheet** if the “ **Remarks** ” input field is not filled in. The problem from your last suggestion was that I cannot see a way of inserting the “ **AddRecBtnSave/Click** ” blocks into the “ **AreAllFilled** ” function block. I am also already using an “ **AddRecBtnSave/Click** ” function elsewhere. I am not sure if this is allowed. See below: Also, is it **ok to have 2 “When AddRecBtnSave click” controls** for the same button? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f28fb5d0e7fa2389532c87229349056a1b805c22.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/1/214ee5b14b2a89f5e09a37215dac35d3ae77c675.png) ============================================================================= In summary, I was asking how do I use the “ **AreAllFilled** ” function? (pictured in your attached reply) Because I was trying to add the “ **AddRecBtnSave** ” control blocks into the “ **AreAllFilled** ” function which clearly does not fit (1st image pictured above in my reply) Based on the link ( **below** ) you sent to me, I chose “ **Option2** ” as my solution. [https://x.thunkable.com/projectPage/61e81c46ac097800100daec1](https://x.thunkable.com/projectPage/61e81c46ac097800100daec1) Shown in below image. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/7/47531c81cdcd18084f7e73d9b0dbd2e2f5bead99.png) I would like to know how to use the " **AreAllFilled"function** (pictured below) you asked me about in relation to these blocks from **Option2**? 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:** [February 1, 2022, 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/95 "2022-02-01T17:09:08Z")
You are asking the same question again. Just follow the same principle to get what you want. See the updated demo project in page 2 [https://x.thunkable.com/projectPage/61e81c46ac097800100daec1](https://x.thunkable.com/projectPage/61e81c46ac097800100daec1) ---
**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:** [February 1, 2022, 5:12pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/96 "2022-02-01T17:12:04Z")
Ok @muneer, I shall try this and let you know how I get on. 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:** [February 3, 2022, 8:07pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/97 "2022-02-03T20:07:20Z")
Hi @muneer, I have copied your most recent suggestion and have now run into more of the same problem. Because I had already created two “Columns” (“ **FVAddColumn** ” and “ **RmksColumn** ”) to isolate the **restricted and conditioned input fields** (“REG”; “C/N”; “TYPE”; “DATE”; “CALLSIGN” and “FRAME/REG”) from the **unrestricted input field** (“REMARKS”), I am wondering if this may be the problem. 1. When I leave a blank on any of the **restricted fields** (see below) and click the “ **Save** ” button, quite correctly no entry is made into the **Google Sheet**. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/4/2405f8554c64085e71cd670e5ec177b1e31a6c7e.png) However, when I do the same again except this time I add data into the “ **Remarks** ” field (see below) and click “ **Save** ”, the entry is made into the **Google Sheet** displaying the blank field. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/a/ea12dfc8492561784ced0a96957052d445704963.png) What am I doing wrong? What can’t I see it? This is very frustrating! Could you please explain to me what is wrong with my blocks in a way that I can understand? I feel like I’m going round in circles. Everything else is working as it should do, except for this! **Here are my blocks:** ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c7443aab171c79c0a8070f388510717d9e8e7f78.png) When I look at the “ **AreAllFilled** ” function it doesn’t make any sense to me. Eg. Why does the “ **Remarks** ” field have to be in there? (below:) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/7/2748656aed7848b6f263f286ed3b9b5e8b297643.png) Just when I think I’m starting to grasp something, something else causes me to not understand the logic. Here is the link to my project: [https://x.thunkable.com/copy/2461e3192b3971a92fb7b942170f2540](https://x.thunkable.com/copy/2461e3192b3971a92fb7b942170f2540) I’m really sorry to be a pain but this so frustrating! Many thanks, Andos. ---
**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:** [May 4, 2022, 8:07pm UTC](https://community.thunkable.com/t/i-wish-to-create-a-search-bar-which-will-return-very-specific-values-from-a-gsheet/1647137/98 "2022-05-04T20:07:33Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [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=4)