# \[Solved\] Finding and Deleting Airtable Rows

**URL:** <https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867>\
**Category:** Questions about Thunkable X\
**Tags:** solved, airtable\
**Created:** [June 1, 2020, 6:27pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867 "2020-06-01T18:27:11Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 1, 2020, 6:27pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/1 "2020-06-01T18:27:11Z")

</div>

For my app, I am trying to find the most recent row in Airtable that contains the text “N/A,” and delete that entire row. Could you please help me fix my code?

 ![Screen Shot 2020-06-01 at 2.23.53 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/45d67ea49ed0bd9b364c71cd33811d6d08ed3bb3.png)

---

<div class="post-metadata">

**Author:** ![mythi](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mythi/32/70585_2.png) [@mythi](https://community.thunkable.com/u/mythi)\
**Post date:** [June 1, 2020, 6:55pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/2 "2020-06-01T18:55:11Z")

</div>

Hi @bobsunscreen, I think your issue is that you got all the rows which may contain values like “1, 2, N/A” and “3, 4, 5” (lists within lists), so you would be searching for text within a bunch of lists with doesn’t work. You should GetColumn so that it gives back individual values.

Sorry if that was a bad explanation but I hope it helps 🙂

---

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 1, 2020, 7:25pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/3 "2020-06-01T19:25:38Z")

</div>

That makes sense, thank you! I adjusted the code to GetColumn, but for some reason it still isn’t working. Any other ideas?

---

<div class="post-metadata">

**Author:** ![mythi](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mythi/32/70585_2.png) [@mythi](https://community.thunkable.com/u/mythi)\
**Post date:** [June 1, 2020, 8:50pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/4 "2020-06-01T20:50:05Z")

</div>

Hmm, what exactly do you mean by it not working? Is it not deleting? Try setting a random label to the `in list rows find last occurrence of item "N/A` and see what value it returns.

---

<div class="post-metadata">

**Author:** ![mythi](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/mythi/32/70585_2.png) [@mythi](https://community.thunkable.com/u/mythi)\
**Post date:** [June 1, 2020, 8:52pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/5 "2020-06-01T20:52:30Z")

</div>

Also, the AirTable deleterow block says rowObject, but based on your code it would be a number, so use the block DeleteRowNumber instead. I think that may be the problem

---

<div class="post-metadata">

**Author:** ![bobsunscreen](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bobsunscreen/32/85667_2.png) [@bobsunscreen](https://community.thunkable.com/u/bobsunscreen)\
**Post date:** [June 1, 2020, 9:40pm UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/6 "2020-06-01T21:40:19Z")

</div>

It’s now working - the problem was that I didn’t use DeleteRowNumber block. Thank you so much for your help! 😃

---

<div class="post-metadata">

**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:28am UTC](https://community.thunkable.com/t/solved-finding-and-deleting-airtable-rows/590867/7 "2024-11-08T11:28:52Z")

</div>