🔄 Bulk clear, edit, restore and delete columns plus Undo action

[Darren_Murphy]

@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

[Uzo]

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.

[byhazellim]

How does this work please? I am looking to clear an entire column with an action

[Uzo]

JSON magic! Complicated… only for advanced users

[byhazellim]

@Uzo

plicated… only for advanced user

Is there a solution for clearing an entire column?

[Uzo]

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.

[Darren_Murphy]

@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

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…

[byhazellim]

I have no idea how, but Jeff’s solution works! Thank you Darren

[Darren_Murphy]

Jeff is very clever

I’ve used several variations of the technique he described in that thread in multiple Apps.