Sort and filter a Canvas Filter Tray Category

5.55K viewsScripting

I have a category of Products which is in the Filter Tray of a presentation canvas.

There are four different tasks that users perform, and each task prioritises certain Products to be actioned first. For example, one task might be to work on the top selling products, another might be the lowest in stock, and so on.

I want to use the same canvas for all the tasks.

My challenge is to give the user an easy way to work the Products in a certain order.

For example, one idea:
1. User identifies a table view of Products that are already sorted and filtered the way they want.
2. The script identifies the order of the visibly sorted/filter items in the table view category.
3. Next/Previous buttons on the canvas enable the user to move from one product to another in the correct order.

#2 is something I can’t see how to do in scripting. Is there a way to determine the visible order of items in a filtered and sorted category?


The customised views would use filtering, but I could also have a column that embodies the filter as a formula, e.g. a FilterFlag item which is 1 for visible rows and 0 for rows that are filtered out. (If that helps)

You are viewing 1 out of 6 answers, click here to view all answers.

Latest Questions