-
How to create a report in Salesforce which will achieve following goals?
Hi all. I'm a SF admin but only because no one else in my organization is. I'm not a developer. I would like to create a report which will:
- Generate itself daily at a scheduled time, say 8:00am, my time.
- Randomly select 10 accounts with contact name, phone number, all notes associated with the account.
- Will not select any account more than once until all accounts have been reported.
- The account must be a prospect, not a customer.
- The account must not have recorded any activity within the previous 60 days.
- Keep track of the dates & accounts reported.
The goal here is to keep up with prospects regularly but not too often. The challenge is to get the date reporting correct. For example, if the report shows Acme, Inc today & Acme, Inc. was created 61 days ago then I shouldn't see Acme, Inc. again until all of the accounts which meet the criteria have been reported to me.
Thanks for your ideas in advance.
Steve?
Log In to reply.
Popular Salesforce Blogs

Create a List View in Salesforce Lightning Experience
ListView allows you to see a filtered list of records, such as contacts, accounts, or custom objects. In list views, you can only see the…

Salesforce 3CX Integration | All You Need to Know
In the ever-evolving landscape of customer relationship management (CRM), businesses are constantly seeking innovative solutions to streamline communication and enhance efficiency. Salesforce 3CX Integration emerges…

Maximize Your App's Reach: The Ultimate Guide to Listing on Salesforce App Exchange
As you peruse this article on Forcetalks, we are confident that you possess an understanding of Salesforce App Exchange. However, are you aware that this…
Popular Salesforce Videos
Salesforce CRM Full Training Tutorial For Beginners
In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.
DreamTX Welcome Day 4: Skill Up with Trailhead | Dreamforce 2020 | Salesforce
If you missed DreamTX DAY 4, then live this amazing experience here, we have covered it all for you. Learn about the latest innovation on…
Best Chrome Extensions for Salesforce
These are the best FREE Chrome Extensions to use with Salesforce. Installing Chrome extensions is the easiest way to enhance your experience on the Salesforce…