Google Sheets
Last updated
Was this helpful?
Last updated
Was this helpful?
📝 Text
📅 Date
#️⃣Percentage
Some things to note before turning on syncing.
Whalesync uses the name of a sheet (i.e. tab in a workbook) for syncing.
Avoid changing the name of a sheet after setting up your sync. This will break the sync configuration.
Whalesync uses the first row to enable syncing with Google Sheets. By default, Whalesync freezes the first row to preserve these fields.
Avoid making changes to the first row during the initial sync.
This will cause sync problems as Whalesync uses that row to sync your data.
Whalesync uses the first column, normally hidden, as a "Whalesync ID" to enable syncing with Google Sheets. This column is automatically created in column A to track records.
You are free to rename columns after setting up a sync.
Do not use "Sort range" on sheets that are syncing! This will cause sync problems as it changes the row IDs.
Number
Currency
Drop-Down
Checkbox
How to format field types
How to add foreign key fields
