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]

@abe.sherman [image] Daily Moments · Glide · Create Apps from Google Sheets Check out a video I made via Loom

Hey great news! I solved it :slight_smile: At least with a small workaround… if you can find a better way then I would love to hear! [ - YouTube] Thanks again for your time and support. I love this community!

[image] Drearystate: The community moderator should be given access. Don’t you think? :slight_smile: Moderators, Joe. I guess you haven’t noticed, but we’ve been multiplying :grin:

What other moderators are there? I’ve only seen the amazing Darren :grin:

I’m a community expert incognito…

Oh dear, I spoke too soon. That idea was based on user specific columns. This means the correct room is only visible for the current user - the status is wrong for all other people. In other words, you can only detect the room you are in and not who else is in the room with you. I need to know where everyone is any given moment. Ugh. back to the drawing board.

Wow, almost same design :rofl: [image] Huge Thanks to the Glide Team & Sallon Beauty's V.2 Sneak peek shushing_face Project Showcase Sallon Beauty’s V.2 Sneak peek is coming with special news. You’ll be able to: Access user & Admin view in the same app (before were 2 separated apps) Date and Hour slots for each specialty of each professional Rate each professional Huge thanks to the glide team for participating in the app-off contest. Now I’m waiting to my jacket too rofl

Ok here is the link: https://go.glideapps.com/support/4005ff60-4c79-4b37-8662-bfc9f7440b9b Goal is to program the BLIND ROOMS tab to update the user’s profile row with the room ID as soon as the user chooses to enter one of the room items in the list shown: (It should be possible to track all people and not just the user’s own room status… which probably means avoiding user specific columns). [image]

I see what you need and understand what your saying. Since you are not in that sheet the compound action cannot change values ina row in another sheet. even through the relation it wont work correctly. Your compound action would have to exist in the user sheet to perform that action in the manner you want. The alternative is to have the rooms set as columns and users in one column, when they select a room a timestamp is put in that column and the newest timestamp would determine the room. Or you can use Google sheets which would be a lot easier.

Thanks that’s a nice idea with rooms in columns in the user sheet. Downside is no flexibility to name a new room - or maybe they could be renamed - and I have no idea about having enough to keep things exclusive. Moreover I wonder if I will have to move all the tab components… I need to think through the implications. Strange how seemingly trivial things end up being a pain! Thanks again!

I still have yet to really study this thread and what’s been done so far, but basically you need the user’s email in the rooms sheet, correct? You can do this with a template column that pulls in the email from the user profile sheet. That will give you a column with a dynamic email that’s unique for each user. Then create a single relation to your user’s sheet by linking that template column to the email column in the user sheet. Then when you click on a room, you will be able to set up your action to set the current room in the user sheet through the Set Column action using the single relation you created. Hopefully that helps. If not, I’ll try to read into this deeper.

What room am I in?

Ask for Help

Lucas_Pires February 15, 2021, 9:39pm 29

Wow, almost same design

Topic		Replies	Views
🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES! Project Showcase	88	7370	September 10, 2021
Set Columns ---> always be able to set to the User Profile Sheet Feature Requests	4	520	November 29, 2021
Need "Set Column > User Profile >" without template/relationToUser Feature Requests	5	511	November 7, 2021
Setting empty cells with set column and increment not working Ask for Help	31	1068	March 18, 2021
🙋‍♀️ User Profile columns in conditions and columns General	88	5092	May 20, 2020

What room am I in?

Related topics