I’m trying to setup a data viewer list with multiple sheets. What I want to be able to do is drill down through data. I’m using Google sheets for the list.
Specifically, I want to have a top sheet that provides a list of inspection types (this is for my own use). When I click on an item in the list, I want the list to reload with data from the appropriate sheet. (To be more descriptive here, let’s say I have a list of inspection types that includes general inspectors, termite inspectors, and plumbing inspectors. When I select general inspectors, I want it to take me to the sheet with the name GeneralInspectors and load that data in the list.) That sheet will provide me the names of various inspectors. From there, I can select an inspector and be taken to a detail page. I’d like to be able to drill through the list, all on one screen, with only the detail page being separate.
I know how to setup a data viewer list to go to the detail page. But I don’t know how to setup a list so that when a selection is made, it loads another list from on a different sheet, from the same data source. Anyone ever tried this? I couldn’t find anything in the forum.
Any help would be much appreciated.