I am struggling with displaying a list of FAQs using categories and subcategories. I am using the demo video my @Mark on categories. I have 2 sheets; FAQ-Main and FAQ-Tree. I am able to set up the 5 top categories by adding a reference (FAQ) in the Main sheet linking it to the Tree sheet. Top categories display correctly in details view. I have subcategories under each category except one (Miscellaneous). I am not able to create and link the questions with the subcategories.
What I want to see is my main FAQ page to show the 5 top categories and when you click on one of them, it should list its subcategories and then each question with its answer. If there are no subcategories, I want the questions to be listed.
The app is at https://faq4class.glideapp.io
The link for the sheet: https://docs.google.com/spreadsheets/d/1oAb4AEFjpV1dXW_xEEwUQXHlcSbhyyBpb7eWUicepbE/edit#gid=1889463118
Any help on this is greatly appreciated.