-
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
Lightning Design Experience In Visualforce Pages with Lightning CSS Framework
Salesforce Lighting Design System(SLDS) is a CSS framework introduced by Salesforce to create faster,responsive and beautiful pages even in Salesforce Classic. This css framework is…
Salesforce Introduces Einstein Automate
Salesforce introduced Einstein Automate on December 2nd 2020. Salesforce had a number of shocking announcements for their customers in December – acquiring Slack for $27.7 B, introducing Hyperforce, and a…
Useful Salesforce Steps and Instructions – Part 4
Hello All, Welcome to the another part of Useful Salesforce Steps and Instructions. The provided below steps will be very useful for you while working…
Popular Salesforce Videos
Salesforce Lightning User Tips & Tricks Spring 2021
This session is one of our most popular Webinars. It includes tips and tricks that any Salesforce user will find helpful. Learn Salesforce shortcuts that…
How to Choose Salesforce Career Path | How To Start a Salesforce Career
With most of the businesses using Salesforce finding access to talent to be a ‘critical challenge’, it’s no wonder so many people are choosing a…
What are Custom Page Layout in Salesforce?
Custom Page Layout is creating its own layout and modifying the same layout which we have created. Watch this video to learn all about Custom…