Welcome to another post in the “How I Solved It” series. In this series, we do a deep dive into a specific business problem and share how one #AwesomeAdmin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Dee Ervin closed the gaps in Activity tracking and then read all the details in the post below.
Case Management in Salesforce is facilitated through support processes that advise case statuses within the support lifecycle. When moving from one case status to the next, there are usually a series of Activity records created for emails, calls, meetings, etc., with customers/clients. However, these activities usually don’t include research, internal communications, or any activities that support the client interactions. Managers need a comprehensive report to reflect the time spent across all related case activities, as well as an understanding of activities when a case is reopened. This comprehensive view can be achieved with Flow, a standard object, and minimal user adoption effort!
To memorialize the status and type (that is, new or reopened) of the case, I created two picklist fields on Task layout. The last field I created is a formula field to calculate Completed Date/Time - Created Date.
1. Field: Case Status*
a. Data Type: Picklist
b. Description: Status of related case at the Activity record was created.
c. Values: {Values in standard Status field on the Case object}
d. Additional Note: Make “Read Only” on page layout
*Tip: To ensure the Status field on the Activities object aligned with any case status values now and in the future, I unchecked the “Restrict picklist to the values defined in the value set” field. This will seamlessly add any new values to the list as inactive values.
2. Field: Case Type
a. Data Type: Picklist
b. Description: Advises if related case is “New” or “Reopened”
c. Values: New, Reopened
d. Additional Note: Make “Read Only” on page layout
3. Field: Status Duration ({time measurement})
a. Data Type: Formula [Number, (16, 2)]
b. Description: Time within the status of the related case
c. Value**: ((Completed Date/Time - Created Date)*1440)/60
i. Multiply by 1440 to calculate minutes.
ii. Divide minutes by 60 to calculate hours.
**This does not consider business hours or weekends, but this formula can be updated to take these two items into account.
1. Configure Start element to trigger when a case is created or updated with the status equal to {default status when a new case is created} OR if the status is changed. I optimized the flow for actions and related records. There are two reasons for this: 1) Fast Field Updates is best used when there is only one object involved in the flow, and 2) The actions for this flow require the Case record to be saved to the database before creating and updating related Tasks.
2a. Add a Get Records element to find Task records related to the case; specifically, to find the most recent case status Activities Task record.
2b. To filter the Tasks to find the Case Status Activities Task, I created Text Variable based on the naming conventions I have set for these Task records, so this Text Variable has a default value of my unique subject line identifier.
3a. Once the Task records have been queried in the Get Records element, I set up a Decision element to create logical action paths. This first path covers the outcome of an open task found on an open case.
3b. This second path covers the outcome of no task found on a new case.
3c. This third path covers the outcome of no open task found on a reopened case.
3d. This fourth path covers the outcome of an open task found on a closed case. The importance of this path is to ensure when a case is closed, a new Task record is not created and any open Case Status Activities Task record is closed.
3e. This fifth path covers the outcome of a closed task found on an open case. The importance of this path is to ensure a new Case Status Activities Task is created when the previous Case Status Activities Task is closed.
4. Although the flow has five custom outcome paths, there are only three resulting actions. To keep each scenario represented, I used connectors to apply one action to multiple paths. The first action is an Update Records element to update Task record to closed. This action applies to both outcome 1 and outcome 4.
5a. The second action is a Create Records element to create a new Task record. This action applies to both outcome 2 and outcome 5.
5b. To apply the correct Case Type to the new Case Status Activities Task, I created Formula Variable [IF(TEXT({!Get_Status_Activity_Task.CaseType__c})=“Reopened”,“Reopened”,“New”)] which references the Task output of the Get Records element to check the Case Type of the most recent Case element and apply it to the new Task record. This formula was required because I reused this Create Records element for both Case Status Activities related to new and reopened Case records. Formula:
5c. To apply a consistent naming convention to each Case Status Activities Task record created, I created another Formula Variable to concatenate the Status of the related Case record, and a suffix as a unique identifier, “_Status Activities”.
6. The third action is a Create Records element to create a new Task record when a case is reopened. This action applies to outcome 3 only. The reason why this isn’t combined with the second action is because it particularly handles the initial reopening of a case.
With this process in place, it will be easy to create time-tracking reports and differentiate Activities between statuses on new and reopened cases. With the new fields on Task records, other automation could be created to update all Activities records with Case Status and Case Type values. This will further support comprehensive reporting on standard Activities, and Case Status Activities tracking.
Although this solution was focused on cases, this concept could be applied to any object using stages or statuses to manage the process. Examples include, but are not limited to, Opportunities, Leads, etc.
Welcome to another “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one Awesome Admin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Dee Ervin searched unsearchable field data […]
Welcome to another “How I Solved It.” In this series, we do a deep dive into a specific business problem and share how one #AwesomeAdmin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Rachel Park Brayboy used her sewing (and […]
Welcome to another post in the “How I Solved It” series. In this series, we do a deep dive into a specific business problem and share how one #AwesomeAdmin chose to solve it. Once you learn how they solved their specific problem, you’ll be inspired to try their solution yourself! Watch how Christina Nava used […]
