# 🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES! **URL:** \ **Category:** Project Showcase\ **Created:** [November 13, 2020, 2:31am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342 "2020-11-13T02:31:33Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [November 16, 2020, 5:13pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/21 "2020-11-16T17:13:31Z")
Thank you so much @Robert_Petitto and @ThinhDinh! Your tips help with this Login screen with username and password ---
**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:** [November 16, 2020, 5:34pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/22 "2020-11-16T17:34:32Z")
> [@Robert\_Petitto](#): > > That’s what I show in my video. Currently the increment action doesn’t reference other sheets like the set column does so you’ll have to build the increment columns like I show in the video. Got it!! I did watch the video when you first posted, but because I didn’t have an immediate use case, it didn’t really sink in. This is _exactly_ what I now need. Thanks! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 16, 2020, 10:02pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/23 "2020-11-16T22:02:08Z")
So clever! ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [November 17, 2020, 5:05am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/24 "2020-11-17T05:05:16Z")
100% behind you on this. Celebrated prematurely. This could unlock quite a few things. Did you strictly test clearing columns? I didn’t have much fun with relations and when combined with another action (e.g. set columns) things went a little nuts. For some reason the action is always wanting to set the first row and replaces the existing values there. ![action 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/0757233bfcb38dd8a57211783c011809b759bc88.png) (continued) ![action 2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52cd22c1309fbb75af919b1242d1a832ada9c8b9.png) **Edit:** better visual ![Group 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/c/9c6a2006f2775ecd315b809d66b5470ca3ddd6fd.png) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [November 17, 2020, 5:07am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/25 "2020-11-17T05:07:06Z")
Awesome @Rasha! ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 17, 2020, 6:34pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/26 "2020-11-17T18:34:19Z")
> [@new\_button Actions! high\_voltagehigh\_voltagehigh\_voltage](https://community.glideapps.com/t/actions/18026/253): > > Guys. I’m a little late to the game with the new compound Actions due to pressure to finish another app. Started taking a proper look today. I’m experiencing compound actions relating to updating a column not always completing. Is this still a known issue? Thanks. Maybe I just stumbled on this too? ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [November 17, 2020, 8:36pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/27 "2020-11-17T20:36:04Z")
@V88 Could be. It seemed to be _completing_ OK but adding values in the wrong place, always defaulting to the 1st row (2). ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 17, 2020, 9:24pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/28 "2020-11-17T21:24:00Z")
Yup. That’s exactly it. When the column in question is accessed via a relation by any chance? ---
**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\ **Post date:** [November 17, 2020, 9:48pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/29 "2020-11-17T21:48:42Z")
@V88 precisely. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 17, 2020, 10:14pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/30 "2020-11-17T22:14:21Z")
@Mark do you have this under investigation already? ---
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [November 18, 2020, 11:48am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/31 "2020-11-18T11:48:32Z")
Hey @Robert_Petitto ! I have a question: Does the “Set Column-Clear value” work if the column is user-specific? In my case, the selected item quantity (“user-specific”) first disappears from the sheet, but then reappears (the values to be cleared remain in the column). Text from Google translator, I apologize for possible errors ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 18, 2020, 12:36pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/32 "2020-11-18T12:36:25Z")
Yes, it should work. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [November 18, 2020, 1:26pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/33 "2020-11-18T13:26:00Z")
This is the perfect feature which can enable a choice component with Images ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [November 18, 2020, 2:27pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/34 "2020-11-18T14:27:16Z")
So true! ---
**Author:** ![Vladimir\_Zambakhidze](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladimir_zambakhidze/32/13882_2.png) [@Vladimir\_Zambakhidze](https://community.glideapps.com/u/Vladimir_Zambakhidze)\ **Post date:** [November 18, 2020, 2:36pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/35 "2020-11-18T14:36:08Z")
For some unknown reason, my data in the selected column is not cleared. Apparently, at first they are cleared (goods disappear from the Inline list), but then reappear ---
**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:** [November 18, 2020, 5:23pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/36 "2020-11-18T17:23:40Z")
> [@Vladimir\_Zambakhidze](#): > > Does the “Set Column-Clear value” work if the column is user-specific? I can confirm that this works, as I have a custom action that does _exactly_ this. ![Screen Shot 2020-11-19 at 1.21.21 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/af639830f9cf67bd8da0ede0cb57d9d614d36ddc.jpeg) The 4 columns being cleared in this example are all user specific columns. ---
**Author:** ![Valdir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valdir/32/37658_2.png) [@Valdir](https://community.glideapps.com/u/Valdir)\ **Post date:** [November 18, 2020, 10:36pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/37 "2020-11-18T22:36:38Z")
Does “Clear Value” only work on the first line? My Delivery products have different IDs and when the customer add to cart, increment the column by the product ID. I can only delete the line if the chosen product is the one that corresponds to the first ID. What do you suggest doing? ![Image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/4278638b6bc573a93b467b70dbd84c8ebd1cf410.png) ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 19, 2020, 8:37am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/38 "2020-11-19T08:37:46Z")
@Mark are you able to chime in on this one please? For clarity I think we are seeing the Update Columns action always updating the first row in the sheet when the table is accessed via a relation. I think that @Rasha is reporting the same behaviour. It seems totally repeatable. If you already have it logged then apologies. ---
**Author:** ![saphier](https://avatars.discourse-cdn.com/v4/letter/s/f08c70/32.png) [@saphier](https://community.glideapps.com/u/saphier)\ **Post date:** [November 19, 2020, 7:01pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/39 "2020-11-19T19:01:04Z")
Hey guys, am I missing something here? I look at my set columns action and my relation sheets aren’t available as a selection. Any tips on what to look for to enable it? ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [November 19, 2020, 7:24pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/40 "2020-11-19T19:24:52Z")
Is it a Simple relation in the tab you are pullings values ? [Previous page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=1) [Next page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=3)