06-21-2013 07:54 AM
We are a fairly small company just trying to get our users(14 total) familiar with ACT. For these first few weeks we've had everyone working on adding histories to contacts when they talk with a customer, adding opportunities for loans in the pipeline, and creating new contacts for prospects that weren't in our core system.
To track how much users have or haven't been doing, I've been working with pulling up reports related to the histories added this week, by contact. Unfortunately this also pulls up a line for each user, when we really want it to just be for the customers contacted this week. Our Outlook calendars are synced with ACT, so we've got a lot of "appointment completed" that are taking up space on this report.
Is there a way that anyone knows of to simply log no history for a particular contact, in this case a database user? For this week's reports I went through each user individually and deleted the history, but that's quite tedious and isn't going to be a long term solution.
Or, any other ideas for a work-around when trying to see what kind of histories our users have added for the week?
06-21-2013 12:46 PM
The only way to filter these out of a report is to use a 3rd party reporting tool.
Like Stonefield Query, CRystal Reports, TopLine Dash, or Durkin Impact.
If you are hand with access or Excel, it is possible to do it there, but requires some advanced skills.
06-21-2013 07:35 PM
06-21-2013 08:18 PM
If you only need a count, check the History Summary Classic report.
06-21-2013 09:56 PM
This isn't a perfect answer, but it'll save you a lot of time vs. going to 14 records and still allow you to use the "native" reporting. There are definitely 3rd party dashboards / reporting tools that can filter this out, but if you just want to delete user history as quickly as possible, I would create a Group that contains all the Contact records for the Users of the database and then delete the History via the History tab on that Group, so you can do it all in one shot.
I believe there's one that exists in new databases called "Database Users", but I'll go through how to create that one if you don't have it.
Here's how you'd do that:
1. Create a new group - I'll call mine All Users (or "z All Users" if you prefer it to be at the bottom of your list of groups)
2. Click on the "Contacts" tab for that Group and click "Add/Remove Contacts..."
3. Click the "Edit Criteria" button
4. Create Contact criteria for field name "Is User" with Operator "Equal To" and Value "True", then click "add to list" and then OK
The History tab on that Group will now show all history for any contact in that group, which in this case is all your users.
Keep in mind of course that users might want this history for reference, although history on your other records is probably a lot more important.