🐟🥖🧺 Transpose Columns to an Inline List: The Miracle Method

[Robert_Petitto]

Ya…no good way to clear entire column. Been asking for this feature for years. Please vote:

Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations

Currently, the Action to “Set columns” only consider the current sheet or any single relations (to update a column in a single row). I’m trying to create a “bulk approval” process where the “set column” action could look at a multiple relation and update each corresponding row in that relation.

[Uzo]

Is anybody in Glide, even looking at these votes?

[biha]

ok voted

[Darren_Murphy]

@biha

But how to clear entire column after submitting the answer?

Use the API.

[Robert_Petitto]

@Darren_Murphy

Use the API.

This is the only way to this if your data lives in Glide Tables. However, majority of users are no coders. We need a native, no code solution for the 80%.

[Uzo]

It is not the only way…

[biha]

How @Uzo ?

[biha]

How to use API?

[Darren_Murphy]

[biha]

My gosh, mine was only PRO, call API is for business so sad.

[Uzo]

Visit my website…

[Darren_Murphy]

You can do the same thing with a webhook to Make.

[biha]

Another thing is my column is user-specific to be cleared. it is possible?
I think no API for that column

[Darren_Murphy]

No, you can’t change user specific columns via the API.
In that case, you need to use the multi-row reset trick.

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…