What to do when CurrentValue is overloaded

[Paul_Danyliuk]

The bulletproof solution is described here (basically the answer above expanded as a tutorial)

Tutorial: Iterator tables (CurrentValue workaround)

After answering the CurrentValue issue questions so. many. times, I finally recorded the tutorial on a Coda data processing pattern I use as a workaround for this very problem. It involves creating single-row helper tables that store outer CurrentValue values into cells, so that they’re accessible in nested Filters and FormulaMap loops. I call this pattern Iterator tables, and beside being a workaround for CurrentValue, these are very powerful for doing more complicated calculations The video i…

If you need a column formula, not an action — one way is to construct a full product of [outer CurrentValue, inner CurrentValue] pairs, then iterate over that. Example:

Dedupe an array of arrays based on a common key/object with formulamap()

Alright, here’s an explanation (also noticed a problem with my solution while writing this post, lol, so fixed and also simplified). Normally the solution would look like this: Get the list of unique emails as [List of lists].FormulaMap( CurrentValue.Last() ) given that emails are last in each list. Run a simple formula map: [Unique emails].FormulaMap( [List of lists].Filter(CurrentValue.Last() = uhm… CurrentValue).First() ) i.e. for each email (CurrentValue) filter the list of li…

As for the original question, this should now be fixed. It was an editor bug.