# Ask : Delete Multiple Row with Certain Condtition

**URL:** https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093
**Category:** Ask for Help
**Created:** [November 24, 2023, 4:10am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093 "2023-11-24T04:10:59Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 24, 2023, 4:10am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/1 "2023-11-24T04:10:59Z")

</div>

Hi, i have 18k rows of data, but i want to clean some by delete multiple rows. with certain condition, how to do that?

---

<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: [November 24, 2023, 4:12am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/2 "2023-11-24T04:12:56Z")

</div>

Create a multiple relation or query column that matches the rows you want to delete, and then use a Delete Row action through that relation.

---

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 24, 2023, 4:15am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/3 "2023-11-24T04:15:34Z")

</div>

can you show me the example please ?  
delete through component ?

---

<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: [November 24, 2023, 4:46am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/4 "2023-11-24T04:46:05Z")

</div>

Create a button, set the action to Delete Row, and point it to the relation or query.

> **[Delete Row](https://www.glideapps.com/docs/automation/actions/delete-row)**
>
> Delete a row of data from a table.

---

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 24, 2023, 4:50am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/5 "2023-11-24T04:50:23Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8fb775f6283c10c8a9a333d32ea465a2e2d9e65a.png)  
did you mean it like this ?

---

<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: [November 24, 2023, 4:57am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/6 "2023-11-24T04:57:02Z")

</div>

Yes, that is correct.

---

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 24, 2023, 4:59am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/7 "2023-11-24T04:59:06Z")

</div>

Thanks Jeff, and also thanks @Darren_Murphy

---

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 28, 2023, 10:29am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/8 "2023-11-28T10:29:06Z")

</div>

i accidentally publish

and my user accidentally clicked on it and deleted 15k row of data and cost me 15k of update, can this be restore ?

---

<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: [November 28, 2023, 3:25pm UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/9 "2023-11-28T15:25:35Z")

</div>

You can contact Glide support, but I highly doubt that they could restore anything.

---

<div class="post-metadata">

### Author: ![Martinus\_Goh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinus_goh/32/53576_2.png) [@Martinus\_Goh](https://community.glideapps.com/u/Martinus_Goh)
#### Post date: [November 29, 2023, 6:16am UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/10 "2023-11-29T06:16:10Z")

</div>

yeah, that doesnt do any help  
so i’ll just import back the latest database i backup.

but did you know anything about the updates count and Pay-as-you-go billing update?

for know my updates count is 19k/10k , that i already overreach the limit usage around 9k counts, what if i set pay-as-you-go right now, does it billed me from usage after 19k (start billing 10$ / next 1000 updates)or, count from 10k (already charge extra 90$ and so on) ?

---

<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: [November 29, 2023, 12:34pm UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/11 "2023-11-29T12:34:26Z")

</div>

I’m honestly not sure. I would guess that your would be charged $90.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [December 6, 2023, 12:34pm UTC](https://community.glideapps.com/t/ask-delete-multiple-row-with-certain-condtition/68093/12 "2023-12-06T12:34:36Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
