There is a view function called LINKTOFILTEREDVIEW(). Instead of having hundreds of Slices, and then hundreds of views, to display filtered data, you can instead move the Slice filter criteria into an expression and then provide a user selectable way to view the data.
For example, you can provide Filter Selection Form with your various columns to filter by and provide choices for each that user selects:
- Column 1 Choice - A, B or C
- Column 2 Choice - D, E, F, G
- Column 3 Choice - H, I, J, K, L
On Save of the Filter Selection Form, attach an action that will navigate to the view applying the filter using The LINKTOFILTEREDVIEW() function something like this:
LINKTOFILTEREDVIEW("Filter View Name",
AND([Column 1] = [Column 1 Choice],
[Column 2] = [Column 2 Choice]
[Column 3] = [Column 3 Choice]
)
)This would be a much easier approach to implement (though you have already done much of the hard work creating the Slices), it will much easier to modify and maintain, and I think will be much more performant than having all those Slices and Views inside of the app.
You can find out more on this function below
LINKTOFILTEREDVIEW()
LinkedIn
Twitter
