# How to change a column value of a sheet while being in another sheet
**URL:** https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035
**Category:** Ask for Help
**Created:** [May 21, 2021, 2:30am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035 "2021-05-21T02:30:41Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 2:30am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/1 "2021-05-21T02:30:41Z")
I am creating an online voting app, in which I have sheet "Online Voting"with the list of candidates and column for Votes. I have another sheet “Voters list” with a list of voters. I first show a tab connected to the “Voters list” sheet and ask user to enter a Voter ID. After checking if the Voter ID is present in the list, I navigate to another tab connected to Online Voting, where an inline list of candidates is shown, and when user clicks on a candidate, the vote column for the candidate is incremented. At the same time, I want to set a value in a column Voted? to true on the Voters list sheet for the voter. But for the action present in the Online Voting sheet, I am not able to refer to the column in the sheet “Voters list” in order to set a value. How can I do this?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 21, 2021, 2:59am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/2 "2021-05-21T02:59:04Z")
You should be able to use a relation to connect the two sheets and set the value through the set column module.
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 3:12am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/3 "2021-05-21T03:12:51Z")
I created a relation, but that relation does not appear in the Set columns action. How do I access the value on another sheet using the Set columns action?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 21, 2021, 3:15am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/4 "2021-05-21T03:15:30Z")
Is it a single or a multiple relation?
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 3:16am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/5 "2021-05-21T03:16:52Z")
I have created it as a multiple relation, but it will work as a single relation also, because ideally there should be only one voter for one voter ID.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 21, 2021, 3:18am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/6 "2021-05-21T03:18:27Z")
Can you change it to a single relation and check if you can find it in the set column module?
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 3:20am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/7 "2021-05-21T03:20:09Z")
Yes, it appears when it is set as single relation. Because, if it is multiple relation, then we cannot access multiple values in a Set Columns, so the logic is fair. Thanks.
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 3:22am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/8 "2021-05-21T03:22:21Z")
I am using a user specific column for the Voter Id. I am quite puzzled how user specific columns work. If hundreds of users were to use the app at the same time, will each user get a user specific column for themselves, and will the set columns work simultaneously for hundreds of users? The app is a public app.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 21, 2021, 4:18am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/9 "2021-05-21T04:18:55Z")
Yes, they will get their own user-specific cells to input their values. As long as you setup the action right the set column will work correctly.
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 4:31am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/10 "2021-05-21T04:31:22Z")
And, there is no need to set up user profiles, right? Sometime back, I got to know, there is a tweak by first changing privacy options to Sign with email, then set up user profile, and then change back privacy options to Public, which is done for User-specific columns. Does it have be done in order to get my above mentioned idea working?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 21, 2021, 4:42am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/11 "2021-05-21T04:42:26Z")
If an app is Public and a user does not sign in, then a user specific column is only stored temporarily until the app is closed. If they sign in, then a user specific column is stored forever uniquely for that specific user. Having a user profile sheet or having user profiles enable has no effect on how user specific columns work.
---
### Author:  [@vijay](https://community.glideapps.com/u/vijay)
#### Post date: [May 21, 2021, 4:46am UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/12 "2021-05-21T04:46:44Z")
Ok. Got it. Thanks.
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/how-to-change-a-column-value-of-a-sheet-while-being-in-another-sheet/27035/13 "2024-01-17T16:52:10Z")