Incarni Partners - Salesforce.com consulting services in the Boston Metro
Call Today 617-308-5353
  • Home
  • Capabilities
    • Business Consulting Practice
    • Salesforce Practice
    • Non-Profit Salesforce Practice
  • Clients
  • Knowledge
  • Company
    • About Us
    • Contact
    • Employee Portal
  • Blog

Records Created By the Current User

1/7/2013

0 Comments

 
Here's a little formula that I came accross that comes in handy when you need to create reports and dashboards (it also works with List Views too!) that display things like Activities, Cases, Leads, Opportunities, etc that were created by one user, but might now be owned by another user. 

Unfortunately the built-in Salesforce  "My..."  and "My Team..." filters only reference the record Owner field, so you're forced to clone reports and edit the Created By filter (making the Running User pretty  much useless). Here's what you do: 
 
Create a custom field on the objects that
you  need to track CreatedBy (User).
Field Name:  CreatedBy$User
Datatype: Formula
Return Type: Number, 0  decimals
Formula: IF(CreatedById = $User.Id , 1, 0) 
 
Now just add a simple filter to your reports and now use the Running User to create Scheduled Reports and Dashboards that display anything a user  created.  Now if you need to create a new "Created By... Dashboard" all you have to do is clone the Dashboard and change the Running User (no more cloning and editing reports for each user) 

The simple filter:
Field: CreatedBy$User 
Operator:  [equals] Value: 1
0 Comments



Leave a Reply.

    Author

    As the founder of Incarni Partners, Ashley Porath, shares practical tips, trends, thoughts, links, ideas and tools for successful Cloud based CRM solutions.

    Archives

    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    May 2012
    January 2012
    November 2011
    October 2011
    September 2011
    August 2011

    Categories

    All

    RSS Feed