Dynamic Slices, views and labels

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! :slight_smile:

Firstly, the user will select an option from User Settings that I have already set up

Screenshot 2020-01-22 at 07.56.25

These settings are also editable by the user in an underlying sheet using a VALID_IF

Screenshot 2020-01-22 at 07.53.28

On selecting one of the 3 options the App sets [Proximity Distance] to the selected value

Screenshot 2020-01-22 at 07.46.36

The [Proximity Distance] value can then be used to select the correct data in Slices and to set Menu Views

Screenshot 2020-01-22 at 07.48.01

Screenshot 2020-01-22 at 07.55.12

and in the slice associated with the view using…

Screenshot 2020-01-22 at 07.49.07

Screenshot 2020-01-22 at 07.49.47

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!

1 Like