Gallery
Share
Explore

Friendly FormulaMap

Gretchen Teagarden
|
Karina Mikhli
|
Steven Hurtado
|
Connor McCormick

FormulaMap does something for each item in a list.


The best among us think it should be called “ForThisDoThat” (attr.
Gretchen T
⁠
)

Let’s look at some examples.
Our Team
1
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)
Returns
ConnorGretchenSusanKarinaSteven
⁠
⁠
[Our Team].FormulaMap(CurrentValue.Name)
Returns
⁠
ConnorGretchenSusanKarinaSteven
⁠
⁠
[Our Team].Name
Returns
⁠
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)
Returns?
@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
1
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
1
2
3
Name
Eat
Drink
Be Merry
No results from filter
⁠
Assignments
Task
Who?
There are no rows in this table
⁠

⁠

Challenge #4

Now, how would you create a lettered (not numbered) list of the items in
Assignments
⁠
?
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
[
A
1]
B
[
B
1]
C
[
A
2]
D
[
A
6][
B
5]
E
[
A
42][
B
35][
A
22]
There are no rows in this table
⁠

⁠
Think you figured it out? Submit your solution doc. You must
Sign In
⁠
to Coda to submit.
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 (
yet!
⁠
). Instead, share you doc directly on Twitter with
@connormcmk
⁠
⁠

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.