Skip to content
WithName
WithName
Formula: WithName()
Category: Relational
WithName() Names a value to be used inside of an expression
It’s kind of like saying...
WithName() uses three parameters:
Value
WithName(Value, Name, Expression)
The value you want to rename (usually a short forumula). 
Name
WithName(Value, Name, Expression)
The name you want to give the value (i.e., the "sweet nickname". 
Expression
WithName(Value, Name, Expression)
The primary formula--you use the renamed value in here.
What Exactly Is This Formula?
WithName() is like the bit.ly of Coda. The mnemonic device of Coda.
Bit.ly
Takes long and complex URLs and shortens them
Mnemonic Devices
Takes long and complex phrases and creates a way to memorize them easily
withName()
Takes long and complex formulas and allows you to reference them easily
How Does it Work?
Here’s a quick example. Let’s say that I want to draft a sentence that tells me how many people in the have a name that starts with “A” and the average age of those people. WithName() allows me to do that easily.
There are 1 people whose name starts with 'A' and the average age of those individuals is 11.And here’s the formula I wrote to draft that sentence
Here’s how that formula breaks down
(1) The “Value”:
People Database.Filter(name.StartsWith(”A”) (2) The sweet little nickname
aPeople (3) The formula
Format("There are. . . ",aPeople.count(), aPeople.Age.Average())Let’s Get Deeper
WithName() does require extra keystrokes and admittedly does have a small learning curve. So when and where should you use it to actually provide value to your workflows or docs?
First off—if you are writing a longer formula that utilizes filter() within a formulaMap() you will need to use withName() to access the currentValue (see lesson for more info on current value) within the ForEach() loop.
Example
Let’s say you wanted to write a canvas-based formula to draft a summary list of the amount of people that match a certain age and let their names be instantly clickable in order to pull up their information. You will need to use withName() to do that.
Here’s the formula (Right click to see how its written)
There are 2 people that match the age of 20There are no people that match the age of 21There are 3 people that match the age of 22There are 3 people that match the age of 23There are 3 people that match the age of 24There is 1 people that match the age of 25There is 1 people that match the age of 26There are no people that match the age of 27There are no people that match the age of 28There is 1 people that match the age of 29
@Craig Kidd
@Mr. Brian Montoya
@Bryan Johnson
@Jackson Fron
@Angie Collier
@Megan Smith
@Daniel Ayers
@Coda Man
@Ronnie Gross
@Thomas Ward
@Scott Weir
@Elizabeth Nguyen
@Angela Hill
@Matthew Smith
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Name
Age
Craig Kidd
20
Elizabeth Nguyen
25
Ronnie Gross
24
Bryan Johnson
22
Angela Hill
26
Matthew Smith
29
Thomas Ward
24
Megan Smith
23
Mr. Brian Montoya
20
Daniel Ayers
23
Scott Weir
24
Coda Man
23
Jackson Fron
22
Angie Collier
22
There are no rows in this table
Practice: Use WithName() in a simple formula
Done
Create a “Learn about a tree” activity
Done
Challenge: Create a summary of salary information for a dashboard
Done
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.