-
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

Know How to Integrate Smart Quotations with Salesforce
Of the many integrations that can be made by third parties into the salesforce platform, CPQ stands for ‘Configure, Price, Quote’ – in simple terms,…

Maintaining Org Security with the Salesforce Health Check
You likely fell in love with Salesforce because of its flexibility. With its 'no-code' customizability and extensive range of third-party apps, the platform is endlessly…

5 Salesforce Implementation Mistakes And How To Avoid Them
Salesforce’s customization, clean interface, and exceptional functionality has been encouraging more businesses than ever to transition to its platform. If you’re considering implementing or updating…
Popular Salesforce Videos
Salesforce Developer Career Path | How to Become Salesforce Developer
Watch this video to get a good idea about the Salesforce Developer Career Path. In this video you will learn how to become Salesforce Developer.…
Which Certification Is Needed In Salesforce for Getting Job?
Want to get a job in the Salesforce industry? Wondering which certifications are going to help. Join this useful group for Salesforce job & career…
QuickBooks Salesforce Connector | Setup & Configuration
QuickBooks Salesforce Connector: https://eshopsync.com/quickbooks/ is taking the cloud-based platforms to the new altitudes. Now dealing with QuickBooks unlimited data is much easier than ever before.…