Ask Search:
Khalil MedinaKhalil Medina 
I want to say THANK YOU all. Today I certified as a Sales Force ADM and it won't be possible without you guys.  I want to say specially thanks to Steve Molis and Jeff May, you guys are a huge example for me. I cannot be more happy

User-added image
Best Answer chosen by Khalil Medina
Khalil MedinaKhalil Medina
Syam Kishore: the key for me was learning everyday something new, because since I work as a salesforce adm I have some experience. I didn't try to memorize answers and questions, I don't find this valuable. I went to real situations. 

That serie of videos named: WHO SEES WHAT is excelent:

And the next on line courses:
Online course: Administration Essentials for New Admins and Administration Essentials for the 
Service Cloud
Other helpful resources:
 Online course: Analyze Your Data with Reports
 Online course: Configure Salesforce with Custom Fields
 Online course: Customizing Profiles to Align with Your Business Needs
 Online course: Getting a Head Start with Chatter
 Online course: Getting Started with Managing Data
 Online course: Managing Users and Troubleshooting Login Issues
 Online course: Summarize Your Data with Dashboards

That's all.


Jenni StoddardJenni Stoddard 
I have the Opportunity related list on the Account page, and it is sorted by oldest - newest. Is there a way I can have the most recent Opportunities show up at the top of the list instead of at the bottom?
Best Answer chosen by Moderator ( 
Nik PanterNik Panter
To do this, you must edit the opportunity related list properties on the page layout.  Go to Setup | Customize | Opportunities | Page Layouts, and edit the page layout you use.  Click the wrench on the Opportunities related list to enter the properties, and from there you want to set the Sort by to Close Date, and ensuring you have chosen descending.  Click OK and Save the changes to your related list.

User-added image
Katherine MatherKatherine Mather 
I have a workflow rule where the criteria are as follows  

Case Record Type =  Loan/Unam Balance
Loan Balance 1 > 1

The workflow rule creates a field update which uses this formula to populate the unamortized balance field: 

Loan_Balance_1__c + Loan_Balance_2__c + Loan_Balance_3__c + Loan_Balance_4__c + Loan_Balance_5__c

However, if all 5 balances are not filled out, the workflow rule does not function. How could I resolve this? There are scenarios where only 1 loan balance is filled out and some scenarios where only 3 or all 5. 

Thank you! 
Katherine Mather
Best Answer chosen by Katherine Mather
Jeff MayJeff May

You can add BLANKVALUE() formulas to use a 0 when the field is empty:

BLANKVALUE(Loan_Balance_1__c,0) + BLANKVALUE(Loan_Balance_2__c,0) +

BLANKVALUE(Loan_Balance_3__c,0) + BLANKVALUE(Loan_Balance_4__c,0) + BLANKVALUE(Loan_Balance_5__c,0)

Dan DoyleDan Doyle 
The issue I am having is I want certain fields to suggest values based on what you type in that field. I believe this can be completed using Enhanced Look-ups. For example, I want a custom field "Partner Rep" on the Opportunity page to have a lookup-filter that shows names from the contacts page. So if I have a contact name John Smith and I want to create a new opportunity, if I am typing in the "Partner Rep" field and I type in "Joh" it should suggest "John Smith" as a possible value.

So I went to Set-up->Build->Search->Search Setting and turned on "Enhanced Lookups" and "Lookup Auto-Completions" for all possible objects. (Accounts, Asset, etc) Then, I went to Set-up->Build->Customize->Opportunies->Search Layouts. Then I get a page that lists "Search Results, Lookup Dialogs, Lookup Phone Dialogs etc.) How do I configure the "Partner Rep" field to search based on the contact field? I don't know how to configure the options available at this screen and when I click "View Example," it says the URL no longer exists.

Can someone please explain in detail how to configure enhanced look-ups for standard and custom fields? Or should I be using another feature? Please keep in mind that I have Professional Edition.

Best Answer chosen by Dan Doyle
Paul FischerPaul Fischer
You can accomplish this using enhanced lookups. They are at the bottom of step 3 when you create the field, or you can get to them by editing the field. A common use case is a lookup on an Opportunity to only return Contacts for the Account to which the Opportunity is related.

User-added image
Steve FerreeSteve Ferree 
I noticed a glitch in Process Builder- The scheduled actions disappear when I choose When a Record is Created or Edited, it's there and accessible if I choose Only when a record is created. I tried this on the Opportunity Object and the Case Object- 
Best Answer chosen by Steve Ferree
Deepak AnandDeepak Anand
You'll have to check this option:
User-added image
Gelvin de LeonGelvin de Leon 
So far salesforce External Object Integration is able to retrieve data from an external database but will there be an update soon on saving data to an external database connected using lighting? And if yes, is it 100% sure to happen? Please reply, thanks
Best Answer chosen by Gelvin de Leon
Robin WijnenRobin Wijnen
Hi Gelvin, during the last User Group gathering, we as well discussed this item. The Read/Write functionality is on the Road map but no official date has been communicated. Make yourself a member in the Lighting Collaboration group. When there is an update or official pilot, you will mostelikely get the information from this user group. 
Chris MatthewsChris Matthews 

It keeps telling me incorrect date format and I can't find it in the help. 

I should be able to have a dynamic date range, correct?
Best Answer chosen by Moderator ( 
Jason ChuJason Chu
Believe you actually want to set it to:

Last Activity equals "LAST 180 DAYS"

Seach for "Special Date Values for Filter Criteria" in help.
Katherine RoweKatherine Rowe 
Our sandbox environment used to have this black bar at the top, and it was a nice way to differentiate sandbox from production at a quick glance so you didn't work in the wrong environment.

We just refreshed our sandbox, and now it's gone. I'm not sure how to get it back, and if that was a custom thing we did ourselves? Do other people have that in their sandbox environment?

User-added image
Best Answer chosen by Katherine Rowe
Deepak AnandDeepak Anand
It is the one that comes in after you activate Communities. It's called - Global Header. It is a Profile based permission that you can activate from the System Permissions section - 

User-added image
Santak ISantak I 
   I am planing to give ADM201 Exam within this week.
   As preparation alone not sufficient for the exam I need MOCK exam papers for ADM201 which will help me to clear this exam.
   If you have MOCK Exam papers for ADM201, please provide me.

Many thanks
Best Answer chosen by Moderator ( 
Matthew LambMatthew Lamb
Kim TibbittsKim Tibbitts 
How do I create a report that shows all account activity (open and activity history) and also shows opportunities won and includes opportunity details? For example, we have two opportunities that recently closed, I want to show all the activities that went into closing those deals, which are saved at the account level. The "assigned to" activities are different than the "account owner" - I'm not sure if that makes a difference. I would prefer to filter by "closed won" opportunities. 
Best Answer chosen by Kim Tibbitts
Geoffrey FlynnGeoffrey Flynn
For this you could do a Roll-Up Summary field on Accounts that is a Count of Closed Won Opportunities, and then filter for that field to be greater than zero.

The reason I mentioned the Activities is that if you can get it sorted out, you won't even need the join report anymore and you can just report on Opportunities with Activities as a single report type