@Lucas_Pires great that it worked. Until we try these things out of necessity we don’t really know, so we’ll done you
2 Likes
@Rosewebstudio @ThinhDinh Thanks Jason and Thịnh! Exactly that! We’d never discover it till we really need it
2 Likes
I submitted last week 2 templates which they already have this feature 
waiting for Glide to approve’em
there is view problems with set columns action:
- you need to clear each row in each column separately. this takes huge amount of time to code, and a very long time for glide to execute it.
- if you made a mistake setting columns you have to erase the starting element and do everything from the scratch because glide for some reasons remembers erased settings and run them together with edited ones.
- erasing values manually or by script directly in google sheets it won’t affect glide app right-away and if you trying to clear links to pictures it will not affect App at all until you reload that App.
- you have to create relation columns for each row in that column… thats sucks!
so it would be great to have an option to clear a whole column or even better one, to clear specific range.
i know, but i was creating tic tac game, and erasing links to glide images with a script was not effecting App screen, only when i did that with action it works, but takes very long time to see result in google sheet from that action.
Hola @Lucas_Pires
May you explain me better your solution because of I can’t understand it yet?
I have months “literally” look for a real way or trick with no success.
What I know so far is:
1- If you are using user specific columns, no script will be useful because that data doesn’t live in GS
2- If you use a Set Column action (to Clear Value or Write), this action will be done to one row only.
Although you can use a relation into Set Column action (Row field) the relation must be simple therefore, the problem still happens.
Instead, if Glide lets to use multiple relations the solution is almost done and we will be happier in 2021 but it’s not the case so far 
3- I discovered a risky trick to erase all value associated to USC time ago: if you modify some values belonging to RowID (2-3 characters), the row’s data is deleted and it’s perfect but the same data is deleted to all users connected to APP at the same time and it’s a little chaos!
Let me compare your idea with mine in order to get a happy 2021 
Thanks bro.
Saludos!
2 Likes
i know all that, my quest is to clear whole column in one shot, not row by row… it takes forever and is giving confusing results on user screen until is finished
1 Like
Here’s a game that does what you want, I don’t have time to finish it up but the script is written to clear the column after game is over. You can have and use as you see fit.
look at the script written, it should be exactly what you need. The game works I just have to build for unique sign on for 2 players on 2 different devices. If anyone wants to finish and use have at it. It only needs a couple of hours of love to finish up.
2 Likes
- Yes
- Agree, we’d be happier with this solution. But not the case yet.
- What I did to delete Row ID column, I didn’t feel any change in my app. Actually I deleted it and create a Unique Key column because I still needed a UK column.
1 Like
Uzo is your app going to be a pro app?
but you have to sign in to play, my game you dont need to!
try it… go to “tic tac” tab without sign in
The sign in is for user specific. the script that clears the column doesnt care if you sign in, it has a trigger that identifies a win.
Will it be a pro app? This will make it very simple if it is.
for sign in users i dont have any problem do any hocus pocus ! lol
1 Like
Are you trying to do something like this?
1 Like
yes, but for not sign in users
If you have a pro app this takes 5 seconds to setup
yes i have pro, remember, i know how to do that for sign in users!