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!

Cancel at any time!
Free Trial

#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...
  • "How to enable "Sync to outlook" checkbox? I follow the instruction and display on Edit/Detail view. The "Sync to outlook" checkbox appear in the pane..." - Yathit

    Read More Reviews