Sorry if you guys already know this but it is new for me.
I used to have 9 slices and 9 views depending on which of 3 USERSETTINGS()'s the user selected on 3 choices. (Level 1, Level 1 and Level 3)
Now I have 3 slices and 3 views for the 3 choices!
Firstly, the user will select an option from User Settings that I have already set up
These settings are also editable by the user in an underlying sheet using a VALID_IF
On selecting one of the 3 options the App sets [Proximity Distance] to the selected value
The [Proximity Distance] value can then be used to select the correct data in Slices and to set Menu Views
and in the slice associated with the view using…
Whenever the user changes the USERSETTING the App dynamically applies the [Proximity Distance] where needed throughout the rest of the app.
Has saved me App Space and Coding.
If you need any help, don’ hesitate to contact me!