-
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
Inline Edit Support in Custom Component in Salesforce Lightning
If you have a situation where you need to create a custom component with inline edit functionality then this article will help you. However inline…
Should You Do Salesforce Backup — All You Need To Know
If you ever lost your data, you know how devastating it is. But what if this data affects the entire enterprise's functioning? Dealing with sensitive…
Mobile Salesforce Solution That is Perfect For You
Let us just take a quick tour down memory lane of how we have used desktop computers for surfing a website built with Flash and…
Popular Salesforce Videos
Marketing Automation with Salesforce Journey Builder
Marketing Automation which is future of marketing can be simply understood as automating your marketing communication programs. we are going to talk about Salesforce Journey…
Spring'21 Prior Value in Salesforce Record Triggered Flows - ISCHANGED IN Salesforce Flows
In this video, I'm talking about the Prior value feature in the Spring'21 pre-release that is for the record triggered flow. Pre-Release Org URL: https://www.salesforce.com/form/signup/prerelease-spring21/…
How To Create A Case Assignment Rule In Salesforce
Learn all about how to create Case Assignment rules. In this video, the following points will be covered - 1. Introduction To Case Assignment Rule…