Foreign keys
An explanation of how to set up foreign key (aka reference) field relationships in Sheets
Foreign keys allow you to create relationships between tables in your synced Google Sheets.

How to set up foreign keys
1. Define a foreign key column
Create a column in the following format: Related_[Table Name]

Capitalization matters, so make sure the table name matches exactly.
2. Map the Foreign Key field in Whalesync

Google Sheets foreign key fields map with reference fields in other apps.
You will likely need to click "Referesh" to ensure Whalesync sees your newest fields
3. Insert Foreign Key values
To link a row from another table to your Foreign Key column:
Copy the Whalesync ID of the row you want to reference.
Paste the Whalesync ID into the foreign key column.

The Whalesync ID is a unique identifier for each row.
It is Column A in each mapped table in Google Sheets, and it is hidden.
Click on the arrow to unhide the Whalesync ID column.
Avoid making any changes to the Whalesync ID column to avoid sync issues.
Last updated
Was this helpful?