# How to delete a single row from airtable **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** airtable\ **Created:** [December 17, 2020, 7:47am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786 "2020-12-17T07:47:36Z")\ **Posts on this page:** 20\ **Page:** 2
**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:** [December 18, 2020, 1:15pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/22 "2020-12-18T13:15:25Z")
Then the easier, less efficient way would be your answer. It’s called a vlookup. You would get the column containing the userID Then using blocks search for the index of the value in the column matching your search That index = the row number Delete/modify that row # ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 1:17pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/23 "2020-12-18T13:17:15Z")
Where do I get it? ---
**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:** [December 18, 2020, 1:20pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/24 "2020-12-18T13:20:45Z")
I would use the ref or phone number column as my reference assuming no two users have the same phone number. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 1:22pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/25 "2020-12-18T13:22:23Z")
I just used ref as the id and used api to delete it, but it was not successful. ---
**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:** [December 18, 2020, 1:27pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/26 "2020-12-18T13:27:56Z")
Can you show the url (block your api key) ? I’d like to see what the filterByFormula looks like ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 1:39pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/27 "2020-12-18T13:39:25Z")
I’m sorry, I’m busy with other things, I didn’t see your information, you can try it in my project yourself, because I made it public ---
**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:** [December 18, 2020, 1:47pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/28 "2020-12-18T13:47:40Z")
Not to offend, but If you don’t have time to work on this and neither do I. When you’re able to show those things let us know and the community would be happy to help. Unfortunately using the API can be tricky and you have to send things very specifically. A Vlookup is your best option if you don’t want to use the API and you can definitely search the forum for posts related to that Happy Thunking!! ---
**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:** [December 18, 2020, 1:56pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/29 "2020-12-18T13:56:16Z")
@kentleow1496li9s72, According to what you are saying, you do not need the Web API component, not you need any other component. When the user selects the row to be deleted from the data viewer list you need to use this block ![item_click](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8b79235f2e0632f1950018ba07f35837c9c4de5e.png) And inside it use the [DeleteRow] block and pass the green rowID from this block as the rowID for the DeleteRow. That is all what you need. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 1:58pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/30 "2020-12-18T13:58:53Z")
From what you mean to me, do you think I don’t want to be lazy and want to find someone to replace me, right?, if I’m like that, why should I work so hard to look at people’s faces? Is it better?, I know that many people don’t want to do it all the time and think about getting the answer, but if you can see before registering a community account or see how long it took me to prepare for this project , You decide if I am that kind of person ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:02pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/31 "2020-12-18T14:02:42Z")
pdf is a pdf format diagram of an order. If it is deleted immediately when clicked, the user will not be able to view the order. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:04pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/32 "2020-12-18T14:04:23Z")
So I hope to click the button to delete the entire row of data when the order is complete ---
**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:** [December 18, 2020, 2:16pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/33 "2020-12-18T14:16:05Z")
Yes, the [DeleteRow] block will delete the entire row not only the data shown in the data viewer list. I advise that you use the Alert to further check if the user really wants to delete this row and was not clicking by mistake. As I explained earlier, I’m away from my computer now but happy to provide you the changes tomorrow. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:17pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/34 "2020-12-18T14:17:33Z")
Thank you for your help, I will continue to try and see, thank you very much ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:19pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/35 "2020-12-18T14:19:28Z")
You asked me what response I got, I will answer you now is Not Found 404 ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:20pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/36 "2020-12-18T14:20:07Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/1/013c1ee5afeb471bda555985148858e5c5542bf1.png) ---
**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:** [December 18, 2020, 2:56pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/37 "2020-12-18T14:56:13Z")
This means there is a problem or a typo error in the URL of the API. However, I still believe you don’t need to go through the API because you can use the rowID provided by the data viewer list. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 2:58pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/38 "2020-12-18T14:58:07Z")
The id I am using is provided from rowid, because I put a variable in the listview when the user clicks, the rowid input is saved in the variable ---
**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:** [December 18, 2020, 3:40pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/39 "2020-12-18T15:40:46Z")
Great, Use this rowID you are storing in the variable as the rowID for the DeleteRow block. This should work. ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 18, 2020, 3:50pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/40 "2020-12-18T15:50:51Z")
I tried before, but unsuccessful ---
**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:** [December 19, 2020, 7:03am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/41 "2020-12-19T07:03:41Z")
@kentleow1496li9s72 I had to go back to your explanation and then I found my mistake. The title of the post you said “Airtable” and this is why we kept trying to do something to remove a record from Airtable but the record you want to delete is actually in a local storage table called “Untitled Base” This is what you need to do to delete the record (row) in that table ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c7b2f7d7ea387aa68dd5df598dc23e019b079a5f.png) Hope this would clear the confusion. Of course you can add other things like refreshing the data viewer list after the deletion process is complete to reflect changes. [Previous page](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786.md?page=1) [Next page](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786.md?page=3)