This has been heavily discussed at Coda. The main thing we’ve struggled with is a good syntax for this. What would you picture?
Here are a couple options:
- Multiple levels of
currentValue:currentValueis the inner scope,currentValue1is the next level of scope, thencurrentValue2is the next level and so on - Aliasing: E.g.
Filter([Tasks] as t, t.Value = thisRow.Value) - ForEach(): E.g.
Foreach(t in Tasks.Filter(....), t.Value)– note that this would produce a list, so may need a set of aggregator / reducer functions
Other ideas? Any of those sound right?