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
:currentValue
is the inner scope,currentValue1
is the next level of scope, thencurrentValue2
is 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?