AndreasV
2007-10-29T10:41:00Z
Hello,

I want to sync the status of an appointment from my MS SQL DB to Outlook(one-way). Problem is that my DB BusyStatus can have values from 1 to 9 but the Outlook BusyStatus field can only have values 0 to 3.
Is it possible to make a convertion, or something similar, that will for eksamepel set DB values 2, 3 and 5 to Outlook value 1?
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2007-10-29T10:46:00Z
Yes,

please select the field and use the button "Conversion" (column must be linked to a DB field)
AndreasV
2007-10-29T10:50:00Z
I can only find the possibility to convert one value to another, not multiply values to one value?
I want to assign 2 or more DB values 1 Outlook value.
Administrator
2007-10-29T10:56:00Z
Not in GeniusConnect, but you can create a VIEW and convert the values in the View!
AndreasV
2007-10-29T11:37:00Z
Ok, got it working, thank you.