Skip to content

icon picker
Formula Chips

Learn about all the different icon types in Coda and how the correspond to data-types for better formula writing

This is a Coda formula chip

Chips-Project-Full.png
Formula chips represent some sort of data or information within your doc, and they give you clues about what that data is and where it is coming from. Formula chips are absolutely essential to writing complex, clean, and efficient formulas. Let’s dive in to learn about their unique parts.

This is what makes up a chip

Each formula chip has the following three properties
activity-grid
Icon
fill-color
Color
text-color
Words
Click on any of the arrows below to expand and learn more

Icon

The icon on a formula chip is arguably the most important piece of information you should be paying attention to when building formulas. Icons tell you what type of data the chip itself holds
Here is a list of all the possible icon types you may come across and what types of data they correspond to
Chips-Action-Multiple-Icon-orange.png
List of Actions
Chips-Action-Single-Icon-orange.png
Action
Chips-Boolean-Multiple-Icon-orange.png
List of Boolean Values
Chips-Boolean-Single-Icon-orange.png
Boolean Value
Chips-Currency-Multiple-Icon-orange.png
List of currency
Chips-Currency-Single-Icon-orange.png
Currency
Chips-DateTime-Multiple-Icon-orange.png
List of dates
Chips-DateTime-Single-Icon-orange.png
Date
Chips-Duration-Multiple-Icon-orange.png
List of durations
Chips-Duration-Single-Icon-orange.png
Duration
Chips-Frame-Single-Icon-orange.png
Table
Chips-Image-Multiple-Icon-orange.png
List of images
Chips-Image-Single-Icon-orange.png
Image
Chips-Number-Multiple-Icon-orange.png
List of numbers
Chips-Number-Single-Icon-orange.png
Number
Chips-Percent-Multiple-Icon-orange.png
List of percentages
Chips-Percent-Single-Icon-orange.png
Percent
Chips-Row-Multiple-Icon-orange.png
List of row-values
Chips-Row-Single-Icon-orange.png
Row-value
Chips-Text-Multiple-Icon-orange.png
List of text
Chips-Text-Single-Icon-orange.png
Text
Chips-URL-Multiple-Icon-orange.png
List of URLs
Chips-URL-Single-Icon-orange.png
URL
Chips-User-Multiple-Icon-orange.png
List of people
Chips-User-Single-Icon-orange.png
People
The most important thing to notice when looking at a formula chip is whether or not that chip is holding a single value, or a list of values.
For the most part, Coda adds a shadow that makes it looks like two of the single values stacked together as seen below
image.png
Notice though, that because the formula chip indicates it is a list we must use list operators to find out what is inside the list. For example, if you wanted to know if you had a $50 expense in your table:

Color

The color of a chip shows you where the data is sourced from. Meaning, if everything is green (like in this screenshot below), all the data is coming from the same table
image.png
The moment you see a second, or third, or fourth color, this is your clue that this data is coming from a different source. Take for example this formula:
image.png
This formula has both green and pink chips. The green color indicates that each one of those data types is connected to the same source, which in this case is a table called Tasks by chips. The Pink chip indicates a different source, which in this case is a control like this one: →
12/14/2022

Wording

Lastly, each chip has some words on it! The words refer the name given to the data whether that be the name of table, control, column, etc.

Chips-TasksbyChips-Full (1).png
This chip lets us know that it contains a list of date data specifically from the Due Date column inside of a table called Tasks by chips.


light

Formula Chip Quiz

Try your hand at this quick formula chip quiz! Determine whether the icon indicates the chip is a list or a single value. Then select what data type it holds!

Icon
List
Single Value
Chip Value Type
1
Chips-Action-Multiple-Icon-orange.png
2
Chips-Action-Single-Icon-orange.png
3
Chips-Boolean-Multiple-Icon-orange.png
4
Chips-Boolean-Single-Icon-orange.png
5
Chips-Currency-Multiple-Icon-orange.png
6
Chips-Currency-Single-Icon-orange.png
7
Chips-DateTime-Multiple-Icon-orange.png
8
Chips-DateTime-Single-Icon-orange.png
9
Chips-Duration-Multiple-Icon-orange.png
10
Chips-Duration-Single-Icon-orange.png
11
Chips-Frame-Single-Icon-orange.png
12
Chips-Image-Multiple-Icon-orange.png
13
Chips-Image-Single-Icon-orange.png
14
Chips-Number-Multiple-Icon-orange.png
15
Chips-Number-Single-Icon-orange.png
16
Chips-Percent-Multiple-Icon-orange.png
17
Chips-Percent-Single-Icon-orange.png
18
Chips-Row-Multiple-Icon-orange.png
19
Chips-Row-Single-Icon-orange.png
20
Chips-Text-Multiple-Icon-orange.png
21
Chips-Text-Single-Icon-orange.png
22
Chips-URL-Multiple-Icon-orange.png
23
Chips-URL-Single-Icon-orange.png
24
Chips-User-Multiple-Icon-orange.png
25
Chips-User-Single-Icon-orange.png
There are no rows in this table

coda_school

Ready to master Coda👇

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.