Prerequisites

• •Configure Salesforce Change Data Capture.
• •Create a custom field in the Salesforce Opportunity entity.
• •Configure Salesforce Apex Triggers.

Configuring Salesforce Change Data Capture

1. 1Log in to the Salesforce account.
2. 2Go to Setup > Build > Develop > Change Data Capture.
3. 3From the Available Entities list, select the Opportunity (Opportunity) object and add it to the Selected Entities list.
The following image shows the Change Data Capture page:

4. 4Click Save.

Creating a custom field in the Salesforce Opportunity entity

1. 1Log in to the Salesforce organization.
2. 2Go to Setup > Build > Customize > Opportunities > Fields, and then click New.
The following image shows the New button on the Opportunities Fields page:

3. 3In the Field Label field, enter File ID, and in the Field Name field, enter File_ID. Click Next and save the custom field.
You must create a custom field with the Text data type.
The following image shows the New Custom Field page:

Configuring Salesforce Apex Triggers

1. 1Log in to the Salesforce organization.
2. 2Go to Setup > Build > Develop > Apex Triggers > Developer Console.
The following image shows the Apex Triggers page:

3. 3In the Developer Console, go to File > New > Apex Trigger as shown in the following image:

4. 4Enter the trigger name, select Opportunity from the sObject list, and then click Submit.
5. 5Enter the following code snippet and save the trigger.
trigger {trigger name} on Attachment (after insert) {
Map<Id, String> oppUpdates = new Map<Id, String>();

for (Attachment att : Trigger.new) {
if (String.valueOf(att.ParentId).startsWith('006')) {
oppUpdates.put(att.ParentId, att.Id);
}
}

if (!oppUpdates.isEmpty()) {
List<Opportunity> oppToUpdate = [SELECT Id, Name FROM Opportunity WHERE Id IN :oppUpdates.keySet()];
for (Opportunity c : oppToUpdate) {
c.File_ID__c= oppUpdates.get(c.Id);
}
update oppToUpdate;
}
}