Arrays

FormulaMap(list, formula)

FormulaMap() is one of those things that can have a consultants explanation and a proper explanation.
The consultants explanation is that it allows you to run a formula for every item in a list. Which is absolutely correct, but not really helpful. As always, the proper explanation is a bit longer. See below for examples in which FormulaMap() is used to iterate through a list of items in a column in a table.
Simple iteration
Canvas Formula
OddEvenOddEvenOdd

image.png
Button Formula 1
Split odd and even
into two new tables

image.png
Button Formula 2
Split odd and even - Two columns
Take more than one column across to the new table

image.png
Numbers
1
Number
Description
1
1
One
2
2
Two
3
3
Three
4
4
Four
5
5
Five
There are no rows in this table

Odd
0
Search
1
2
3
4
5
6
Number
Description by Formula Map
Description by filter
1
One
3
Three
5
Five
1
One
One
3
Three
Three
5
Five
Five
There are no rows in this table
Even
0
Search
1
2
3
4
Number
Description by Formula Map
Description by filter
2
Two
4
Four
2
Two
Two
4
Four
Four
There are no rows in this table


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.