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!

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

2X_0_005f0029a57bc09e2c8733a416129159a0de47c0.png

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

2X_1_11c63dc8a2d72debae931c16f03d223e612b1af7.png

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

2X_8_8bf564d713bbc28dc8a4a1bb69faca44493feeab.png

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

2X_f_f504d6cec126f6e00c8a535d36d0bdd1a1220007.png

2X_3_3fd745e935546c24458880e560c9a415035f10a6.png

and in the slice associated with the view usingโ€ฆ

2X_f_fffb57d01b98b672b5c7f4f4bc2565b47f58559d.png

2X_d_dcfd143c1d5f2ae26a8ac444f0938ecc10985d46.png

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!

2 2 2,038
2 REPLIES 2

Hi Steve.
Iยดm trying use slices in my app, I saw youยดve been successful in your first aplication, Iยดm trying select just rows that have something writed.

So i need a condition that write: If the row have been IS BLANK do not show the collumn in the frontend form

Could you help me?

Hi Laura. Iโ€™ll see if I can help

If all you want to do is hide a column then you can use the Show_If statement for itโ€ฆ

In my example, the column Reported By will only be shown if another column [Date Completed] is blank.


If you need a Slice to manipulate data that meets criteria then use something likeโ€ฆ

This will return all data that meets the criteria. It will not hide a column though.

Hope some of this helps.

ISNOTBLANK() is the opposite to ISBLANK()

If not, get back in touch.

Keep safe

Top Labels in this Space