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
Eric BollerEric Boller 

Last Activity By Lead Owner

How can I create a trigger (and is a trigger needed?) that updates a field based on the last activity on a lead by lead owner? I currently have the below formula field but that references any activity.

IF(OR(ISBLANK(LastActivityDate), LastActivityDate < (TODAY()-30)), "No", "In Window")
KaranrajKaranraj
Eric  - You can do that using workflow rule 

1. Create the workflow rule on the lead object
2. Choose your evaluation criteria 
3. In the rule criteria select formual evaluates to true and keep the below formula
If(LastModifiedById  ==  OwnerId,true,false)
4. Then in the workflow action do your field update operation.

Thanks,
Karan
Eric BollerEric Boller
Thanks for the information! We want to measure Activity though, and not necessarily Modified. How would we go about doing that?