Limit "last modified" list to only 10

AppSheet AppSheet Q&A
1

Hello,

How can I make the list of my last modified only set to a desired count? Any idea please, thanks!

2

[TOP](AppSheet function list - AppSheet Help

2 Likes
3

Thank you! But sorry Iā€™m just a beginner, quite donā€™t know.. so where do I use this? My ā€œlast modifiedā€ is just a VIEW I made, sorted by my column ā€˜last modifiedā€™. So Iā€™m not sure where to use this.

4

One technique would be to create a slice for the table that the view is currently based on, and switch the view to be based on that slice. In the sliceā€™s row filter condition, enter an expression that returns the rows you want. For example:

IN([Row ID], TOP([ORDERBY](https://support.google.com/appsheet/answer/10107362?hl=en)(Table[Row ID], [Last Modified], true), 10))
2 Likes