Comment on page
Affinity
Tables | Status |
|---|---|
People | ✅ Supported |
Organizations | ✅ Supported |
Opportunities | ✅ Supported |
Notes | ✅ Supported |
Lists | ✅ Supported |
Unless you are on Affinity's Enterprise plan, Affinity has significant API limitations which limits our ability to sync all records. To work around this, Whalesync groups your records into two categories:
- Records you care about (full records)
- Records you don't care about (shallow records)
Affinity has the following API quota limits on its plans:
- Free = none
- Premium = 100,000 calls/mo
- Enterprise = unlimited
Difference between full records and shallow records
Full records include every field you want to sync:
Shallow records only include the display name and email address (if applicable):
By default, Whalesync will sync records as shallow records. If you want to fully sync a group of records you must:
- 1.Add them to at least one list
- 2.Select to fully sync that list on the table mapping screen
Open table settings on the table mapping screen
Add the lists you want to fully sync
Affinity lets you add list-specific fields that only appear on specific lists:
Example of adding a list-specific field
List-specific fields show up in Whalesync as available fields to map with a prefix of the list like so:
Example of a list-specific Amount field on the "Pitch Requests" list
If you map the "Notes" table and intent to author notes in another tool such as Airtable or Notion, there's a limitation you should be aware of. When creating a brand new note, Whalesync is able to set all the note's properties: its contents and which people/organizations/opportunities it's associated with.
However, when editing a note, Whalesync can only modify the contents of the note. It cannot change the people/organizations/opportunities it's associated with.
Therefore we recommend setting a long sync delay on the "Notes" table mapping such that Whalesync only creates notes in Affinity once you've had the chance to set the appropriate references.
Edit mapping options for the "Notes" table
Set a long delay on the source of the notes
Notes in Affinity are usually stored as rich text. Under the hood, Affinity's internal representation of notes is Markdown, a simple formatting language. When you create notes within Affinity's UI, Whalesync sees those notes as being formatted in Markdown. You can map the contents of notes to a rich text field in tool such as Airtable and the formatting will correctly be synced.
However, due to a bug in the Affinity API, Whalesync is only able to edit notes in Affinity as plain text. When you create rich text notes in another tool and they're synced to Affinity, they will show up with the raw Markdown formatting like this:
Hello World!
This is **bold**, _italic_, ~~strikethrough~~, and `code`.
Here is a [link](https://en.wikipedia.org/wiki/Whale).
Last modified 1mo ago