-
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
Explore The Application Network | Salesforce Developer Guide
Let’s Find Why Is Integration So Challenging? The Fourth(4th) technological revolution is upon us. Connectivity across people, applications, data, and therefore the Internet of Things…
AWOM vs Others – A Comparison of Salesforce’s Opportunity Manager Apps
The old sales rule says: “The opportunity is a deal that you have the possibility to close!” And when your business falls in the large,…
Steps to setup Communities in Salesforce
To setup the communities, the very first thing you need to do is enable the communities in the org. Once the communities are enabled in…
Popular Salesforce Videos
The Rising Demand for Salesforce Experts | Salesforce Careers
With more than 500,000 organizations using Salesforce to drive key business results, the market is brimming with opportunities for Salesforce certified professionals. A quick job…
Add Sound Effects to Your Salesforce Org | Salesforce Tutorials | #SalesforceBolt
In this video you will learn to Use a Lightning Web Component to play a fun sound when a big deal closes. You can play…
Salesforce Rest API | Http Methods | Salesforce Integration
This video we will discuss - What is API Different API In Salesforce Rest API in Salesforce HTTP Request HTTP methods Workbench to make HTTP…