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.
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)
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?
Challenge #3
Assign All Tasks to Each of Us
👆 Can you make a button that does this?
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
Think you figured it out? Submit your solution doc. You must to Coda to submit.
Note: this doesn’t currently work. Coda doesn’t allow Cross Doc with Published pages (). Instead, share you doc directly on Twitter with