# šŸ”„ Bulk clear, edit, restore and delete columns plus Undo action **URL:** \ **Category:** Project Showcase\ **Created:** [March 22, 2023, 10:15pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546 "2023-03-22T22:15:58Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [March 23, 2023, 5:30am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/21 "2023-03-23T05:30:05Z")
what kind of java did you use exactly I didnā€™t get it ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 23, 2023, 5:33am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/22 "2023-03-23T05:33:13Z")
Glide Java column. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [March 23, 2023, 5:43am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/23 "2023-03-23T05:43:48Z")
But java script column doesnā€™t edit any column ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 23, 2023, 5:47am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/24 "2023-03-23T05:47:47Z")
It edits itself šŸ˜‰ ---
**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:** [March 23, 2023, 7:33am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/25 "2023-03-23T07:33:05Z")
> [@Uzo](#): > > Glide columns, using Java Side note: [Java](https://en.wikipedia.org/wiki/Java_(programming_language)) and [JavaScript](https://en.wikipedia.org/wiki/JavaScript) are not the same thing. They are both programming languages, but are vastly different. Glide supports a JavaScript column. It does not support Java. ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [March 23, 2023, 9:16am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/26 "2023-03-23T09:16:57Z")
Yes thatā€™s correct and thatā€™s why I corrected him and still I donā€™t understand the coding behind it with using native glide features ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 23, 2023, 10:19am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/27 "2023-03-23T10:19:57Z")
What is this sorcery? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [March 23, 2023, 10:27am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/28 "2023-03-23T10:27:15Z")
Iā€™d recommend removing the built-in filter for the collection as it doesnā€™t work on a filtered list. Youā€™d likely have to build out a custom filter/choice component. Would be interested to see how this works ā€” maybe a tutorial video on how itā€™s set up? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 23, 2023, 12:55pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/29 "2023-03-23T12:55:08Z")
> [@kyleheney](#): > > Iā€™d recommend removing the built-in filter for the collection as it doesnā€™t work It works well. There is no need to remove a filter. It will only not work when you clear the category column because it is based on that column. > [@Darren\_Murphy](#): > > Side note: [Java](https://en.wikipedia.org/wiki/Java_(programming_language)) and [JavaScript](https://en.wikipedia.org/wiki/JavaScript) are not the same thing. Yes, Iā€™m aware of that. The Glide column is for a sandboxed JavaScriptā€¦ I did not see the reason to be so precise about that šŸ˜‰ > [@Robert\_Petitto](#): > > What is this sorcery? You made my dayā€¦ love that comment šŸ¤£ It feels like Magicā€¦ especially the Undo button. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [March 23, 2023, 11:44pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/31 "2023-03-23T23:44:14Z")
> [@Uzo](#): > > It works well. There is no need to remove a filter. It will only not work when you clear the category column because it is based on that column. If you filter, bulk change the quantities, then unfilter, all items have their quantities changed to the new value. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 23, 2023, 11:50pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/32 "2023-03-23T23:50:04Z")
Yes, did you expect a different result? When you use the filter, it will not delete items from the list; it just hides them from viewā€¦ so all the actions will affect hidden objectsā€¦ You can delete the items or edit them individually. I can create a special action to edit only filtered itemsā€¦ then yesā€¦ I would need a custom filter, not a native one. The goal of this App was to bulk edit the whole columnā€¦ if I have a paid requestā€¦ I can keep adding more functions and create a monster system šŸ˜‰ ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [March 24, 2023, 12:49am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/33 "2023-03-24T00:49:14Z")
Yes, the expected result is that only the visible items should be modified ā€” this is why I suggested a custom filter. Itā€™s a cool concept, but I wouldnā€™t include the native filter as it clears rows that are out of view when the filter is applied. Just a suggestion! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 12:58am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/34 "2023-03-24T00:58:58Z")
Hmmā€¦ that would not be my intuitive expectationā€¦ when I filter the list and do the actionā€¦ I would expect all items, including hidden ones will be affected by the actionā€¦ unless the purpose of filtering is to exclude these items from the actionā€¦ The main goal of this App is to show the possibility of bulk edits on the back endā€¦ I know there are many coll functions I can add to this App, and I will when I have motivation and time šŸ˜‰ ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [March 24, 2023, 1:09am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/35 "2023-03-24T01:09:35Z")
My concern would be someone filtering the list, navigating away, then coming back and forgetting that they filtered the list. They do a bulk operation and it clears/changes the values of every column in the table. Youā€™ve only got 10 or so rows of data there, but if it was a real data set and it was filtered to show 100 of 10,000 records, I think the expectation of most would be that a bulk operation would only affect the items seen on screen at that time. Just my two cents. PS Iā€™d love to see how this is done and Iā€™m sure others would too. A video/explanation would be popular! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 1:15am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/36 "2023-03-24T01:15:24Z")
Yes, I agreeā€¦ BTW you can add more rowsā€¦ I have an App with unlimited rows, and I have this system there to bulk edit data from the back end, and I have conditions on what and how to edit it, but unfortunately, I canā€™t post it hereā€¦ they will ban me again šŸ˜‰ So for safety reasons, Iā€™m only posting the ā€œnativeā€ solutions, LOL. About the video/explanation thingā€¦ I donā€™t want to take away the glory from @Robert_Petitto. My job is to create new techniquesā€¦ šŸ˜œ ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 3:21am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/37 "2023-03-24T03:21:23Z")
I made your requestā€¦ now you have two filters, Custom and Nativeā€¦ Custom filters will affect editingā€¦ only visible items will changeā€¦ Enjoy! šŸ¤© > **[Bulk Editing and Restoring](https://bulk-editing.glide.page)** > > Bulk edit, clear or restore Glide columns. And I did some facelifts since there are so many visitors thereā€¦ I did not expect that, LOL. ---
**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:** [March 24, 2023, 12:21pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/38 "2023-03-24T12:21:02Z")
Each user have independent undo or it total for all users? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 12:21pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/39 "2023-03-24T12:21:58Z")
Independentā€¦ USCā€¦ (Glide updates: 0 Glide edits: 0 Glide syncs: 0) ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [March 24, 2023, 1:08pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/40 "2023-03-24T13:08:03Z")
> [@Uzo](#): > > (Glide updates: 0 Glide edits: 0 Glide syncs: 0) How is it possible? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 24, 2023, 1:38pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/41 "2023-03-24T13:38:54Z")
Non signed in users, editing USC columns [Previous page](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546.md?page=1) [Next page](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546.md?page=3)