function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
CafeCafe 

Workflow based on lack of activity

Hi,
I'm trying to create time-based workflow that will trigger 90 days after an opportunity is created if there has been no activity on the opportunity for 30 days. I can't figure out how to set the criteria for workflow based on activities. Has anyone been able to do this? Thanks in advance for the help!
Steve :-/Steve :-/
I'm digging through by code library right now, but off the top of my head you should be able to do it with a Workflow Rule. 

On the Opportunity Object you can get a handle to all the the necessary fields the you need to evaluate for your trigger:

Opportunity.IsClosed
Opportunity.CreatedDate 
Opportunity.LastActivityDate
 
Steve :-/Steve :-/
Have you tried this

Code:
AND (
NOT(IsClosed),
OR(
(TODAY() - LastActivityDate > 30),
ISNULL(LastActivityDate)))

 plus a Time Dependant Workflow = 90 Days After Created Date





Message Edited by Stevemo on 01-15-2009 01:21 PM