So I ran into a dilemma today where I needed my actions to set columns on another page. Now we know that works with add rows, but what I didn’t know and I haven’t seen it before is that if you create a relationship between sheets you can now set columns oh those sheets. Here’s a image of what I’m talking about.
I am able to use a glide sheet to set actions on a google sheet because of the relation and it works great. Now maybe this isn’t new, but I have yet to see it in any other of my projects and up until right now all I have ever seen is set column to show current row.
But nonetheless its a great feature, I am able to finish my game with this function.
My brain was a bit fried after yesterday, so I’ve put it aside today and working on something else.
But I think when I go back to it I’ll just split it into separate screens. It’s not worth the trouble of messing around with any further.
Right @Drearystate but the problem is still the fact that any relation must be single and I don’t know the reason!!
The normal and old SQL clauses supports UPDATE Multiple Records to carry out it and this is what we are needing from weeks ago.
What Glide is doing so far with Set Columns (using a Single relation) is something like a SQL UPDATE Single Record and this ok but why we don’t go beyond and simplify many things to avoid Google scripts?.
Something like clear a shopping cart list or update an inventory (which have at least 10 items) using an unique/simple action through a multiple relation would be a smart/fast solution.
did you find a way to set multiple rows that mach relation? without using scripts… i really need that to checkout items from the cart… when i use scripts i takes time to apply changes, and items are still in the cart… user can still click them because glide see them as available until script will affect glide
