# Delete Entire Row

**URL:** <https://community.glideapps.com/t/delete-entire-row/15394>\
**Category:** Ask for Help\
**Created:** [September 7, 2020, 7:51am UTC](https://community.glideapps.com/t/delete-entire-row/15394 "2020-09-07T07:51:41Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![DariusGiovanni](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)\
**Post date:** [September 7, 2020, 7:51am UTC](https://community.glideapps.com/t/delete-entire-row/15394/1 "2020-09-07T07:51:41Z")

</div>

I have an issue regarding my app. My plan is when the user delete the item on the app (delete item features), the entire row will get deleted (not only the value). For example, if the user delete the item on the 3rd row, the entire row will get deleted and the 4th row will become the new 3rd. Are there any way to do this?

 ![Screen Shot 2020-09-07 at 15.32.05](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/67091652c824668b60d93f14773f65101d0e504c.png)

---

<div class="post-metadata">

**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\
**Post date:** [September 7, 2020, 8:25am UTC](https://community.glideapps.com/t/delete-entire-row/15394/2 "2020-09-07T08:25:55Z")

</div>

@DariusGiovanni just out of interest, have you thought about a “soft delete” whereby you simply mark the row with a boolean flag e.g. Deleted or Archived and then filter it out within the app? That way you don’t mess up any “row monitoring” that you might have in place with Zapier or Integromat and you retain the data just in case it might be needed?

---

<div class="post-metadata">

**Author:** ![DariusGiovanni](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)\
**Post date:** [September 7, 2020, 8:34am UTC](https://community.glideapps.com/t/delete-entire-row/15394/3 "2020-09-07T08:34:44Z")

</div>

@V88_Google The A1 column is the source of Unique Function in sheet Form Data 2 that i use to calculate all my needed information. So if there are blank columns in between the row, the Unique Function will also show the blank column on the Form Data 2 sheet and mess up the entire calculation. I think can’t use the “soft delete” method.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 7, 2020, 12:03pm UTC](https://community.glideapps.com/t/delete-entire-row/15394/4 "2020-09-07T12:03:06Z")

</div>

Not sure how you are handling “deletes” now, but deleting a row is part of the edit function. This will clear the entire row but not physically remove it. This shouldn’t be a problem because glide ignores empty rows. If you are using a unique formula for another sheet, that also ignores empty rows.

[https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/adding-editing-and-deleting#deleting](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/adding-editing-and-deleting#deleting)

---

<div class="post-metadata">

**Author:** ![DariusGiovanni](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@DariusGiovanni](https://community.glideapps.com/u/DariusGiovanni)\
**Post date:** [September 8, 2020, 2:15am UTC](https://community.glideapps.com/t/delete-entire-row/15394/5 "2020-09-08T02:15:47Z")

</div>

Thanks for the reply, i have found the solution for my problem. The Unique function ignores the blank row however we need to put the Filter function inside in order the formula to works. Thanks for the enlightenment.

---

<div class="post-metadata">

**Author:** ![everys](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/everys/32/10724_2.png) [@everys](https://community.glideapps.com/u/everys)\
**Post date:** [September 8, 2020, 3:41am UTC](https://community.glideapps.com/t/delete-entire-row/15394/6 "2020-09-08T03:41:24Z")

</div>

not a real delete, but “marked as deleted” and filtered out might be a dirty option to try, well, if you still got so many data rows left.

---

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [September 8, 2020, 10:34pm UTC](https://community.glideapps.com/t/delete-entire-row/15394/7 "2020-09-08T22:34:40Z")

</div>

That’s a good idea.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 4, 2024, 2:19pm UTC](https://community.glideapps.com/t/delete-entire-row/15394/8 "2024-02-04T14:19:09Z")

</div>


