In my dataset I have say two categories, 'Fruit' and 'Vegetables'. I have created an app with an input for the user to select which category they want to report on. I'm doing this dynamically, none of the inputs are hard coded.
There are then four sub-categories, 'Apples', 'Pears', 'Peas' and 'Carrots'. I'd like to create another input for the user to select the sub-category but where if the user selects 'Fruit' they only see 'Apples and 'Pears'; if they select 'Vegetables' they only see 'Peas' and 'Carrots'. If I create another input in the app then the user sees both questions when they run the app, and the second question shows all four sub-categories.
I'd like to change the app so that when its run, the user only sees the first question. Once they've made their selection, the app then processes their choice, and then shows the second question, with the choice of sub-categories available to choose from being dependent on the response to the first question.
I'm guessing it will involve a macro of some sort but I'm unsure where to start. Any advise would be appreciated. Thanks.
