# How to make a function search for an empty google sheet cell?

**URL:** <https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343>\
**Category:** Questions about Thunkable X\
**Tags:** google-sheets\
**Created:** [February 4, 2024, 5:48pm UTC](https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343 "2024-02-04T17:48:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wulfy\_starr](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/wulfy_starr/32/164356_2.png) [@wulfy\_starr](https://community.thunkable.com/u/wulfy_starr)\
**Post date:** [February 4, 2024, 5:48pm UTC](https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343/1 "2024-02-04T17:48:56Z")

</div>

here i have this function that is supposed to search for an empty cell in a google sheet, and update the value in the newest created row to the text input’s text.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/01ef9e2ff6b07bfba720eb9fe7ab27fffaaf5eae.png)

the problem is that the cells don’t get updated  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/a/baf092e2d332ad306a9a731f0ea8125d3824ee04.png)

what should i fix in the code?

---

<div class="post-metadata">

**Author:** ![samclever](https://avatars.discourse-cdn.com/v4/letter/s/ec9cab/32.png) [@samclever](https://community.thunkable.com/u/samclever)\
**Post date:** [February 5, 2024, 4:04am UTC](https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343/2 "2024-02-05T04:04:33Z")

</div>

First we need to know what is actually retuning with that ‘get value’ block. Do a test with a button and call a known empty cell and have the return go to a label. If its coming back ‘null’ then you need to put your ‘get value’ block in the logic box like this:  
 ![test1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/5/e548ec3f33fccda28baace0d67132e3ec3eebfb4.png)

If that dosnt then we can dive deeper.

---

<div class="post-metadata">

**Author:** ![emlee703](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/emlee703/32/165400_2.png) [@emlee703](https://community.thunkable.com/u/emlee703)\
**Post date:** [February 5, 2024, 5:15pm UTC](https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343/4 "2024-02-05T17:15:49Z")

</div>

Do this:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/5/f502c434d2c6eaed58fe281b5301db3c9db1d0b4.png)

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a08e9b8756b0136d291a5d630184e62c47cd40e6.png)

---

<div class="post-metadata">

**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 5, 2024, 5:16pm UTC](https://community.thunkable.com/t/how-to-make-a-function-search-for-an-empty-google-sheet-cell/2819343/5 "2024-05-05T17:16:44Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.