Limiting the returned data with RunActions

[Jean_Pierre_Traets]

Dear @Edan_Ben-Atar,

This post shows you how to limit the result according your needs.

Using Slice to limit the rows in a view (return Top n rows)

Hello. It works for me but there’s something extra I wanted to do. I have a task table with some columns, but the ones that matter for this are Urgency(returns a float falue) and Status(Returns a pre-defined string such as ‘to-do, waiting, done, cancelled…’). Very well, I want to apply the slice in Urgency and sort it out by the highest value. Here’s the fórmula: thisRow.In(thisTable.Sort(false(),thisTable.Urgency).Slice(1,3)) It works fine, but it brings all the tasks with all Statuses and …