Last Task Completed Subject on Contact with Hyperlink

Problem

To increase sales productivity, I want to see the last task's subject on contact records as well as a hyperlink so it can be used in contact list views and reports.

Solution

Create 3 Fields on Contact:

1. Text Field:  Last Task Completed

2. Text Field:  Last Task Completed ID

3. URL Field:  Last Task Completed Link

Rollup the Subject of the last task completed.

1. Select Destination Object:  Contact

2. Select Target Field:  Last Task Completed

3. Select Source Field

   1. Which Object:  Task

   2. Select Relationship:  Name ID-Task.WhoId

   3. Which Field:  Subject

   4. Select Type:  Text

4. Create New Filter (Most Recent Completed)

   1. Step 1) Enter Filter Name, Limit to 1 Record

   2. Step 2) Specify Sort Order

      1. Due Date Only

      2. Descending Order

   3. Step 3) Specify Filter Criteria

      1. isDeleted = false (default)

      2. Status = Completed

5. Save and Run the rollup.

Rollup the ID of the last task completed.

1. Select Destination Object:  Contact

2. Select Target Field:  Last Task Completed ID

3. Select Source Field

   1. Which Object:  Task

   2. Select Relationship:  Name ID-Task.WhoId

   3. Which Field:  Activity ID

   4. Select Type:  Text

4. Select Filter:  Most Recent Completed

5. Save and Run the rollup.

Workflow Field Update for Last Task Completed Link (Setup>Create>Workflow & Approvals>Workflow Rules>New Rule)

1. Object:  Contact

2. Rule Name:  Last Task URL

3. Evaluation Criteria:  created, and every time it’s edited

4. Rule Criteria:  Contact: Last Task not equal to Null

5. Immediate Workflow Action:  Field Update (Last Task Completed Link)

   1. Name:  Task URL

   2. Unique Name:  Task_URL

   3. Re-evaluate Workflow Rules after Field Change = True

6. Specify New Field Value

   1. Use a formula to set the new value

      1. 'https://slightning1-dev-ed.my.salesforce.com/' + Task_ID__c (Use the URL from your org.)

Create new Contact Reports and List Views.  You can customize your report and list views in any desired manner.

For further assistance with this use case or to learn more about Rollup Helper, please schedule a One on One Demo.

Need help?