I am following an Account and want to be notified whenever a new Opportunity is created for that account. Is that available out of the box with Chatter? It seems somewhat obvious but I can't find an FAQ or discussion board entry on it.
If this is not available today, would an apex Trigger be the way to create such functionality?
I need a field in the opportunity object that reflects the number of days since any activity linked to the opportunity was updated (Last Modified Date on Activity record). This can either be a task or an event which is open or completed.
Since this field is not accessible as a rollup on the opportunity, I'm guessing I have to create a trigger to do this. Any ideas?
