# How to delete multiple rows **URL:** \ **Category:** Ask for Help\ **Created:** [September 17, 2024, 6:19pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451 "2024-09-17T18:19:36Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 17, 2024, 6:19pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/1 "2024-09-17T18:19:36Z")
I have main table with all my rows. I am creating a second table to list delete rows. I am using a text field to insert a number of rowids spearated by a single space. I want to delete these rowIDs from the main table. Is this possible or do I need to create a working table to split the rowids on to individual rows and then create a relation to the main table ? ---
**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 17, 2024, 6:45pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/2 "2024-09-17T18:45:17Z")
Use the relation approach. You can delete multiple rows through a relation or query. You don’t need a separate working table to split into separate rows. Just use a Split Text column to create an array, and then relation that uses that array. Then delete through the relation. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 17, 2024, 7:20pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/3 "2024-09-17T19:20:21Z")
… can’t figure it out, help pls. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af6c41901457746e9917fff914149d0a78f85e79.png) This is my main table, the 3 rowid highlighted are the ones I want to delete ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6e309879e636b16352959af994c4a368e03dcda.png) this table is what decides what needs to be deleted. I place a list of rowIDs in the rowid\_delete field. I want to delete rows in the main table that have these rowIDs using a button press ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [September 17, 2024, 8:16pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/4 "2024-09-17T20:16:44Z")
https://www.loom.com/embed/42dc438723a1431e88a4ab5270be45ae?sid=fcb3a5c6-8670-440f-a454-89f2929305dc If you need to delete all IDs from all rows with coma separated list, so just create Joined list column in User row then create split column from above and finally create multiple relation to be able to deleting all rows with listed Row IDs ---
**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 17, 2024, 8:44pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/5 "2024-09-17T20:44:25Z")
Create a Split Text column in your delete table with space as the delimiter. This will create an array of row IDs. Use that split array to create a Relation. Point your delete action to that relation. That should be it. Basically what @slscustom.ru showed in his video, but you are using space instead of comma as a delimiter in your Split Text column. ---
**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\ **Post date:** [September 17, 2024, 9:26pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/6 "2024-09-17T21:26:43Z")
Jeff/Slscustom, Thanks. this works perfectly. ---
**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:** [September 24, 2024, 9:27pm UTC](https://community.glideapps.com/t/how-to-delete-multiple-rows/76451/7 "2024-09-24T21:27:08Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.