Skip to main content

Hi,

 

I have a requirement to calculate the First Response Time of a case. When customer sends an email to our support team a case is created and immediately there is a auto response email goes. Then the support team picks the case and responds to customer. 

 

I have created a field "First Response Time" Date/Time datatype on case page and wanted to stamp the date when the first email that support team sends. I tried to create a Record Triggered Flow where I selected Object - Email Message.

Trigger the flow when : A record is created

Set Entry Condition - Status = Replied

Optimize the flow for - Actions and Related Records

Then I have given Update records condition as below image. This still doesnt work

 

Calculate first response time in Case Object

Any help much appreciated.

 

Thanks,

Sheeba

16 answers
  1. Sumeet Negi (Eptura) Forum Ambassador
    Jan 19, 2023, 1:17 PM

    Hi @Sheeba Mohan Try this -

     

    Change the start formula to the below and for the FromAddress put the support team email address in the formula. After doing this activate the flow and test once again

     

    AND(NOT({!$Record.Incoming}), ISBLANK({!$Record.Parent.First_Response_Time__c}), DATEVALUE({!$Record.Parent.CreatedDate})>=DATE(2023,01,19),{!$Record.FromAddress}='Put support email address here')

0/9000