Programatically schedule and trigger a field value update?
I would like to do the following and I'm not sure how to implement this. A user will enter phase information and the start date when this new phase will take place in a custom module record. When the start date is reached, I want the software to update the phase information in the associated Account record, all without human interaction. I am thinking of creating a Meeting event, followed by a workflow rule based on the Meeting module. Is there another way that is less clunky?
If not, can you provide more information on which trigger to use for the workflow rule based on the Meeting module?