Here’s the scenario:
Every year my friends and I go on a trip to Comic Con, and we split hotel rooms. I’m putting together an expense tracker to keep up with this. We sometimes have more than one hotel room, so I want to assign people in the list to a room, which is a row in the “rooms” table
To assign a person to a room I am giving them a column (“room”) in the “attendees” table. This is a select list, with the formula being room.number. This works great
The issue is, not everyone stays the same amount of time, so I want to check off which nights they’re staying. So, in the rooms table, I have a “nights” column which is a multi-selectable select list.
The problem: I want to have an attendee.nights column in the attendee table. I want the options for each row to depend on what room number they selected. So, I want the selectable options for attendee.nights to depend on what is selected in attendee.room
I tried doing a filter of Filter(Rooms.Nights,Rooms.Number=thisRow.Room ) but I just get “blank” as the list of selectable items
Help!