Hello!
Asking the amazing people around here. Looking for any idea on how to do this. We have a "working" solution... Looking to improve it.
We have a table with this data. Each room is in a general area, in a section, in a subsection with an ID. What is show here is AN EXAMPLE. You could have multiple areas, multiples sections, etc.
| Area | Section | Subsection | Room |
|---|---|---|---|
| Area1 | Section1 | Subsection1 | RoomID1 |
| Area1 | Section1 | Subsection1 | RoomID2 |
| Area1 | Section1 | Subsection2 | RoomID3 |
| Area2 | Section2 | Subsection3 | RoomID4 |
What we currently have is 4 dropdowns to filter the data to show. Each one is dependent on the last one.
Hierarchy: Area > Section > Subsection > Room
Practical Example
If the area dropdown is set to "Area1", on the section dropdown it won't appear "Section2".
If you for example have filtered, "Area1", "Section1", "Subsection1" then on the Room dropdown it will appear RoomID1 and RoomID2, but if you have "Area1", "Section1", "Subsection2" it will only show RoomID3.
However, if you don't have any filter set, then on the room dropdown it should appear ALL the rooms IDs.
This means:
Each dropdown filters based on the last dropdown selection. If no value is selected then no filtering is applied.
What would be your solution?
Is easy to do it in 1 direction. If you filter one dropdown, you apply the filter on the next one (filtering based on column). But if you select a room, then you have to autocomplete the dropdowns higher on the hierarchy.
For example if you select "RoomID3" directly, it should autocomplete the other values with "Area1", "Section1", "Subsection2".
Please, feel free to correct any grammar mistakes or to ask for any clarification.
Thanks in advance for any idea that you have!