LogoLogo
WelcomeGet Started
  • What is Whalesync?
  • Start Here
    • Quick start
    • Video tutorials
  • Popular Syncs
    • Webflow + Airtable
    • HubSpot + Notion
    • Supabase + Airtable
    • Notion + Google Sheets
  • Connectors
    • Affinity
      • Authorize Affinity
      • Full records vs. shallow records
      • List-specific fields
      • Notes in Affinity
    • Airtable
      • Airtable view sync
      • Airtable API quota
    • Attio
    • Google Sheets
      • Formatting columns
      • Foreign keys
      • Multi-select fields
      • Avoid sort range
      • Whalesync ID column
    • HubSpot
      • Associations
      • Webhooks
      • Merging records
    • Memberstack
      • Authorize Memberstack
      • Memberstack custom fields
    • Notion
      • Notion page sync
    • Postgres
      • Authorize Postgres
        • AWS (RDS)
        • Basedash
        • DigitalOcean
        • Heroku
        • Neon
        • Render
        • Supabase
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Salesforce
    • Stripe
      • Authorize Stripe
    • Supabase
      • Adding default values to primary keys
      • How to sync Airtable linked records with Supabase foreign keys
      • Why does Whalesync create a database user?
      • Why do I need an ID column?
      • SQL scripts
      • Primary key snippets
      • Foreign key snippets
      • Terminology
      • Multiple foreign keys in a single field
      • How to sync Postgres views
    • Webflow
      • Supported fields - (AT x WF)
      • Webflow Memberships sync
      • Webflow status field
  • Previous connectors
    • Bubble
      • Authorize Bubble
    • Close
    • Copper
    • MS Dynamics CRM
    • Outreach
    • Pipedrive
      • Pipelines
    • Shopify
      • Authorize Shopify
      • Syncing images
      • Syncing variants
      • Tutorial videos
      • Theme Template field
    • WordPress.com
    • WordPress.org
      • Quick Start Guide: WordPress.org
      • Authorize WordPress.org
      • Advanced Custom Fields (ACF)
      • How to sync images
      • Supporting tables
      • Tutorial
      • WordPress status field
    • Zoho CRM
  • Features
    • Two-way sync
    • Issues
    • Operations
    • Record matching
    • Filters
    • Auto-create tables
    • Additional features
      • Automapping
      • Creating users via Whalesync
      • Delete protection
      • File hosting
      • HTML and Markdown field extensions
      • Relation fields
      • Sync preview
  • Resources
    • Support
      • Sync behavior questions
      • Common errors - Airtable
      • Common errors - Notion
      • Common errors - Postgres
      • Common errors - Webflow
      • FAQ
      • Field compatibility
      • How to get record IDs
      • How to change your sign-in
      • How to change your email
      • How to add additional email addresses
      • How to update your tax ID number
      • How to create a slug field in Airtable
      • Known issues
      • Multi-select to multi-reference
      • Transfer Webflow site to another account
      • Troubleshooting attachment fields
      • Webflow deprecating v1 APIs
    • Template Packs
  • YouTube
  • Security
  • Changelog
Powered by GitBook
On this page
  • Why fields must be compatible
  • Relation fields and compatibility
  • Table of compatible fields
  • Normal text
  • Rich text (HTML, Markdown)
  • URL
  • Number
  • Currency
  • Checkbox / boolean
  • Date/time
  • JSON
  • Relation

Was this helpful?

  1. Resources
  2. Support

Field compatibility

Understanding why certain fields are not compatible and cannot be synced

PreviousFAQNextHow to get record IDs

Last updated 1 month ago

Was this helpful?

Why fields must be compatible

When syncing, you must map "compatible fields" so that Whalesync can translate data between your apps. In this translation, Whalesync handles much of the heavy lifting (like converting HTML to Markdown), but ultimately the data in these fields needs to work with each other.

Relation fields and compatibility

Understanding reference fields

Relation fields must be mapped to other relation fields in order to sync.

How to find fields that are compatible with reference fields

  • In general, look for the squiggly arrow icon indicating a relation field (see screenshot above).

Table of compatible fields

Field type (from: left, , to: top)
Normal text
Rich text
URL
Number
Currency
Checkbox / boolean
Date / time
JSON
Relation

Normal text

✅ Compatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

Rich text

✅ Compatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

URL

✅ Compatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

Number

❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

Currency

❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

Checkbox / boolean

❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible
❌ Incompatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible

Date / time

❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible
❌ Incompatible
❌ Incompatible

JSON

✅ Compatible
✅ Compatible
✅ Compatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible
❌ Incompatible

Relation

❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
❌ Incompatible
✅ Compatible

Normal text

If a normal text field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Normal text

  • Rich text

  • URL

Incompatible

  • Number

  • Currency

  • Checkbox / boolean

  • Date / time

  • JSON

  • Relation

Rich text (HTML, Markdown)

If a rich text field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Normal text

  • Rich text

  • URL

Incompatible

  • Number

  • Currency

  • Checkbox / boolean

  • Date / time

  • JSON

  • Relation

URL

If a URL is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Normal text

  • Rich text

  • URL

Incompatible

  • Number

  • Currency

  • Checkbox / boolean

  • Date / time

  • JSON

  • Relation

Number

If a number field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Number

  • Currency

Incompatible

  • Normal text

  • Rich text

  • URL

  • Checkbox / boolean

  • Date / time

  • JSON

  • Relation

Currency

If a currency field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Number

  • Currency

Incompatible

  • Normal text

  • Rich text

  • URL

  • Checkbox / boolean

  • Date / time

  • JSON

  • Relation

Checkbox / boolean

If a checkbox/boolean field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Checkbox / boolean

Incompatible

  • Normal text

  • Rich text

  • URL

  • Number

  • Currency

  • Date / time

  • JSON

  • Relation

Date/time

If a date/time field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Date / time

Incompatible

  • Normal text

  • Rich text

  • URL

  • Number

  • Currency

  • Checkbox / boolean

  • JSON

  • Relation

JSON

If normal text is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Normal text

  • Rich text

  • URL

  • JSON

Incompatible

  • Number

  • Currency

  • Checkbox / boolean

  • Date / time

  • Relation

Relation

If a relation field is the source field, then the following are compatible/incompatible options to sync to:

Compatible

  • Relation

Incompatible

  • Normal text

  • Rich text

  • URL

  • Number

  • Currency

  • Checkbox / boolean

  • Date / time

  • JSON

One of the more advanced field types to map are (aka "reference fields", "linked records", or "foreign keys"). These are fields that have a relation to another table.

If you're unsure how to create relation fields in your apps, check .

"relation fields"
our docs on relation fields
Trying to map a relation field and only seeing incompatible options