To effectively manage a large caseload, your team needs to know which clients are being engaged and which might be falling through the cracks. The Case Status - Set Last Message Sent flow provides real-time visibility by "stamping" the exact time of the most recent client communication directly onto your Matter or Intake records.
By automating this timestamp, your firm can build powerful reports and dashboards to track attorney responsiveness and client engagement levels without manual data entry.
How the Flow Works
This is a Record-Triggered Flow that monitors the Case Status Message object. Whenever a qualifying message is created, the flow identifies the associated record and updates a specialized timestamp field.
The "Qualifying" Message
To ensure your data remains accurate, the flow only updates the timestamp when a message meets specific criteria:
Client-Linked: The message must be associated with a Party (client).
Standard Messaging: The message must be a standard communication (Topic:
CaseStatus; Name:message).Record Association: The message must be linked to a Matter (or Intake).
What Happens During Execution?
Detection: A new client message arrives in Salesforce.
Routing: The flow determines if the message belongs to a Matter or an Intake.
Stamping: * If it's a Matter, it updates:
Last_Message_Sent_Case_Status__c.If it's an Intake, it updates:
Last_Message_Sent__c.
Completion: The timestamp is now available for use in List Views, Reports, and Page Layouts.
Operational Benefits
Proactive Management: Build a List View of "Matters with no messages in 30 days" to identify cases that need attention.
Performance Insights: Report on the average time since the last message across different practice areas or case managers.
Audit Readiness: Maintain a permanent, high-level record of engagement frequency for every case in your system.
Testing & Validation
If you are a Salesforce Administrator setting this up, use these steps to verify the automation:
Test Case | Steps | Expected Result |
Matter Update | Create a message for a Matter with the Name "message" and Topic "CaseStatus". | The Matter's |
Exclusion Test | Create a message but leave the Party field blank. | The timestamp does not update (prevents system notes from skewing data). |
Intake Update | Create a message specifically for an Intake record. | The Intake's |
Administrative Note
Permissions: Ensure your Integration User and standard users have "Edit" access to the
Last_Message_Sent_Case_Status__candLast_Message_Sent__cfields.Time Sources: The flow uses
$Flow.InterviewStartTimefor Matters and$Flow.CurrentDateTimefor Intakes. Both represent the moment the message was processed by Salesforce.