by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - A complete plugin rebuild developed and maintained by SuiteCRM developers entirely from scratch, the addon retains previous functionality while massively improves performance, reliability and stability!

Cancel at any time!
Free Trial

#1390 - Location of "Sync to Outlook®:" field in database [Answered]

Closed General Question created by hbar 2 years ago

I need to update the checkbox on about 6000 contacts from unchecked to checked.
I want to update this directly in the database dues to the large number of contacts.
What table is the "Sync to Outlook®:" field located in?
Database field name?

  1. hbartel member avatar


    2 years ago

    Turns out that Sync to Outlook is not a property of the contact but instead a relationship between a contact and a user. Some users could be syncing the contact while other are not syncing it. As a result checkbox is checked when a record for the current user and contact exists in contacts_users table.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...