by SuiteCRM

The Ultimate Outlook Plugin Has Arrived - In response to user requests, SuiteCRM have created the ultimate Outlook plugin which is maintained by SuiteCRM developers. Our plugin supports Outlook 2010 upwards and includes two way synchronisation with CRM, Calender, Calls, Meeting, Tasks and Email Archiving.

Free 30 day trial
Try it Now

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

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


    a year 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...