Get CurrentIndex of FormulaMap loop?

1

I have a list that I’m running through FormulaMap()

And I’m trying to apply a consecutive growth factor of 1.1 to every item in that list.

So if each item in the list was $1, the output for 3 loops of FormulaMap would result in:

$1.1
$1.2
$1.3

But at the moment, my current results are:

$1.1
$1.1
$1.1

So if I could get the CurrentIndex that the FormulaMap was processing (similar to CurrentValue), then I imagine using that in the multiplier equation. CurrentIndex would sort of be a reverse Nth().

Alternatively, is there a math equation for this type of scenario? Like a Log() or Power()?

Many thanks.

2

@Michael_McGreal

Please show the exact math for the calculation you want to perform inside FormulaMap().

3

Hi there Ander,

Thanks for your help.

Here is a video showing the exact math.
Text version for quick reading/skipping is timestamped in the video description.

Many thanks,
Michael

1 Like
4

@Michael_McGreal

I think you had the right idea: https://coda.io/formulas#Power

power_2019-01-08_1701
power_2019-01-08_1701.png853×577 32.1 KB

2 Likes
6

Hi Ander,

It took me a couple tries to get to your answer. The sequence(), and order of operations in the Power() formula make this a superb solution.

Many thanks my friend :+1:

Michael

1 Like
7

Interesting project!

8

Wow. Just wow. Thanks.

1 Like
9

+1, Notion has also added support for many loop functions, Coda needs to support some more advanced features.

10

image
image808×456 34.8 KB

11

You could use Withname() for nested loops…

1 Like