Apex Code Development (89866)
General Development (54727)
Visualforce Development (37145)
Lightning (17579)
APIs and Integration (16773)
Trailhead (11582)
Formulas & Validation Rules Discussion (11172)
Other Salesforce Applications (8010)
Jobs Board (6637)
Force.com Sites & Site.com (4797)
Mobile (2662)
You need to sign in to do that
Don't have an account?
Eric Fortenberry How can I generate a report of all contacts without open activities? I've tried multiple of the standard reports and can't seem to make this happen. Any ideas would be much appreciated!
You're on the right track. You can't do this with a standard report. You'll need a field on the Leads or Contacts for # of Open Activities, but it'll have to be a number field that is populated by a trigger.
See this other thread about the trigger. Keep in mind that trigger does not include Events, only Tasks, so you'll have to modify it if you want to include Open Events.
All Answers
I thought one way might be to create a field on the contact for # of Open Activities and then run a contact report where Open Activites = 0. However, I was not able to add such a field...
You're on the right track. You can't do this with a standard report. You'll need a field on the Leads or Contacts for # of Open Activities, but it'll have to be a number field that is populated by a trigger.
See this other thread about the trigger. Keep in mind that trigger does not include Events, only Tasks, so you'll have to modify it if you want to include Open Events.