# 🚀 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:** 3
**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, 8:22pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/41 "2020-11-19T20:22:53Z")
Just a simple relation, no look up. Essentially I want to put the current date in a field on another sheet. I’ve added a relation column in the screen’s sheet, and a look up value but no luck. ☹ ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 19, 2020, 10:13pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/42 "2020-11-19T22:13:09Z")
It doesn’t have anything to do with the lookup column, make sure you are adding it on the right screen, that sources from the sheet you added the relationship. ---
**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, 10:37pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/43 "2020-11-19T22:37:39Z")
Thanks! Figured it out with a sample app after your messages! It’s because it doesn’t show up when the relation is set to match multiple relations (which makes sense, the function won’t know which row to set). ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 19, 2020, 11:22pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/44 "2020-11-19T23:22:41Z")
Actually when I saw the wording I thought it was clearing the whole column haha. Hopefully the option will be there in near future. ---
**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 20, 2020, 9:03am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/45 "2020-11-20T09:03:30Z")
Has anybody heard anything further in respect of this issue? Specifically: _“Update Columns action always updating the first row in the sheet when the table is accessed via a relation.”_ Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 20, 2020, 9:26am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/46 "2020-11-20T09:26:46Z")
> [@V88](#): > > Has anybody heard anything further in respect of this issue? Specifically: > > _“Update Columns action always updating the first row in the sheet when the table is accessed via a relation.”_ I do this (update columns in another sheet via a relation), and it generally seems to work. ![Screen Shot 2020-11-20 at 5.22.27 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/4029599a97d1acfd9d7d135dcec1baa8e37cbdd6.png) You can’t see the column that’s being updated, as it’s lower down in the list, so you’ll have to take my word that it’s there 😁 Although… I have observed one instance where the desired row wasn’t updated (the first row wasn’t touched either). But I haven’t been able to repeat that, so not sure what happened. I’m guessing that there is a very specific set of preconditions that causes the behaviour that you’re observing, but have no idea what they might be. Sorry I can’t be more helpful… ---
**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 20, 2020, 9:38am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/47 "2020-11-20T09:38:32Z")
Ok. Super useful. Appreciated. I’ll test my end again later today. ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [November 23, 2020, 12:03pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/48 "2020-11-23T12:03:10Z")
I can’t seem to get this to work. I think it worked at some point (I might be mistaken). > **[visual choice](https://famous-square-3215.glideapp.io/)** I am trying to do what @Robert_Petitto did where the list can be picked visually. In my case in challenges, if you pick a challenge, you would be able to click one of the two buttons (they do the same but I was trying two different ways) ---
**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 23, 2020, 1:08pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/49 "2020-11-23T13:08:08Z")
@Sandro_Brito…try this: > **[Glide Experiments · Glide · Create Apps from Google Sheets](https://www.loom.com/share/f37093d7d990463da8de41f631c8b675)** > > Check out a video I made via Loom ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [November 23, 2020, 2:32pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/50 "2020-11-23T14:32:34Z")
Thank you Robert. I will try to implement this later ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [November 23, 2020, 6:06pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/51 "2020-11-23T18:06:39Z")
In your case you’re setting the choice per user on the profile sheet. In my case, each user will have many choices as it’s set per challenge. Does that mean that instead of the email address I have to use the challenge ID to create a relationship? ---
**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 23, 2020, 9:04pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/52 "2020-11-23T21:04:21Z")
How I am doing it in a different app is you would need to have one column per row that you’re allowing to select. So if you have an in line list of 15 challenges and you’re allowing them to select all of them, then you would need to have 15 columns in order to except those selections. Not the best development technique, but it gets the job done. ---
**Author:** ![Sandro\_Brito](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sandro_brito/32/552_2.png) [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)\ **Post date:** [November 24, 2020, 8:02am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/53 "2020-11-24T08:02:05Z")
Oh, unfortunately, that doesn’t work for me as each challenge is coming from another user. Thank you, I am sure I’ll use that in some other way. ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 7, 2020, 5:49pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/54 "2020-12-07T17:49:05Z")
Thank you @Robert_Petitto I’ve been struggling with how to change another column sheet till I found your post. I’ve implemented your trick to change a user-specific column when a user submits a form. It works fine but if I change to another user and then come back to the one who submitted the form the column value is lost. Any idea why does this happen? In fact, though it seems to change the column value (Button color has changed) the item row is blank ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6a29db770cda21557183f78ac77bcbeeecc14511.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd2dc4f30c60d40580a89c70209a3fcb6e1655ff.png) ---
**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:** [December 7, 2020, 7:25pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/55 "2020-12-07T19:25:21Z")
A user specific column is exactly that. It’s specific only to the user who filled it. If you need that column value to be visible to all users, then I wouldn’t use a user specific column. ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 7, 2020, 7:29pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/56 "2020-12-07T19:29:01Z")
I want to use that column to filter a list of events in a form to prevent a user can register twice. The button color changes only for the user who has registered ---
**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:** [December 7, 2020, 7:44pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/57 "2020-12-07T19:44:14Z")
Another option is to instead create a template of the user email and the event name/id in the event sheet and the form sheet. Then create a relation in the event sheet to link both templates together. Then you can show the button based on if the relation is empty or not. But back to your issue with the user specific column not showing a value after switching to another user and back to the original user again (I may have misread your issue)…does it show up if you refresh the browser? ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 7, 2020, 7:58pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/58 "2020-12-07T19:58:30Z")
Thanks for your quick response. > does it show up if you refresh the browser? No, it doesn’t . Actually this could be expected, as the item doesn’t save in the table. > … create a template of the user email and … Thanks for the idea. I’ll try it, though it may be difficult without a user-specific column as many users can register to the same event. Edit: The empty relation makes the job. Thanks again ---
**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:** [December 7, 2020, 8:34pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/59 "2020-12-07T20:34:00Z")
> [@profechef](#): > > though it may be difficult without a user-specific column as many users can register to the same event. I actually use that method quite often. The form submissions should already have the user emails submitted with the event id, so that will be easy to create. The template on the event sheet will just pull the email from the user profile. It doesn’t require any user specific columns, but the email will dynamically change based on the user that’s signed in. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/65b3c3999c0c9a59b5dfef7704cb52cd9de10b30.png) ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 8, 2020, 7:49am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/60 "2020-12-08T07:49:04Z")
Have you analyzed what happens when two users log in at the same time? I’m afraid the second user may change the column in database and then the first would see he is not registered in the event. [Previous page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=2) [Next page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=4)