Skip to content
Introducing the Affinity Pack

icon picker
Interactive Guide

👩‍🦰 Entity Columns

Bring rich data about People or Companies into your Coda tables

Affinity’s Data Model revolves around three Entities, namely: People, Organizations, and Opportunities. To retrieve one of these entities, utilize the handy Column Formats. Along with the Affinity ID and Profile Page Link, each column also matches entities with more easy-to-find input parameters.

Adding a new Person

When adding a new person to an Affinity Person Column, you can enter any of the following details:
Their unique Affinity ID ​Eg. 109327320
Their Profile Link Eg.
Any Email Address
💡 Click any of the “copy” buttons, then paste into a blank row of the table alongside. Press Return on your keyboard or click away from the cell to fetch the person from Affinity. Hover over the resulting “chip” to see all the information available for each person.

Try add a new Person 👇
Brian Sowards
There are no rows in this table

Try add a new Org 👇
There are no rows in this table

Adding a new Organization

When adding a new org to an Affinity Organization Column, you can enter any of the following details:
Their unique Affinity ID ​Eg. 282889374
Their Profile Link ​Eg.
Their Website URL Eg.

👩‍🦰 Entity Formulas

With lightning-fast autocomplete, easily work with data from Affinity in your Coda formulas.

When using any of the Find Formulas within the Coda Formula Editor, you can take advantage of the autocomplete feature. As you type, we’ll return top matches at the bottom of the CFE. To try it out, press =, type Person() and start typing someone’s name. Results will appear towards the bottom left of the screen.

Person() formula

Steven Hurtado

Organization() formula


💡 Not seeing suggestions?
Don't surround your search term with quotation marks. Doing so will actually halt the autocomplete feature as Coda will think you're trying to enter a string value to that parameter.

Try it yourself!

Press = to insert new canvas formula.
Type Person and select the suggested Affinity Person formula.
Start typing someone’s name and notice how suggested results appear at the bottom of the Formula Editor. ​For this demo doc, try Jono B and click on “Jono Bouwmeester”. Thankfully, autocomplete means you won’t have to remember how to spell my surname! 😂
Click on a result and their Affinity ID will automatically be inserted for you.
Close the Formula Editor. We’ll fetch the relevant information and once done, you’ll see a “chip” rendered to the canvas. You can hover over this chip for a view of the information pulled from Affinity.

🔍 Find and 💡 Search

Fuzzy search formulas and columns help you to surface entities with limited knowledge

Maybe you’re just not one of those people that knows everyone’s Affinity ID off by heart, or perhaps you tend to forget the unique Profile Link for that start-up you’ve been eyeing out.
With the Affinity Pack, that doesn’t have to slow you down.
Find and Search columns and formulas take the queries you enter and return smart results, tailored to your own Affinity use. If your boss’ name is “John Smith”, Affinity will know who you’re referring to.

🔍 Find columns and formulas return only The Top Result. They’re useful when you’re looking for something in particular but don’t know the Affinity ID off-hand.
💡 Search columns return Multiple Results, and allow you to customize the number of results and level of detail (vs speed) in the Column Settings Panel.

🔍 Find Columns & Formulas

Drop-in replacements for the Entity columns and formulas, but with smart “best guess” logic.

These return a single result - the Top Match to whatever search term you provide. They are a stand-in replacement for the Entity Formulas and Columns, useful when you need to quickly find someone but don’t know their email address off-hand, can’t recall the spelling of their surname, or need to figure out who tried to call you from an unknown number.
Find Columns
🔍 Find Person
🔍 Find Org
Brian Sowards
Steven Hurtado
There are no rows in this table
Try type connor mcc into the “Find Person” column, and supsync into the “Find Org” column. Though both are inaccurate/incomplete, Affinity knows what you mean.
Do it for me!

Find Formula DEMO

Here’s a quick tool to browse your recent interactions with someone in your Affinity account.
Enter their name, email address, or another search term, and we’ll try find the right person, then list their recent interactions with you.
Search People.
steven hur

Your interactions with Steven Hurtado

First Email. -
First Event. 20 Apr 2022 - 10:00
Last Email. -
Last Event. 06 Dec 2022 - 05:00
Last Interaction. 06 Dec 2022 - 05:00
Next Event. 06 Dec 2022 - 11:00

Affinity Lists

Of course, the primary way that the Pack will be used is syncing their Lists into Coda. Lists in Affinity consist of one or more rows, where each row contains:
An Entity (all rows in a list are of the same entity type)
A set of Standard Fields (all Affinity users have these)
A set of Global Fields (set on an account level)
A set of Custom Fields (unique to each list)

To add a List to your doc, click ◫ Insert at the top right of the window, click on Packs and choose Affinity. Under the heading Tables is an option Affinity Lists. When you open that up, you will see three folders representing your lists grouped by the Entity Type of that particular list.

List of Co-Investors
Not synced yet
Firm Relationship
Investor Type
Firm Type
Sector Focus
Preferred Deal Stage
Index Ventures
Good Relationship
Venture Capital
E-CommerceEnterprise Software
Series ASeries ASeries B
Kleiner Perkins
Good Relationship
Private Equity
Series A
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
) instead.