by SuiteCRM

Official SuiteCRM Outlook Plugin v4 has arrived - Compatible with the Outlook Web App or Outlook 2016+ connected to Office365 or Exchange Server 2016. A complete rebuild developed and maintained by SuiteCRM developers, the addon retains previous functionality while massively improves performance, reliability and stability!

Free 30 day trial
Try it Now

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

Closed General Question created by hbar 6 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

    hbar

    6 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...
  • "The plugin works great! It's easy to install and configure. It would not work if you are using 64-bit Outlook. I could probably manually install the m..." - lhl94303

    Read More Reviews