# š Set Column Action: Alter a DIFFERENT SHEET'S VALUES!
**URL:** https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342
**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:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 13, 2020, 2:31am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/1 "2020-11-13T02:31:33Z")
# š
Not 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:  [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)
#### Post date: [November 13, 2020, 2:34am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/2 "2020-11-13T02:34:15Z")
WHAAAAA?!
# HOW DID I MISS THIS?!
## AMAZING
[All these Glide updates are amazing!!!](https://www.youtube.com/watch?v=dQw4w9WgXcQ)
7 people got rickrolled š
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2020, 3:44am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/3 "2020-11-13T03:44:57Z")
Agree. I just had a use case just this morning. Previously I was not able to do this in forms because thereās no way to know what specific record the user is viewing, but here we are.
Instant draft picks for a Fantasy app, here we go!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 13, 2020, 3:54am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/4 "2020-11-13T03:54:42Z")
If I could give this 10 likes I would. AMAZING work!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2020, 4:06am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/5 "2020-11-13T04:06:36Z")
Love the instantaneous of it, thanks for sharing your trick as always Bob!
Iām sure Jesus will do a testimonial post of this app in the coming weeks š
---
### Author:  [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [November 13, 2020, 9:41am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/6 "2020-11-13T09:41:03Z")
Hey @Robert_Petitto & @ThinhDinh, great work you guys have done, really really cool stuff. These new features are so great. I have an issue with a chat that Iām creating, and I was hoping you guys could give me a hand, cus I think that the āset columnā action could help me solve the problem, hereās a small video with the issue I have. Thank you so much in advance
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2020, 11:49am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/7 "2020-11-13T11:49:17Z")
Hi Pablo.
You can have a setup like this to make it work two ways.
Create a template column in your chat sheet, joining the two emails, letās call it āEmailsā.
So you would have something like āemail1@gmail.com,email2@gmail.comā.
Then in the same sheet create a split text column, letās call it āEmail Splitā, split the above template by the comma so you would have an array of 2 emails.
Back to your users sheet, create a relation matching the email column with the email split column in Chats sheet.
In your users sheet, create a joined list column on the relation above, returning the āEmailsā column in Chat sheet.
In your conditional visibility for the item, hide when the joined list column contains the āscreen emailā.
---
### Author:  [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [November 13, 2020, 11:51am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/8 "2020-11-13T11:51:34Z")
Thank you so much @ThinhDinh, Iāll give it a try and let you know how it works!!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2020, 11:53am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/9 "2020-11-13T11:53:47Z")
Furthermore, to link straight to the chat, I would add the things below.
In the users sheet, create a āEmail 1ā template joining the signed in userās email and the email on each row, so we have:
[email1@gmail.com](mailto:email1@gmail.com),email2@gmail.com
Then an āEmail 2ā template but backwards so
[email2@gmail.com](mailto:email2@gmail.com),email1@gmail.com
Then two multiple relations (solely for inline list displaying purpose) from those templates to the emails column I mentioned in the column above, in the Chats sheet.
Display the two relations in two inline lists, it will show up one only anyway, as only one of the two would match, if thereās a chat already created.
---
### Author:  [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)
#### Post date: [November 13, 2020, 12:25pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/10 "2020-11-13T12:25:28Z")
So in this case only one to one only relation?
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 13, 2020, 1:19pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/11 "2020-11-13T13:19:45Z")
Great tip @Robert_Petitto, yesterday I tested this feature trying to find a way to clear a whole column (vĆa **Clear Column** parameter) but didnāt see the capability to use relations here.
But now, I found out that **only Single Relations** can be used into Set Column Action and Iām wondering WHY?
The perfect use case could be that: clear/write values belonging a Column ruled by a Multiple Relation
If we can use Multiple Relations here this wil be more that a killer solutionā¦ it will be a serial killer! š
Who could help or explain us this singular restriction with Multiple Relations: @Mark @Antonio?
Thanks in advanceā¦
Saludos y feliz dĆa!
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [November 13, 2020, 6:07pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/12 "2020-11-13T18:07:52Z")
## Simply Fantastic @Robert_Petitto š„
---
### Author:  [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)
#### Post date: [November 13, 2020, 8:54pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/13 "2020-11-13T20:54:30Z")
works great @ThinhDinh, thanks again for your help!! Really appreciate it.
@Amal this will help you too!
---
### Author:  [@Amal](https://community.glideapps.com/u/Amal)
#### Post date: [November 13, 2020, 9:25pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/14 "2020-11-13T21:25:48Z")
Thanks @PabloMFalero @ThinhDinh gonna try now.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 13, 2020, 10:36pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/15 "2020-11-13T22:36:40Z")
My pleasure to help. Do let me know if you have more questions š
---
### Author:  [@Amal](https://community.glideapps.com/u/Amal)
#### Post date: [November 14, 2020, 6:47am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/16 "2020-11-14T06:47:55Z")
Got it working woohooooo
---
### Author:  [@Amal](https://community.glideapps.com/u/Amal)
#### Post date: [November 14, 2020, 7:34am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/17 "2020-11-14T07:34:47Z")
https://player.vimeo.com/video/479216606
---
### Author:  [@Amal](https://community.glideapps.com/u/Amal)
#### Post date: [November 14, 2020, 7:39am UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/18 "2020-11-14T07:39:41Z")
Thanks @ThinhDinh its working great. Now the only thing left to do, is to find a way to notify user in-app.
https://player.vimeo.com/video/479216606
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 16, 2020, 4:34pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/19 "2020-11-16T16:34:37Z")
> [@Robert\_Petitto](#):
>
> Not 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!
What about incrementing a column in another sheet? Can you think of a way to do that?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [November 16, 2020, 4:46pm UTC](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342/20 "2020-11-16T16:46:04Z")
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.
[Next page](https://community.glideapps.com/t/set-column-action-alter-a-different-sheets-values/18342.md?page=2)