FormulaMap() help: Not use any formula or button column

[Paul_Danyliuk]

Oh gosh, indeed! RunActions to recalculate the doc between iterations!

How could I forget the thing I even documented myself?

PSA: Wrapping an action with RunActions() will make sure that the doc recalculates between actions

I always thought the only purpose of RunActions() was to allow specifying multiple actions with a comma in a block (top-level or within a FormulaMap()), and it could be easily omitted if the action was just one action. I.e. I thought these were identical: Sequence(1, 5).FormulaMap( Table.AddRow(...) ) Sequence(1, 5).FormulaMap(RunActions( Table.AddRow(...) )) Turns out they’re not: Without RunActions(), Coda executes the action(s) right away without recalculating the doc between action…

I don’t think it’s a bug but a feature. It’s a good thing that we can control it ourselves (sorta) whether we want to perform actions quickly (without recalculations) or want the doc to recalculate.