# What room am I in? **URL:** \ **Category:** Ask for Help\ **Created:** [February 15, 2021, 5:17pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829 "2021-02-15T17:17:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 5:17pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/1 "2021-02-15T17:17:25Z")
Hey guys, I’ve hit a wall. Wonder if you could please help? I have a tab that uses a sheet called ‘blind rooms’ that features a simple in-line list of room items. The inline list displays a list of rooms and they are filtered to show only the rooms that the user can access. Pretty straightforward. Once the user selects a room from the list and before showing the room details, I would like to update a column called ‘current room’ in the Users sheet. In this way, I can keep track of which room each user has last entered. But I can’t find a way to do a column fill with the room ID into the user’s ‘current room’ column. If I try to run an action when a room is selected the column fill only picks up a relation that’s in the blind rooms sheet that is based on the ‘room owner’ as opposed to the user ID. So the wrong user’s current room get’s updated. Thanks for any pointers! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3c56375b2013ebc0f67b49fdf3b51818b8b65a8.jpeg) ---
**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:** [February 15, 2021, 5:23pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/2 "2021-02-15T17:23:06Z")
The first thing that occurs to me is that you could use your User Profiles table as the source for this tab, and then you would have direct access to all columns in that table for a Set Columns action. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 5:40pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/3 "2021-02-15T17:40:39Z")
Yes, it already is! But I still can’t push the item selected into the correct user column… ---
**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:** [February 15, 2021, 5:42pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/4 "2021-02-15T17:42:45Z")
Do you have it filtered by user is signed-in user? ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 5:46pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/5 "2021-02-15T17:46:34Z")
For clarity, I force any user to sign in via email and pin… so I think the answer is yes. ---
**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:** [February 15, 2021, 5:51pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/6 "2021-02-15T17:51:16Z")
No, that’s not what I mean. In your component options, there is a visibility filter. You need to set this to email is signed-in user. If you don’t do that, then any Set Column action will operate on the first row in the sheet. (I am assuming that you have User Profiles enabled and configured) ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 5:58pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/7 "2021-02-15T17:58:09Z")
Ah ok - I will take a look… here is a small video to demo the issue [![]( " - YouTube") ](https://www.youtube.com/watch?v=j0VeR9afb7I) thanks for your support! ---
**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:** [February 15, 2021, 6:05pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/8 "2021-02-15T18:05:06Z")
![Screen Shot 2021-02-16 at 2.02.56 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e04fd472e83c7fc92c5b3304e1fcbd88bb6e50bf.jpeg) This is where you need to check that you have it filtered by user is signed-in user. Also, in your Custom Action, you should be able to do a Set Columns on “This Item”, rather than going through a relation. ---
**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:** [February 15, 2021, 6:12pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/9 "2021-02-15T18:12:59Z")
I guess the other thing I would point out is that if you had Row Owners enabled on your Users sheet (which I’m guessing you don’t), then filtering wouldn’t be necessary as each user would only have access to their own row. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 6:14pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/10 "2021-02-15T18:14:59Z")
Sorry if I’m missing something, I’m close but clearly no cigar yet… [![]( " - YouTube") ](https://www.youtube.com/watch?v=Tm0TALZ6yUw) ---
**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:** [February 15, 2021, 6:18pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/11 "2021-02-15T18:18:41Z")
Is the User relation a single relation? You can’t Set Columns through a multi relation ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 6:21pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/12 "2021-02-15T18:21:47Z")
Yes the ‘room owner’ relation is a single relation… that shows up and works fine. But it’s the wrong relation. I can’t set up a ‘guest list’ relation because as you rightly point out this requires a multi-relation for all the guests that can access the room… ---
**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:** [February 15, 2021, 6:44pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/13 "2021-02-15T18:44:10Z")
Okay, there is something obvious missing but I’m struggling to put my finger on it. You seem to be missing a relation somewhere. Might be time to call in the cavalry… @Jeff_Hager ? ---
**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:** [February 15, 2021, 7:05pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/14 "2021-02-15T19:05:41Z")
If you want to change a value in current user you must make a relation with that user. The relation with owner only can change owner’s values ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [February 15, 2021, 7:17pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/15 "2021-02-15T19:17:48Z")
Yes but how? Each room has many guests. So the relation will be a Multi-relation and this blocks the set column option. ---
**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:** [February 15, 2021, 7:21pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/16 "2021-02-15T19:21:40Z")
Can you share a demo of user and room tables? ---
**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:** [February 15, 2021, 7:29pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/17 "2021-02-15T19:29:12Z")
Why not select the option to allow someone to help you fix this by providing our community moderator with the link so that he can jump in right quick and fix this for you. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28dda184354c7324200dbfc6715bc8d4e7a778d9.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:** [February 15, 2021, 7:35pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/18 "2021-02-15T19:35:59Z")
Support links don’t work for us. They are only for the Glide team. ---
**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:** [February 15, 2021, 7:36pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/19 "2021-02-15T19:36:25Z")
The community moderator should be given access. Don’t you think? 🙂 ---
**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 15, 2021, 7:37pm UTC](https://community.glideapps.com/t/what-room-am-i-in/22829/20 "2021-02-15T19:37:24Z")
Still need to read through all of this when I have time, but are you trying to set the room for multiple people at once, or is the user only setting the room for themselves? [Next page](https://community.glideapps.com/t/what-room-am-i-in/22829.md?page=2)