# Selective row-level sync ## Overview Selective row-level sync lets you pause syncing for individual records without turning off your whole sync. Add a checkbox field (e.g., "Sync Enabled") in the source app you want to control from. When the box is unchecked, Whalesync will not sync that record. Re-check it and Whalesync will resume syncing the record. ## How to enable selective row-level sync ![Selective Sync Interface](https://2481481593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FtLaMDbvbGOow76E8CnqW%2Fuploads%2Fgit-blob-eee6ac6bce46e51de788978ccc48918b3dbe6654%2Fselective-sync.png?alt=media) 1. Edit your Whalesync base 2. Select the desired table 3. Open the **Advanced settings** tab 4. Enable the "Selective row-level sync" toggle for the app you want to control from 5. Choose the field that you want to use to control syncing. Only [compatible fields](#compatible_columns) will be available. 6. Save changes ### How it works * When the control field is checked, the record syncs normally. * When the control field is unchecked, syncing is paused for that record. * While paused, changes from either app are ignored for that record. * When re-enabled, Whalesync resumes syncing the record. {% hint style="info" %} The control field should not be a mapped column. {% endhint %} ### Compatible fields Only checkbox or boolean fields are eligible to use to control row-level syncing. Examples by app: * Airtable: Checkbox * Notion: Checkbox * Webflow: Switch * Postgres & Supabase: boolean * Google Sheets: boolean ## Behavior details * Paused means Whalesync detects the change but purposefully ignores it for that record. * The pause applies bi-directionally: edits in either connected app will not sync while paused. * Re-enabling resumes normal behavior. If both sides changed while paused, the most recent changes win (per Whalesync's versioning). * The sync overview can display how many records are currently paused in a table. ## FAQs ### Do I need to map the control field to the other app? No. The control field should only exist on the side you want to control from and should not be mapped. ### What happens if I edit a paused record on the other app? Changes are ignored while paused. When you re-enable syncing, edits made in either app will sync. If the same field was edited in both apps, the most recent change wins. ### Will the records still count toward my limits if they are paused? Yes. Selective sync is intended for temporarily pausing the syncing on a record while you edit it. The record still counts toward quota. ### Can I use filters with selective row-level sync? Yes. Table filters and selective row-level sync are additive. If a record is filtered out, it will not sync regardless of the control field. ### Does this replace using a "Draft" status in my CMS? No. Draft status may hide content on your site. Selective row-level sync simply pauses syncing, so your live content can remain published while you edit. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.whalesync.com/features/additional-features/selective-sync.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.