Field compatibility

Understanding why certain fields are not compatible and cannot be synced

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

Trying to map a relation field and only seeing incompatible options

Understanding reference fields

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

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

How to find fields that are compatible with reference fields

  • If you're unsure how to create relation fields in your apps, check our docs on relation 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

Last updated

Was this helpful?