# How to create button delete all rows at once

**URL:** https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832
**Category:** Ask for Help
**Created:** [December 19, 2023, 3:59am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832 "2023-12-19T03:59:43Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![bew\_wrc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bew_wrc/32/68014_2.png) [@bew\_wrc](https://community.glideapps.com/u/bew_wrc)
#### Post date: [December 19, 2023, 3:59am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/1 "2023-12-19T03:59:43Z")

</div>

How to create button delete all rows at once  
I want clear data in table by button in once click.

---

<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: [December 19, 2023, 4:05am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/2 "2023-12-19T04:05:32Z")

</div>

Create a Multiple Relation or Query column that matches all rows in the table, and use a Delete Row action via that relation/query.

---

<div class="post-metadata">

### Author: ![bew\_wrc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bew_wrc/32/68014_2.png) [@bew\_wrc](https://community.glideapps.com/u/bew_wrc)
#### Post date: [December 19, 2023, 4:28am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/3 "2023-12-19T04:28:11Z")

</div>

I,m beginer. How to Create a Multiple Relation or Query column

---

<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: [December 19, 2023, 4:45am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/4 "2023-12-19T04:45:52Z")

</div>

> **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting, and limits.

> **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)**
>
> Create relationships and link rows together.

---

<div class="post-metadata">

### Author: ![bew\_wrc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bew_wrc/32/68014_2.png) [@bew\_wrc](https://community.glideapps.com/u/bew_wrc)
#### Post date: [December 19, 2023, 4:48am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/5 "2023-12-19T04:48:43Z")

</div>

I have more questions.

I have table ‘data’ in table has 2 column is name , number and I have form element.  
When I input name = ‘mom’ number = ‘1,2,3’  
I want split and loop insert table

name = ‘mom’  
number = ‘1’

name = ‘mom’  
number = ‘2’

name = ‘mom’  
number = ‘3’

Can I do it?

---

<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: [December 19, 2023, 5:02am UTC](https://community.glideapps.com/t/how-to-create-button-delete-all-rows-at-once/68832/6 "2023-12-19T05:02:06Z")

</div>

I saw that you asked that question in another thread. It’s possible, but complicated. I don’t have time to provide an answer right now. Somebody else might help.