Notes:
Pre-Requisites
- This tutorial requires use of the Account Team Member object in Salesforce.com.
- If you do not have this enabled, you may still leverage concepts used in this tutorial to work with a separate picklist object.
Best Practice
- You can create a CSM Lookup field in the Salesforce object Customer Info.
Account Team Member Object
This tutorial uses the Account Team Member object in SFDC. You can use other SFDC objects to setup the same rule based on your organization's configuration.

If your company uses the Account Team object in SFDC, review to determine the Team Role that will map to the CSM.
Select an account to define an Account Team.
Create CSM Field in the Customer Info Object
Create a custom field CSM in the SFDC object Customer Info. This provides a placeholder to tie back to the Account Team Member object to copy the CSM names into the Customer Info object.
To create a custom field:
- Navigate to Setup > Create > Objects.
- Select the object Customer Info.
- Click New in the Custom Fields & Relationships section.
- Select Lookup Relationship in the New Custom Field page. Click Next.

- In the Choose the related object page, select User in the Related To option and click Next. This object can be related to User object as you fetch CSM user names.

- Assign Field Label CSM and Description (Optional) in the Create Custom Field screen and click Next.

- By default, there are a few field level security requirements enabled in this page. To change any security requirements, consult your SFDC administrator. In this case, select Visible and click Next.
- Click Save to create the field. There are no updates required in this page.
Create a Bionic Rule
Create Rule
In the Create Rule page:
- Enter the following information:
- Rule Type: Bionic
- Rule For: Account
- Rule Name: Admin: Pull CSM Name from Account Team Member
- Folder: Select a folder for the rule.
- Description: (Optional) Something denoting intent of the rule
- Click Next.

Setup Rule
In the setup Rule page:
- Create a Dataset Task with the following information:
- Task Name: CSM Info from Account Team Member
- Task Description: (Optional)
- Output Dataset Name: CSM Info from Account Team Member
- Select Salesforce and Account Team Member object.
- In the Show Fields section, select:
- Account Team Member::Account Id
- Account::Account Name
- Account Team Member::Team Role
- Account Team Member::User ID Name
- Account Team Member::User ID
- In the Filters section, select Account Team Member::Team Role / equals / Account Manager
- Select Account Lookup: Account ID and click Save.
Setup Action
Setup an Action on the created Dataset with the following configurations:
- Action Type: Load to Customers
- Field Mappings:
- Account Team Member::Account Id REFERENCE -> Account (Reference)
- AccountTeamMember:: User ID REFERENCE -> CSM (Reference)
- Select the Criteria: Account Team Member::User ID / not equals / value / NULL (click the checkbox: Exclude records where User ID is Null)
- Click Save.
Validate/Schedule the Rule
When the rule is executed, any new rules will have CSM information available in the Customer Info object.
To demonstrate use of the CSM lookup field, in the test rule:
- In the Show Fields section, select:
- Account::Id
- Account::Account Name
- Customer Info::CSM
- Customer Info::CSM Name
- In the Filters Field, select Customer Info::CSM / Not equal to / NULL (check the checkbox) -- this ensures we don't pick up NULL fields
- Click Next.
Create a Test Action

Scheduling
You can schedule this rule to run on a daily basis to pick up any changes in the Account Team Member for each Account. For more information on how to schedule the rules, refer Scheduling and Executing Rules.