I h ave a little trigger program to be written up.
I need the custom object Devices (object API name CI) to update the field "Description" via a workflow named: "DEVICE: Update the Description in the Device field".
The Description field changes every time I make a change to a Device record.
What I want though is to make the field "Description" in object Device dynamically updating as the Service Contract is updated or when the Service Contract "end dates" expire.
Following scoped solution:
A trigger that fires off every time a Service Contract (only Service Contracts that are not of record type "Professional Services Contract") when:
The "End Dates" have changed"
On a the fire of a check box called "Alter Device Description by Trigger" - I will be using this in time-based workflows to fire off the trigger.
Trigger actions: Looks at the related Devices and basically updates the record (without changing anything). Updating the record with fire off workflow triggers which automatically update the field "Description"