Hi to all,
We have a detail page that is impossible to access without filtering at most 500 items (any item in details table have 200-400 lines). So I have to make a conditional navigation to this page.
Is there any way to hide a navigation button if items selected are more than 500? Or to make a Go to Sheet action available on tooltip for Number of Items cell only if the numer of items is at most 500? Or to put an Go to sheet Action in a parameter?
Or, it would be a good alternative to put a dinamic filter on the sheet/table that would filter the first 500 items (if the general selection exceeds 500 items). The only problem is I cannot put all other filters on context because we have 50 filters on th dashboard... And without context I risk to filter randomly less than 500 items.
Thank you in advance for any sugestions.
Adelaida
Hello, Adelaida Ioachim !
It is impossible to make button available by field.
But you can create user warning (count number of rows at that sheet and if it is more then 500, show ">500 rows" or smth like that).
To filter first 500 items use RANK calculation https://www.youtube.com/watch?v=8mZFotbqfNs&t=272s
