You need to sign in to do that
Don't have an account?
Oliver Freeman 9
Field for time since last modification to a specific field in a custom object
Hey Guys,
I'm currently working on adding a field to a custom object (Repair) that will display the time since the last change/modification of a certain field within the Repair object (Asset Location).
Similar to Last Modified Date/Time, but field specific, if that makes sense?
So essentially what I'm wanting to use this for, is when a repair spends a certain amount of time with the asset sat in a particular location, an email alert is sent to the team leader and case owner.
Thanks in advance for any help!
Oli
I'm currently working on adding a field to a custom object (Repair) that will display the time since the last change/modification of a certain field within the Repair object (Asset Location).
Similar to Last Modified Date/Time, but field specific, if that makes sense?
So essentially what I'm wanting to use this for, is when a repair spends a certain amount of time with the asset sat in a particular location, an email alert is sent to the team leader and case owner.
Thanks in advance for any help!
Oli
As mentioned in my post above, you need to use the 2nd Evaluation criteria
That should work !
All Answers
You can setup a workflow on the Repair object to achieve this. You will have to create a custom Date field or a Datetime field to capture this.Your workflow would be as below.
Evaluation Criteria : Everytime a record is either created or updated (2nd Option)
Workflow Entry Formula
In the above formula, replace the fieldname__c with the field for which you want to capture the last change. Use the insert field option to use the right API name of the fields.
Workflow field Update Formula
The formula to update the Date or Datetime field depending on the field type that you create would be as below.
Date field formula
Datetime field formula
Simply activate your workflow and you are good to go !
Kindly mark it as an answer if that works for you.
I'm getting the following error when trying to add this formula to the entry criteria on the workflow:
"Error: Function ISNEW may not be used in this type of formula"
Thanks,
Oli
As mentioned in my post above, you need to use the 2nd Evaluation criteria
That should work !
Thanks for your help - I found that it worked better to use Process Builder for this rather than a standard workflow.
All up and running as I wanted now though.
Thanks again,
Oli