Outer CurrentValue access

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:

  1. Multiple levels of currentValue: currentValue is the inner scope, currentValue1 is the next level of scope, then currentValue2 is the next level and so on
  2. Aliasing: E.g. Filter([Tasks] as t, t.Value = thisRow.Value)
  3. 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?

4 Likes