Ways to use the Set Column action

Can folks explain to me case uses of Set Column. Trying to understand what it does/how it is used before I go and monkey up things in my app. Thank you.

1 Like

My most immediate use is to clear all columns I make for a form-esque experience after submission using add row.

2 Likes

but if you write the data to these columns and then clear them, don’t you lose that data?

The values he is clearing are temporary. They are entry components filled by the user that populate user specific columns in one sheet. Then the Add Row action takes those values and writes them to a different sheet. Once the row is added in the second sheet, the user specific values in the first sheet can be cleared. It’s similar to a form button, where every time you open the form, the entry components are empty. It doesn’t save the values from your last form submission.

5 Likes

Thats really cool. Thanks! Would love to hear other case uses if anyone wants to share

2 Likes

True Jeff, I make that solely for the ability to block duplicates.

2 Likes

I’m using it to set time stamps in user specific columns to track when fields were manipulated.

2 Likes

@Robert_Petitto Yes, I saw you recent video for the store app: that to me was some sweet next level Jedi Master magic. Will come in handy when I try my hand at a store app.

Sweet, this solved that issue I was having with the individual start time for the player energy bar. This way teachers don’t have to get into the spreadsheet to revive a player from the dead. Going to try some ITE or Template to see I can filter out the non active class sections users and apply it to just the active class. Nice nice- just in the nick of time!

I use it in the same way that @ThinhDinh & @Jeff_Hager described, but I also use it to increment/decrement counters (which I learned how to do from this post)

Users of my app are given “credits”. Every time they submit a form, I need to decrease their credit count. And conversely, if they delete a submission (which I allow them to do, within a certain time window), then I need to return that credit to them. They can also have different types of credits - free credits and paid credits - and I need to keep track of both. For example, if they submit using a free credit, then I need to “remember” that, just in case they come back later and delete the submission. It’s all a little fiddly, but thanks to the new compound actions feature is fully achievable without having to resort to any spreadsheet tomfoolery.

3 Likes

That is super helpful both in information and Glide power. Thanks Darren.

The Set Columns Action just clears one cell(the logged in user) when I try it. Is there a way to set it so that it clears the entire column top to bottom beside linking a single value column to it and using the single value column?

As of now I don’t think there’s a native way to do so.

1 Like

Ok. Tomorrow I will see if I can use single value and some ITE to accomplish it.

1 Like