# Combo Actions For Set Columns Can Set Relationship Rows **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [December 11, 2020, 6:59am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697 "2020-12-11T06:59:23Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 11, 2020, 6:59am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/1 "2020-12-11T06:59:23Z")
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. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e89dfd62932714ffa47299aed84222c8472c701b.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cbe3d12242732ed7fb79e1f53e9218622ba4990.png) 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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 7:08am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/2 "2020-12-11T07:08:38Z")
That’s the same as this, yes? > [@rocket Set Column Action: Alter a DIFFERENT SHEET'S VALUES!](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342): > > heart_eyesNot only can you use the new “Set Column” action to edit a value within your sheet via button press, but now you can manipulate values in OTHER SHEETS as long as there’s a relation! This is SUPER powerful. In my demonstration below, I take an inline list of four items and turn them into buttons that can be used to track habits in a DIFFERENT SHEET that’s associated to the currently signed in user! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 11, 2020, 7:10am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/3 "2020-12-11T07:10:07Z")
When did he post that? Oh, wow. well then, removed. I literally watch none of the tutorials on this site. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 7:11am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/4 "2020-12-11T07:11:26Z")
About a month ago. But it’s an awesome feature, so it deserves a second post 😀 ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 11, 2020, 7:12am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/5 "2020-12-11T07:12:23Z")
Did you ever get that figured out for your app? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 7:22am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/6 "2020-12-11T07:22:24Z")
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. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 11, 2020, 7:28am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/7 "2020-12-11T07:28:13Z")
Understandable…I’m about to put this 2 player game up on the forums I think. Wanna give it a try? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [December 11, 2020, 10:22pm UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/8 "2020-12-11T22:22:27Z")
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. Saludos y feliz fin de semana! ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 12, 2020, 1:26am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/9 "2020-12-12T01:26:46Z")
One day soon, one day soon… ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 2:08am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/10 "2021-02-22T02:08:26Z")
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 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 22, 2021, 2:10am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/11 "2021-02-22T02:10:25Z")
I would recommend checking out this thread. Sounds very similar. > [@Reset the values...?](https://community.glideapps.com/t/reset-the-values/23181): > > The video explains it all… ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [February 22, 2021, 11:49am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/12 "2021-02-22T11:49:16Z")
I solved this problem, and it works well without scripts… I’m celebrating this 4 hours struggle with lots of beer 😉 ---
**Author:** ![studiomuscle](https://avatars.discourse-cdn.com/v4/letter/s/c2a13f/32.png) [@studiomuscle](https://community.glideapps.com/u/studiomuscle)\ **Post date:** [October 27, 2022, 6:43am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/13 "2022-10-27T06:43:45Z")
Does that video still exist? I am running into problems with the same use-case ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 27, 2022, 7:44am UTC](https://community.glideapps.com/t/combo-actions-for-set-columns-can-set-relationship-rows/19697/14 "2022-10-27T07:44:52Z")
This is all very old. It would be best if you create a new topic for your problem. Please try to describe it as clearly as possible.