# 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:** 1
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 17, 2020, 7:47am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/1 "2020-12-17T07:47:36Z")
I have searched in the community for a long time, but none of those solutions work, because my application does not have those complicated practices, I want a very simple method, who can provide me the easiest way to directly delete the airtable My current situation of the entire row of data ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/3/638a0d8d92584f2fba23951094236c4cef9e899b.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a0078177ee08f6375f96077297d9a737d93f9e63.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 17, 2020, 7:58am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/2 "2020-12-17T07:58:28Z")
Have you tried this: ![datasourcedeleteallrows](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/f/df874b0440030d911875fb094667e9287646bd33.png) Note: You can use it with Airtable only when you access it through Data Source drawer in the coding Blocks in the new UI (moving invisible components to block screen) ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 17, 2020, 10:20am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/3 "2020-12-17T10:20:15Z")
Thanks for your help, but what if I just want to delete the entire row of the specified item when I click to view it in the list? ---
**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 17, 2020, 10:55am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/4 "2020-12-17T10:55:31Z")
To delete a row you can use: ![deleterow](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/7/6722e9cc8f506715e2df4adb5fba83599a0198f2.png) However, if you want to delete the content of a specific field in a row then you should use the [Update] method ![update_value](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/2/1269d3ca86ee1c5084877130e45b8cce18448d35.png) ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 17, 2020, 10:57am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/5 "2020-12-17T10:57:24Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/2/f2bebb2ec4470318afb3c9e86dcc332dc7b00933.png) How to get this block, I just tried to get it from the custom process repeatedly, but without success ---
**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 17, 2020, 11:11am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/6 "2020-12-17T11:11:07Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/0/b005ee8b634adcd7e8a4fef52fe6050be5b045f0.png) ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 17, 2020, 11:13am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/7 "2020-12-17T11:13:11Z")
Thank you very much for your guidance, I am trying now ---
**Author:** ![kentleow1496li9s72](https://avatars.discourse-cdn.com/v4/letter/k/7ab992/32.png) [@kentleow1496li9s72](https://community.thunkable.com/u/kentleow1496li9s72)\ **Post date:** [December 17, 2020, 11:47am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/8 "2020-12-17T11:47:32Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/c/0ccf5f118da205994c84fd489f73023bac9c2dfd.png) Sorry i still can’t achieve ---
**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 17, 2020, 1:18pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/9 "2020-12-17T13:18:40Z")
The block shows that you are deleting the row and then try to update. Update method only works for existing rows. I advise you to add control for the green [error] so that you see that the row is actually deleted or an error prevented it to be deleted and then use the [Creat] to add a new row with the data you want. Note that the creat des not require a rowID. ![create_row](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/c/ec35a5c4b294fd64fa6d80b63c1078ea9cd82c25.png) ---
**Author:** ![darren](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/darren/32/69854_2.png) [@darren](https://community.thunkable.com/u/darren)\ **Post date:** [December 17, 2020, 1:41pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/10 "2020-12-17T13:41:30Z")
Until Thunkable adds the ability to delete `where x = y and z = a`, I am relying on using the AirTable API directly. More advanced, but works! > [@The AirTable API (a more efficient way to integrate AirTable with Thunkable)](http://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167): > > I’ve had the pleasure of working on a few AirTable projects recently. One thing I’ve learned is doing stuff like this is inefficient once you start to get a lot of data. [image] You should try to limit how much data you call and the number of API calls. To update a record, you shouldn’t get all rows, loop through all rows until you find the row you need to update, then update that row. With the AirTable API you can use things like filterByFormula to query the data in one call to reduce the d… ---
**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 17, 2020, 2:36pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/11 "2020-12-17T14:36:16Z")
Have you checked this out? Although not explained there is a demonstration of several airtable techniques here. This is a more data intensive approach and less reliable if the DB is being frequently accessed than the example from @darren, I’d imagine though. > [@Airtable tutorial](http://community.thunkable.com/t/airtable-tutorial/531535): > > Working with airtable can be confusing. This sample app features: Filtering and viewing data Dynamically changing the filter Find a row number Pull specific info from a cell in a row Updating 1 cell inside a particular row Adding Rows Deleting Rows Remix Link: [https://x.thunkable.com/copy/15949b2e4aec44fe2eb7fd1a72c47414](https://x.thunkable.com/copy/15949b2e4aec44fe2eb7fd1a72c47414) [UPDATED LINK] Live Web App: [https://thunk.app/w/bbHuW-EAv](https://thunk.app/w/bbHuW-EAv) An explanation of how to build this app will be posted on my website sometime this week along with the w… ---
**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, 8:51am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/13 "2020-12-18T08:51:39Z")
@kentleow1496li9s72, Can you guide me which blocks you want to check. You have Chinese names and variable and I am not sure what to check. 😁 ---
**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, 9:11am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/14 "2020-12-18T09:11:21Z")
Thank you very much, I have removed the irrelevant blocks and folded them up, and the remaining blocks for your help are expanded in the middle. What I have to do now is when I click button 7, it will delete the airtable server and The data on the mobile phone, the data is the selected item clicked from the list view2, I hope you can understand this explanation, you only need to help me to effectively delete the selected item, thank you for your help, thank you, really thank you youThe block to help is on the middle screen ---
**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, 9:12am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/15 "2020-12-18T09:12:54Z")
> **[Thunkable](https://x.thunkable.com/copy/d292ee0643df01b110e047cbc35d1fbd)** ---
**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, 11:34am UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/16 "2020-12-18T11:34:44Z")
@kentleow1496li9s72, hello again. I looked at your code but cannot see how you select the row you want to delete. Nothing in button7 that form a selection criteria. Another issue I found is in the initialization of the Web API. You have in the [Headers] double colon “::” in both [Authentication] and [Content-Type]. You need to remove one colon “:” Appreciate if you can explain your criteria of selecting the record to be deleted so I can explain further or modify the blocks for you. Note I will be busy for the rest of the day and will work on it tomorrow or you might get a help from another member. 😁 ---
**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, 12:15pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/17 "2020-12-18T12:15:30Z")
Because I deleted all the messy error code blocks, I just want to make it easy for you to help me directly start from 0, haha, what I want to delete is the data displayed on the listview of airtable2. The table name is to delete the entire row. Untitled base ![无标题](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/5/6585fec7381fdb360dc84a0a3cd90068bb776065.png) Do you understand what I’m talking about? Just you can build it in your way, as long as you can delete the data. ---
**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, 12:40pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/18 "2020-12-18T12:40:32Z")
If I understand you correctly, the data viewer list will have two fields (ref, pdf). When the user select one of the rows in the list, you want to delete it from the Airtable. Is this correct? ---
**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, 12:45pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/19 "2020-12-18T12:45:12Z")
Yes, but if possible, I hope to include other items such as phone, fee, and subtotal to be deleted at the same time. Do you think it is feasible? Because, I am building an application for receiving order processing, and I am worried about deleting only ref and pdf and if the other parts are not deleted, there will be a blank part. If the latter submits a new order, I am afraid that the recipient will not see the new data ---
**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, 12:58pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/20 "2020-12-18T12:58:55Z")
The most efficient (not easiest) way to do this would be to use the API offered by airtable This is the easier less efficient way: > [@Airtable tutorial](http://community.thunkable.com/t/airtable-tutorial/531535): > > Working with airtable can be confusing. This sample app features: Filtering and viewing data Dynamically changing the filter Find a row number Pull specific info from a cell in a row Updating 1 cell inside a particular row Adding Rows Deleting Rows Remix Link: [https://x.thunkable.com/copy/15949b2e4aec44fe2eb7fd1a72c47414](https://x.thunkable.com/copy/15949b2e4aec44fe2eb7fd1a72c47414) [UPDATED LINK] Live Web App: [https://thunk.app/w/bbHuW-EAv](https://thunk.app/w/bbHuW-EAv) An explanation of how to build this app will be posted on my website sometime this week along with the w… Here is a great example of working with airtable API the more efficient way > [@The AirTable API (a more efficient way to integrate AirTable with Thunkable)](http://community.thunkable.com/t/the-airtable-api-a-more-efficient-way-to-integrate-airtable-with-thunkable/1021167): > > I’ve had the pleasure of working on a few AirTable projects recently. One thing I’ve learned is doing stuff like this is inefficient once you start to get a lot of data. [image] You should try to limit how much data you call and the number of API calls. To update a record, you shouldn’t get all rows, loop through all rows until you find the row you need to update, then update that row. With the AirTable API you can use things like filterByFormula to query the data in one call to reduce the d… ---
**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:02pm UTC](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/21 "2020-12-18T13:02:17Z")
I tried it, but I don’t understand the api at all, plus the row to be deleted I have to get its id, but if I want to get the id, I have to build it from scratch according to its tutorial, so there are many things I did before All have to be changed, you now understand why I don’t need api? [Next page](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786.md?page=2)