FormulaMap does something for each item in a list.
Let’s look at some examples.
Our Team
Name
Last Initial
1
Connor
M
2
Gretchen
T
3
Susan
D
4
Karina
M
5
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.
Put Name into Backup Name
👆 Can you make a button that does this?
View of Our Team
Name
Last Initial
Name Backup
1
Connor
M
2
Gretchen
T
3
Susan
D
4
Karina
M
5
Steven
H
There are no rows in this table
Challenge #3
Assign All Tasks to Each of Us
👆 Can you make a button that does this?
Some Tasks
1
2
3
Name
Eat
Drink
Be Merry
No results from filter
Assignments
Task
Who?
There are no rows in this table
Challenge #4
E.g.
Challenge #5
Replicate the Count of Things Used formula
All Collections
1
2
3
4
5
Collection
Thing
Count
C
A
2
D
C
3
D
B
5
E
D
7
E
C
11
There are no rows in this table
All Things
1
2
3
4
5
Name
Count of Things Used
A
[1]
A
B
[1]
B
C
[2]
A
D
[6][5]
A
B
E
[42][35][22]
A
B
A
There are no rows in this table
Think you figured it out? Submit your solution doc. You must to Coda to submit.
Sign In
Link to your doc
Email Address
Submit
1
Fill in both fields
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 ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.