# Wouldn't these blocks delete rows? **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [April 20, 2021, 10:57am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935 "2021-04-20T10:57:25Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 10:57am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/1 "2021-04-20T10:57:25Z")
Hi Wouldn’t these blocks remove rows from first my local table (myItemsList) then my Airtable (AT\_Food4Two\_List)? ![Screenshot 2021-04-20 at 12.43.03](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/a/9a2fac174be4b16d948dc708bc6a59f048754c23.png) Is there something I am misunderstanding? The item will get removed from the Local list (myItemsList), but Airtable are unefetcted… I use something similar for Adding items, and that works fine!: ![Screenshot 2021-04-20 at 12.51.25](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/0/c005eae21cfd5d9c713f3adb06c69c02d9a2f413.png) The idea is to be able to work locally to speed up the workflow and gain the experience for the user. So everything I do in the app is being updated to my local list but also my Airtable database in the background, which is syncing with the local list every time Screen1 starts. But when delete items it will only be deleted for the local list but Airtable won’t get effected. Thanks for any ideas! ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 11:09am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/2 "2021-04-20T11:09:54Z")
I have also tried this method: But it’s the same thing here… The local item/row are being deleted, but not in Airtable. ![Screenshot 2021-04-20 at 13.08.46](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/e/0e0e44ee64631eaa937457dc49fdeca53201196a.png) Thanks! ---
**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:** [April 20, 2021, 11:31am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/3 "2021-04-20T11:31:15Z")
No. This will not work. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 11:34am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/4 "2021-04-20T11:34:06Z")
hehe… Indeed! I was hoping it would be as easy as to ADD an item, but obviously not. You wouldn’t happen to have any tips here? ---
**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:** [April 20, 2021, 11:43am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/5 "2021-04-20T11:43:41Z")
I know exactly what is going on. You are taking the “row id” green block from a DVL which is connected to a specific table and these “row id” are for this table. Row IDs are unique and will not be duplicated and therefore the “row id” that works with your local table should not work with another table whether local or Airtable. Therefore, you are trying to delete a non-existing row in Airtable. Happy Thunking! ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 11:49am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/6 "2021-04-20T11:49:16Z")
Thanks, I understand, but I did not in the last example. I took the app variable containing all the items as the rowObject. (As I understood this from an Thunkable tutorial, there is something underlying with this method that actually sees which row I am at, but maybe I have misunderstood.) ? ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 20, 2021, 12:15pm UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/7 "2021-04-20T12:15:56Z")
I do understand now that this other method wont work either as I am “picking” the item from the DVL. So, if I am right with the underlying mystery from that tutorial I would need to go from my ListViewer I guess. So, I am starting to thinking, maybe I need to “get the rowNr” for that Item. Is there anyone with any ideas how to do that? I need to get the rowNr for that item in Airtable by select and swipe on my DVL. I am thinking something like this:? But if close then something is missing as it wont do it for me 🙂 ![Screenshot 2021-04-20 at 14.09.26](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/6/46f530e254931f17d11c92ae5b40ec9d369a68a0.png) Thanks for any help! ---
**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:** [April 20, 2021, 3:13pm UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/8 "2021-04-20T15:13:28Z")
You need to change your strategy. First, your local table should contain 2 columns (“items” and “AT\_rowId” for Airtable row id) Second, you don’t need all the list variable you are creating. Once you perform GetAllRows from Airtable table delete all rows from your local table and then start your loop through the rows matching the User ID with selected User ID and when found add it to the local table with the “items” and “\_id”. Your DVL will show only the items column and when you select or swipe then first read the content of the row in your local table and save the AT\_rowId in a variable then delete the row in the local table and thereafter delete the row in Airtable table using the AT\_rowId you saved in your variable. This will work. Happy Thunking! ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 21, 2021, 7:44am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/9 "2021-04-21T07:44:10Z")
Hi Thanks Muneer. As you can see I am new to this thinking, that’s why so many questions. But I learn on the way and love doing so! regarding all these variable-lists. Those are actually made from a Thunkable tutorial, I wouldn’t come up with all that “advanced” stuff my own 😊 Thanks for the tips! I will actually reconstruct my App today and have this in mind, let’s see how that works! Thanks! ---
**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:** [April 21, 2021, 8:58am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/10 "2021-04-21T08:58:46Z")
Try this one to help you get what you want [https://x.thunkable.com/projectPage/607d4c9e4c9d29073e54fd9f](https://x.thunkable.com/projectPage/607d4c9e4c9d29073e54fd9f) ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 21, 2021, 10:51am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/11 "2021-04-21T10:51:27Z")
Thanks! I am trying my best 🙂 May I ask, with “\_id”, do you mean “AT\_rowId” from this line: “First, your local table should contain 2 columns (“items” and “AT\_rowId” for Airtable row id)” ? Or is that a column/property from your Airtable-sheet (that I can’t see)? ---
**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:** [April 21, 2021, 11:42am UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/12 "2021-04-21T11:42:46Z")
“\_id” is a hidden column in Airtable that stores the row id which can be used to retrieve/update/delete that specific row. ---
**Author:** ![andreas.sjdtomypv](https://avatars.discourse-cdn.com/v4/letter/a/e5b9ba/32.png) [@andreas.sjdtomypv](https://community.thunkable.com/u/andreas.sjdtomypv)\ **Post date:** [April 21, 2021, 2:36pm UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/13 "2021-04-21T14:36:15Z")
Great, thanks. That was my thought as well 😊 ---
**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, 1:25pm UTC](https://community.thunkable.com/t/wouldnt-these-blocks-delete-rows/1234935/14 "2024-11-08T13:25:08Z")