Directory/Guide App - Referencing other rooms on the same floor?

Hi there! Hoping there’s a way to do this that I haven’t thought of yet. I’m playing around with making an app that serves as a of a building with various rooms. If someone clicks into a room to learn more, I would love to be able to display all the other rooms they can explore on that same floor. Any people more clever than I that see a way that this is possible?

You can have a Sheet that’s structured like this:

  • Room name/ID
  • Floor of the room
  • Any other info you need

In the details screen for each room, make an inline list pointing to the Sheet above, filter by floor of the room is the same as the screen’s floor, and the room name/ID is not the screen’s room name/ID.