When planning your flexible database for CRM integration the data type matching is very important. If CRM boolean or two option fields are included it is best to plan how to translate their values between Acoustic Campaign and CRM.

The best method found thus far to match the fields and account for NULL values is to use a CHOOSEBYVAL function list in Scribe Online in both directions, regardless of the field format in CRM or the field type in Acoustic Campaign.

CHOOSEBYVAL evaluates a list of values and returns the result associated with the first value that is equal to the expression. If no value is matched, the default result is returned. If no default result is specified, a record error is returned. An optional single default result at the end of the list is the default, if none of the values is a match.

For example, consider the following sample code, in which the synchronization direction is from Acoustic Campaign to CRM:

CHOOSEBYVAL( IMCDB_Contact.Field, 'IMCTrueValue', True, 'IMCFalseValue', FCHOOSEBYVAL( crmentity.field, True, 'IMCTrueValue', False, 'IMCFalseValue', NULL, NULL )	alse, NULL, NULL )

As shown in the sample code, if the Acoustic Campaign value is true, then the function indicates the CRM to use the True option, If the IMC Value is False, the function indicates the CRM to use the False Option. If the Acoustic Campaign value is Null, the function indicates the CRM to use NULL. Similarly, consider the following sample code, in which the synchronization is from CRM to :

CHOOSEBYVAL( crmentity.field, True, 'IMCTrueValue', False, 'IMCFalseValue', NULL, NULL )

As per the sample code, if the CRM option is true, the function indicates the Acoustic Campaign to use the True value, If the CRM option is False, the function indicates Acoustic Campaign to use the False value. If the CRM field is NULL, the function indicates Acoustic Campaign to use NULL.