Two-way sync

Stacksync lets you sync your apps in real-time and two-way! Really! 🥳✨

Stacksync offers true two-way sync. Once set up, you can update data in either connected app and it will sync to the other in real-time.

Enabling two-way sync for a new Stacksync base is a straightforward process. Just switch the direction arrows to the two-way mode:

Toggle table sync to two-way sync

Read-only fields

Some tables contain fields that can only be read, but not written to. We call these managed fields which are read-only.

If you choose two-way sync, the read-only fields will only sync in one direction while the other fields will still sync two-way.

Example of read-only field in a base setup.

Some examples of read-only fields can be:

• the record id managed by your CRM

• last_modified_time managed by your CRM

• formula or computed fields managed by a certain platform

• read-only columns defined for a certain database user

Limitations

Two-way sync is not compatible with Database view sync If you are using a database view sync, you can only sync one way from your database to your other app. This is because it is not possible to write data to a view.

Stacksync does not "merge" duplicate records when you first turn on two-way sync

When initially activating two-way sync, duplicate data is not automatically merged. For a smoother experience, we recommend starting with one of your Apps to be empty (e.g. start with an empty database when syncing Postgres and Salesforce, or vice-versa). Once the synchronization is started, subsequent updates will seamlessly sync in both directions. Please refer to the details below for further information: