function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
PetyaPetya 

Estimate how much time is spent in a record type

Hello 
I have different record types and only if all conditions for example from the first record type are fulfilled, the user can go to the second record type. So I need to know how much time is spent in a record type.
Any ideas how to achieve this?

RoyGiladRoyGilad

Hi
Create a workflow or apex code that changes the recordtypeId when the cratiria are met (meaning all the fields you whant are fulfilled), the same WF (or code ) will save the time the recordType was changed in a new field (let's say a field named "ConvertTime__c").
Using the out-of-the-box Created Date field and your new dateTime field you could calculate the time between these dates, plus this sulotion will provide you a report how of many records changed RecordType per day for monitoring and KPIs.

BTW- how to calc diff between two dates:
https://success.salesforce.com/questionDetail?qId=a1X30000000IECvEAO
PetyaPetya
Thank you very much! I will check it.
For now I have date field and workflow for every record type and when the record type is changed, the date is saved in the date filed, and later I can use all this in formulas to estimate the difference and find the duration.