# 🔄 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:** 11\ **Page:** 3
**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 28, 2023, 3:35am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/42 "2023-03-28T03:35:45Z")
> [@Uzo](#): > > 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 😉 Okay, then I’ll give you a reason to be precise. Continuing to incorrectly refer to the JavaScript column as a Java column misleads people and creates confusion. Less confusion == more happy Gliders 🙂 ---
**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 28, 2023, 3:58am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/43 "2023-03-28T03:58:14Z")
Sure… but there is no other option in Glide than a JavaScript column… so… I thought it was clear 😉 But… I will try to be more precise next time. ---
**Author:** ![byhazellim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/byhazellim/32/55170_2.png) [@byhazellim](https://community.glideapps.com/u/byhazellim)\ **Post date:** [May 4, 2023, 12:48am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/44 "2023-05-04T00:48:15Z")
How does this work please? I am looking to clear an entire column with an action 🙂 ---
**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:** [May 4, 2023, 12:50am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/45 "2023-05-04T00:50:48Z")
JSON magic! 😉 Complicated… only for advanced users ---
**Author:** ![byhazellim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/byhazellim/32/55170_2.png) [@byhazellim](https://community.glideapps.com/u/byhazellim)\ **Post date:** [May 4, 2023, 12:55am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/46 "2023-05-04T00:55:21Z")
> [@Uzo](#): > > plicated… only for advanced user Is there a solution for clearing an entire 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:** [May 4, 2023, 12:58am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/47 "2023-05-04T00:58:50Z")
Using the native Glide functions… no, you can only make a mark not visible in the help column… but to make bulk changes to the static data… only using JSON and Java tricks… if your data is in Google Sheets… you can also use google script to do that. ---
**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:** [May 4, 2023, 2:28am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/48 "2023-05-04T02:28:45Z")
> [@byhazellim](#): > > Is there a solution for clearing an entire column? No native solution, no. But you can get the effect by using a bit of smoke and mirrors. Take a look at the below: > [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211): > > There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n… ---
**Author:** ![byhazellim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/byhazellim/32/55170_2.png) [@byhazellim](https://community.glideapps.com/u/byhazellim)\ **Post date:** [May 4, 2023, 11:33am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/49 "2023-05-04T11:33:35Z")
I have no idea how, but Jeff’s solution works! Thank you Darren ---
**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:** [May 4, 2023, 11:43am UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/50 "2023-05-04T11:43:26Z")
Jeff is very clever 😉 I’ve used several variations of the technique he described in that thread in multiple Apps. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 7, 2023, 5:46pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/51 "2023-11-07T17:46:25Z")
3 posts were split to a new topic: [Bulk edit to clear values?](https://community.glideapps.com/t/bulk-edit-to-clear-values/67596) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [November 7, 2023, 5:46pm UTC](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546/52 "2023-11-07T17:46:42Z")
[Previous page](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546.md?page=2)