I'm looking to create a room assignment view ...

(Tammi Canelli) #1

I’m looking to create a room assignment view that would allow multiple users to see a list of available rooms and beds within each room. But need the rooms and beds that get selected to either grey out (show unavailable) or be removed from list. Is this possible?

If so can you point me in the right direction as to how to design?

1 Like
(Gil Littman [AppSheet]) #2

Hi Tammi, You can use a ref dropdown to show available rooms. Take a look at the attached sample app to see how it’s done. Once you have the dropdown, just add a show_if condition to show the users only the available rooms/beds. Dropdowns - How to create dropdown menus in AppSheet appsheet.com

(Tammi Canelli) #3

Thank you.

I’ve used ref drop downs in another table but never had to “take away or hide” a selected


When you select an option from the drop down does it automatically become unavailable for future selections or do I need to create an expression for this.

(Gil Littman [AppSheet]) #4

After the user selected a room, you’ll need to mark this room as unavailable, so it will be excluded from the next user’s dropdown.