Apex Code Development You need to sign in to do that
Don't have an account?
SeanO Workflow rule for capturing how long something has been in a certain status
I am trying to see how long a record has been in each status.
So we have 5 status
Submit Request
Assigned
More Info Needed
Reaching out to Publishers
Closed
I want to track how long in minutes this record spent in each status. I have created fields for all the dates and I have field updates made. Where I am getting stuck is how do I create a workflow rule that will update "More info needed close date" with "now()" when it leaves a stage. I know how to create when it goes into the stage but how do I have it update the date field when it leaves a stage.
thanks in advance
So we have 5 status
Submit Request
Assigned
More Info Needed
Reaching out to Publishers
Closed
I want to track how long in minutes this record spent in each status. I have created fields for all the dates and I have field updates made. Where I am getting stuck is how do I create a workflow rule that will update "More info needed close date" with "now()" when it leaves a stage. I know how to create when it goes into the stage but how do I have it update the date field when it leaves a stage.
thanks in advance
This requirement is not possible via Workflow,
Youhave to write an Apex Class and Trigger for that.
The trigger should be fired every time the record is edidted. -> Then, we have to save the edit time and the status code -> Now get the difference and display result.
Regards,
Ashish
In trigger get the created dateTime(for frequent stage you can refer modified date) and now() dateTime and differnce will yields time spen on each stage.
Regards,
GM
you can write a formula for this requirment by using ISCHANGE u can achive it.
Regards,
pradeep.