Share
Explore

# Friendly FormulaMapFriendly FormulaMap

Gretchen Teagarden
|

## FormulaMap does something for each item in a list.

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

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?
[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?
1
1
2
3
Name
Eat
Drink
Be Merry
Assignments
0
Who?
There are no rows in this table

## Challenge #4

Now, how would you create a lettered (not numbered) list of the items in ?
E.g.

## Challenge #5

Replicate the Count of Things Used formula
All Collections
0
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
0
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
to Coda to submit.