You need to sign in to do that
Don't have an account?
HD Manager
Possible to have a date field update when a certain field is edited?
There does not appear to be a way to make a custom date field that updates to todays date whenever a field is edited. Does anyone have some insight?
Basically I have a 'Offer Comments' field, and a corresponding 'Offer Comments Date' field that should show the date the Comments field was last edited. How can I implement this? It does not seem possible with the available criteria with a workflow rule.
Any help is appreciated!!
Basically I have a 'Offer Comments' field, and a corresponding 'Offer Comments Date' field that should show the date the Comments field was last edited. How can I implement this? It does not seem possible with the available criteria with a workflow rule.
Any help is appreciated!!
Evaluation Criteria: Evaluate the rule when a record is created, and every time it’s edited
Rule Criteria: ISCHANGED(Offer_Comments__c)
Workflow Actions - Field Update:
Field to Update: Offer Comments Date
Formula Value: today()
The above Workflow will detect a change in the Offer Comments field, then update the Date field with today's date.
All Answers
Evaluation Criteria: Evaluate the rule when a record is created, and every time it’s edited
Rule Criteria: ISCHANGED(Offer_Comments__c)
Workflow Actions - Field Update:
Field to Update: Offer Comments Date
Formula Value: today()
The above Workflow will detect a change in the Offer Comments field, then update the Date field with today's date.