I have a room reservation calendar that tracks 12 different rooms/locations. I need to be able to filter that calendar by each room. In the past we have created a view for each value of location (a choice column in our case).
This is inefficient, since if we add a room or change the name of a room we need to go in and change the views.
Is there a way to have an automatic list of the possible locations from the choice list and automatically filter based upon those?