# \[Solved\] Search AirTable Spreadsheet to find empty cell/s **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** solved, airtable\ **Created:** [March 11, 2020, 7:27pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301 "2020-03-11T19:27:35Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![hi1](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@hi1](https://community.thunkable.com/u/hi1)\ **Post date:** [March 11, 2020, 7:27pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/1 "2020-03-11T19:27:35Z")
Hi, so I’ve been trying for 2 days now to do this. I have a table in AirTable Spreadsheet. I want to go through all the cells of the first row of the table. I want to find the first cell that is empty. This how one of my many attempts looks like. ![still_not_working](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/2/3294b0a781ff1cbc6f9a04bf712bed2a911854f1.png) I tried to use labels instead of the STOP variable, but no, it did not work. How do I do this? Thanks. ---
**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:** [March 11, 2020, 7:34pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/2 "2020-03-11T19:34:02Z")
instead of this ![Screen Shot 2020-03-11 at 3.20.09 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/45595d5bbddc0fe3d52d16448887e1482c8068bf.png) can you try one of these below. dont forget to include setting ‘app stop’ to 1 ![Screen Shot 2020-03-11 at 3.19.18 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/b/3be30cfcaca53603e1db85c4fdd8cfc6fb2a5ad6.png) or ![Screen Shot 2020-03-11 at 3.19.45 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/0/0091f7e06a5575ff78628003a758711c51458331.png) ---
**Author:** ![hi1](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@hi1](https://community.thunkable.com/u/hi1)\ **Post date:** [March 11, 2020, 8:22pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/3 "2020-03-11T20:22:22Z")
Thank you! It’s still a small adjustment, it doesn’t change much. Unfortunately, the program still doesn’t work. ---
**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:** [March 11, 2020, 8:34pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/4 "2020-03-11T20:34:09Z")
So you are searching each cell of your table for an empty spot? What do you want to do when you find that spot? ---
**Author:** ![hi1](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@hi1](https://community.thunkable.com/u/hi1)\ **Post date:** [March 11, 2020, 8:49pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/5 "2020-03-11T20:49:20Z")
When I find the cell, I want to edit that cell (I want to add text to it); I can still go through the other cells, but I do not want to edit any of them. For example, if cell 1 contains text, cell 2 contains text as well, but cells 3 and 4 do not contain any text, I want to edit cell 3 such that it contains text. Cell 4 should remain unchanged. ---
**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:** [March 11, 2020, 9:36pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/6 "2020-03-11T21:36:11Z")
I’ve got an idea for this. I’ll get back to you later on this ---
**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:** [March 12, 2020, 4:13am UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/7 "2020-03-12T04:13:31Z")
I don’t have your airtable set-up and am preparing for an exam so I couldn’t fully test this. can you try this out? ![Screen Shot 2020-03-11 at 11.59.03 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6af7a60319b5cc192012096d63a301fe61816f27.png) ---
**Author:** ![hi1](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@hi1](https://community.thunkable.com/u/hi1)\ **Post date:** [March 12, 2020, 12:48pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/8 "2020-03-12T12:48:25Z")
Still not working. This code detects the first cell of each row as being empty even if it’s not. ---
**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:** [March 12, 2020, 1:13pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/9 "2020-03-12T13:13:03Z")
I wonder if this was removed, any difference Remove the else condition Then if no luck, switch out the text empty block with a logic block and check does the object =null ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/e/fe36705b0da3dadcd4ebeedec9db4c7b6c781918.jpeg) ---
**Author:** ![hi1](https://avatars.discourse-cdn.com/v4/letter/h/b487fb/32.png) [@hi1](https://community.thunkable.com/u/hi1)\ **Post date:** [March 12, 2020, 1:57pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/10 "2020-03-12T13:57:52Z")
Sorry, I think it was my fault - I did not copy your code correctly (probably). Your code works perfectly. Thank you! ---
**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:** [March 12, 2020, 2:30pm UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/12 "2020-03-12T14:30:12Z")
I think the issue lies with the fact that the variable row count, there’s no reset every time the button is clicked. Essentially The set cell block is trying to find a Row that won’t exist after the first run through. What you would want to do is add a set row count to zero block every time you press the button before you do any of the other actions following button click ---
**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:** [March 15, 2020, 5:25am UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/13 "2020-03-15T05:25:35Z")
@hi1 Hey! I’m glad this code worked out for you! Awesome work implementing it yourself! {i renamed this post slightly for search optimization} ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 11:40am UTC](https://community.thunkable.com/t/solved-search-airtable-spreadsheet-to-find-empty-cell-s/510301/14 "2024-11-08T11:40:25Z")