Filters

Set filters that determine which data syncs

Adding a filter that will only sync records a field value is true

Filter settings can only be edited before the initial sync

When you are creating a new table mapping, you are able to set filters. Once data in those tables sync, you cannot change the filter settings.

Filters sync the final update before future updates are excluded

For instance, if you change a record from ‘John’ to ‘Sarah’ in Google Sheets, Whalesync will sync this last update to Affinity. After that final sync, changes to the now 'Sarah' record will be filtered out.

Updating a record in a way that removes it from the filter

FAQ

1) Will setting a filter delete any of my existing data?

No, adding a filter won’t remove existing data. Filters apply to any future updates.

2) Are filters case sensitive?

Yes.

This will only sync records that equal "John" and will not sync records that equal "john"

3) How should I write percentage values?

Percentage values should be written as numbers.

This will only sync records that have a "Percent" value above 10%