Salesforce Connector: Using the ISO and Alpha 2 Fields

If you are using the BrightTALK Connector for Salesforce, we offer a built-in option to change the default Country values to either "Alpha 2" or "Full ISO format."

You can enable that feature by following these steps:

1) Creating a Custom field to hold the new value

2) Creating a Workflow to copy that value to your existing Country field

3) Changing the default setting on the Connector

Creating a Custom field to hold the new value

Since Salesforce does not allow Country values to be transformed "in real time" we will be using a custom field to temporarily hold the modified value.   This can be done by creating a standard "Text" field on both the Lead and the Contact record like this:

Creating a Workflow to copy that value to your existing field

Once you have the new fields setup, you'll want to create two workflows (one for the Lead field and one for the Contact field) to copy the data from those fields to your existing Country field:

Changing the default setting on your Connector

Once you have your custom field and workflow setup, go back into your Connector and change the field mapping for "Country" to your Custom field and change the setting to either "Alpha 2" or "Full ISO Format":