-
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
Salesforce Spring '22 Release - Get to Know the Highlights
Here we are standing at the beginning of a brand new year full of promise and opportunity, both for ourselves (failing resolutions notwithstanding) and our…
How Hiring a Salesforce Implementation Partner Could Benefit the Healthcare Sector
Digitalization of healthcare is a complex task due to the sector's unique challenges, such as handling various types of data and interdependent roles. Salesforce implementation…
Useful Plugins and Extensions for Salesforce
In this article, we'll look at some of the best Salesforce Chrome extensions and plugins for sales professionals. Whether you're looking for tools to automate…
Popular Salesforce Videos
Salesforce Health Cloud – Creating Patient Relationships Not Records
Unfortunately, the gruesome truth facing the world today is the ever increasing pressure of diseases due to chronic disorders, pollution, growing age, and definitely increasing…
Salesforce Platform Quick Tip: How to Solve Issues with Error Code Validation
Want to troubleshoot your validation errors faster? Trailblazer and Senior Salesforce Administrator, Monica Doyle walks us through how to add error codes to a validation…
Salesforce JavaScript Developer 1 Certification Series
Hi Everyone, SFDC Panther has started the Salesforce JavaScript Certification series and this is the first session. What you will learn: Variables Data Types Operators…