Skip to content
View as MarkdownOpen in ClaudeOpen in ChatGPT

Foreign keys

Set up foreign keys in Google Sheets with a Related_[Table Name] column holding Whalesync IDs, mapped to linked records or reference fields in other apps.

Foreign keys allow you to create relationships between tables in your synced Google Sheets.

An example of a foreign key field relating People to Tasks

How to set up foreign keys

Section titled “How to set up foreign keys”

1. Define a foreign key column

Section titled “1. Define a foreign key column”

Create a column in the following format: Related_[Table Name]

Here our column name is "Related_People" because we're relating Tasks to the People table

2. Map the Foreign Key field in Whalesync

Section titled “2. Map the Foreign Key field in Whalesync ”

Google Sheets foreign key fields map with reference fields in other apps.

3. Insert Foreign Key values

Section titled “3. Insert Foreign Key values”

To link a row from another table to your Foreign Key column:

  1. Copy the Whalesync ID of the row you want to reference.
  2. Paste the Whalesync ID into the foreign key column.
Copying the Whalesync ID from a person in the People's table into the "Related_People" column in Tasks
  • 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.