Skip to content
Returns ReturnsReturns
Returns?
FormulaMap does something for each item in a list.
Let’s look at some examples.
Our Team
Name
Last Initial
Connor
M
Gretchen
T
Susan
D
Karina
M
Steven
H
There are no rows in this table
What do each of these return?
[Our Team].Name.FormulaMap(CurrentValue)
ConnorGretchenSusanKarinaSteven
[Our Team].FormulaMap(CurrentValue.Name)
ConnorGretchenSusanKarinaSteven
[Our Team].Name
ConnorGretchenSusanKarinaSteven
What is FormulaMap for?
If all of those return the same thing, why do we need FormulaMap at all?
What about this one? What does it return?
[Our Team].FormulaMap(CurrentValue)
@Connor
@Gretchen
@Susan
@Karina
@Steven
Challenge #1
Now your first challenge: how would you produce this output?
Connor MGretchen TSusan DKarina MSteven H
Challenge #2
Not only can you use FormulaMap with formula, you can also use it with buttons.
👆 Can you make a button that does this?
View of Our Team
There are no rows in this table
Challenge #3
👆 Can you make a button that does this?
Some Tasks
No results from filter
Assignments
There are no rows in this table
Challenge #4
E.g.
Challenge #5
Replicate the Count of Things Used formula
All Collections
There are no rows in this table
All Things
There are no rows in this table
Think you figured it out? Submit your solution doc. You must to Coda to submit.
There are no rows in this table
Note: this doesn’t currently work. Coda doesn’t allow Cross Doc with Published pages (
). Instead, share you doc directly on Twitter with Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.