# How to empty an table entry (cell)? **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [October 17, 2022, 10:07am UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261 "2022-10-17T10:07:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![proximilius](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/proximilius/32/140171_2.png) [@proximilius](https://community.thunkable.com/u/proximilius)\ **Post date:** [October 17, 2022, 10:07am UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/1 "2022-10-17T10:07:37Z")
Hi there, I’m stuck in some (seemly) simple problem. I use a normal data source table and I want to empty table entry. Not to delete whole row. I was thinking to just make an empty string but not working. I also tried to give null to te table entry but nope not working. Please help!! ![problemo](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/4/04bc052797a2df620fa19faaa6ebefb1cb4eebd5.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 17, 2022, 11:03pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/2 "2022-10-17T23:03:26Z")
Those blocks should set the UID for the selected row to an empty string (“”). The `rec no` input value would need to be an integer. What do the blocks that call your recycle function look like? Have you tried a simple `when button click` → `recycle` set of blocks? And how do you know it’s not working? How are you checking the value of row # `rec no` after the `recycle` function completes? ---
**Author:** ![proximilius](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/proximilius/32/140171_2.png) [@proximilius](https://community.thunkable.com/u/proximilius)\ **Post date:** [October 18, 2022, 9:54am UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/3 "2022-10-18T09:54:01Z")
I expanded the image of blocks a bit. My call to the function has an integer as actual var. I call the function by a click on that nice GUI button. On the Gui I have 2 debug lables. The first lable should show up empty when the cell on my table is empty. I tested it with another empty cell as value for that lable. The second lable gives me an counter to check the function ran or not. I also upload my database. ![database](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c603422d265c9b7c0588952de3c73aa195cc75a3.png) ![gui](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/d/edc4babd8edfa9a519d9bc532d89f854e1f8105c.png) ![recycle blocks](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/0/5015e22098e0040f268275246c705743917d3a50.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 18, 2022, 2:57pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/4 "2022-10-18T14:57:06Z")
Is your my\_devices database a local table or a cloud site such as Google Sheets or Airtable? If the latter, can you see the change in your database from the `update value` block? Because my guess is that what’s happening is the value **is** changing but you’re experiencing the `get value` block bug. You can read about it here: > > > \### Platform > Drag and Drop UI - web? > Drag and Drop UI - iOS? > > \### Steps to R…eproduce > 1. Click the "Get & update values" button to get and display a value from a Google Sheet cell (e.g. 4), and update the value by one (e.g. 4+1). > 3. Wait a few seconds (or more) and click the "Get new value" button. > > \### Expected Behavior > I would expect the second time the value is displayed that it includes the added value (e.g. 5). > > \### Actual Behavior > The second time the value is displayed, it shows the original value (e.g. 4). > > \### Project Link > https://x.thunkable.com/copy/1feeef38c13e4150815598a95155e283 > > \###Community Link > https://community.thunkable.com/t/cant-get-value-from-google-sheets/1816128 > > \`\`\` > STACK TRACE AND/OR SCREENSHOTS > \`\`\` > > > \### Platform > Does this affect: > Drag and Drop UI - iOS? > > \### Steps to Reprodu…ce > 1. I am attempting to get a row object from Google Sheets because the Get Value block is buggy. These two issues have been reported before here: https://github.com/thunkable/thunkable-issues/issues/1138. > 2. See the screenshot below for the blocks in question. I've also sent that screenshot and many more details about this issue via the support chat. > > I've tried: > • Re-syncing the Google Sheet > • Creating a new Google Sheet to attach to the project instead of the existing one > • Deleting and re-adding the Data Source blocks > > \### Expected Behavior > Expected behavior is that getting a row object returns a row object. > > \### Actual Behavior > Unpredictable things. Null values for parts of the row object. Code hanging when attempting to get a row object at all. > > For example, in the screenshot below, the Title label displays "B" and then everything stops. It never gets to "C". > > \### Project Link > https://x.thunkable.com/projects/6281d4af68e4420011b1ff8c/66d16617-afbc-4ffc-a8ef-868bf633d863/blocks > > (private project) > > Also, here's a simplified project that demonstrates the same issue. The code hangs after it displays "Fetching..." > > https://x.thunkable.com/copy/6283a1415e945e0a1cfe2842e9ad64b3 > > (Also private project, I believe) > > \###Community Link > If there's an ongoing discussion about this behavior in the Community, please link to it here > > \`\`\` > STACK TRACE AND/OR SCREENSHOTS > \`\`\` > \image **I’d recommend using the `get row object` block instead and getting the property of the object for the column you need (“UID”).** ---
**Author:** ![proximilius](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/proximilius/32/140171_2.png) [@proximilius](https://community.thunkable.com/u/proximilius)\ **Post date:** [October 18, 2022, 5:55pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/5 "2022-10-18T17:55:19Z")
Hi Tatiang, First of all many thanks for looking in to my problem already. The entire project is for home automation. I use Arduino’s to switch lights on and off. The App I’m building is to control them. I connect them trough Bluetooth. All is working fine but for version 2 of my app I plan to make a settings screen in witch I can change the devices. For now I can add new devices and change the image on them. All is logged on the DB (table) on my phone. Only thing is to recyle a device. I was thinking about delete entire row, but problem on that solution is I lose the whole row and can’t add a new one if I want. I use the local table for my DB. I planned to do this for reason I don’t want to rely on internet based content. In early stage of my project (not using bluetooth) I experienced a malfunction on internet provider side, and could not turn off the light. So now I don’t use cloud content at all. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [October 18, 2022, 9:00pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/6 "2022-10-18T21:00:47Z")
Why can’t you add a new row after you delete one? That’s what the Create Row block is for. Let me know if my suggestions solve the problem for you. ---
**Author:** ![proximilius](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/proximilius/32/140171_2.png) [@proximilius](https://community.thunkable.com/u/proximilius)\ **Post date:** [October 19, 2022, 4:46pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/7 "2022-10-19T16:46:01Z")
The delete entire row and add new row seems to work. At first I did not want this because I was thinking that shifting a device in order was something I not desire. Now I implemented it and after testing this method is n’t that messy I first thought. Here the new function blocks. Stil having many debug text inside, so read between those lines. 🙂 ![Knipsel](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/8/e8100a4c6169f1bd69b05ecc1216c533aa58d9e7.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [January 17, 2023, 4:46pm UTC](https://community.thunkable.com/t/how-to-empty-an-table-entry-cell/2086261/8 "2023-01-17T16:46:23Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.