Ask Search:
Steve MolisSteve Molis 
Here's a Formula I built to create an "Ultimate Parent Account" field that you can use to create Opportunity Pipeline reports that roll up all Opportunities under the top Account in the hierarchy. 

*** in this example I'm testing up to a 5 Tier Account Hierarchy (Compiled size: 342 characters) ***

Datatype: Formula 
Result: TEXT 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name,
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name,

Best Answer chosen by Miglena ( 
Steve MolisSteve Molis
An #AWESOME bonus tip from @Jeremiah Dohn to turn the Ultimate Parent into a Hyperlink to that Account

Datatype: Formula 
Result: TEXT 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Id, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Parent.Name)), Parent.Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Parent.Name)), Parent.Parent.Parent.Name, 
IF(NOT(ISBLANK(Parent.Parent.Name)), Parent.Parent.Name, 

Denise CrosbyDenise Crosby 
Hello. I'm in desperate need of a good data management tool for Salesforce, similar to SQL Server Management Studio. I need to be able to run queries (with multiple objects) and quickly export results to a file, such as Excel. I also need to be able to manipulate (DML) data in the tool after querying. Of course, deduplication would be nice. Someone suggested DemandTools to me. I was wondering if there was a defacto standard that most admins use for this that works well. Data Loader is no longer cutting it for me. For complexing querying, I now have to export and import into SQL Server - what a pain!!
Thanks for helping.
Best Answer chosen by Denise Crosby
Saurabh DuaSaurabh Dua
HI Denise, 

You could use workbench for salesforce.

After logging in qo to queries dropdown and select soql. This would give you option to run SOQL and extract data in excel or csv. 

To do updates you could use rest explorer which is also available in workbench. 
Alternatively you could use  Rest explorer
Swapna MistrySwapna Mistry 
Stuck on this..... I cant figure out why one of my user's cant see the Knowledge Tab. 

User-added image

I have checked the box for "Knowledge User" on the user's record. 

Then I also went to the user's Profile and added the appropriate Knowledge permissions.

User-added image

User-added image
Best Answer chosen by Swapna Mistry
Swapna MistrySwapna Mistry
Hi Chris, 
Yes. That was already set to Default on. I found what the issue was: "Knowledge One" needed to be checked under General User Permissions in the Profile. 

User-added image
Jill ArensonJill Arenson 

I am trying to create a dashboard for top 10 frequently viewed Knowledge Base Articles.

(Note:  AppExchange Knowledge Report package already downloaded.  Existing report not working).

Below is a snapshot the dashboard as it exists today.  Note: it does not accurately display the top 10 viewed articles because the report as it exists is sorted by “created date”.  What it is actually displaying is the first 10 most recently created Knowledge Articles and their Total Views, sorted by total views.


In order for this dashboard to be a table, I needed to create a report that was a table with a row limit.  I’ve done this and at this point, I am running into a very frustrating error loop.  

The report is Tabular and the Row Limit is set to sort by Total Views, descending.  


The Dashboard Settings were set:

Dashboard Settings

However, when the report attempts to run, there is an error which returns me to this screen:
Report Error on Sort

The error instructs that I must choose a sort column (even though I have already done that in my Row Limit filter - which was sort by # views). And, the value of # Views is not available as a sort here.

Choosing any other value sorts the report by that value which results in an incorrect dashboard, as seen in the first screenshot.

It seems that this simple report and dashboard for Knowledge should be possible.

Can anyone give advice on how to successfully create this type of report?



Best Answer chosen by Moderator ( 
Francois LopitauxFrancois Lopitaux

An easy way to create a dashbaord with Top 10 View Articles is:
 - Create a summary report using Knowledge Article + Knowledge View Object
 - Drag & drop the column that you want to display (aka Channel, Top View, ...)
 - Group by the Title column
 - Summarize by the Total Views
 - Add the criteria that you want for example on Channel column to display the gobal number view cross Channel
 - Save the report

Go in Dashboard and edit the one that you want to update:
 - Add Table Widget
 - Click on Formating and select Sort by 'Value Descending'

And Voila !!

Does that work for you?

Notice that Dashbaord included in appexchange sort by the score which is a normalized number of view. More info can be find here:
Alexander PinateAlexander Pinate 
Hi Team,

We Want to track Emails, Calls and Sales appointments from our reps. We give points to our reps depending on the activities by day. We are looking into some apps that can do this. However, we would like some advise if there's another way to do this in your experience. Our reps are constantly on the phone and sending emails and sometimes they forget to submit their acitivities correctly.

I appreciate your help on this.

Best Answer chosen by Alexander Pinate
Phaneendra ArigachettaPhaneendra Arigachetta
Hi Alexander,

Salesforce is a great tool for tracking daily activities and scheduled events! Through the use of reports and dashboards you can show daily sales activity and what each of your team members are doing / have done. All you would need to do, is set up a way by which you measure the rates of calls (completing vs. open activities) and through the power of one to better analyze activities (not going to get in deep on what this is, but just know that there are ways to show ratios of the calls and events).

The best way to remember Activities is by the following:
-Activities are made up of (a) tasks and (b) events

When it comes to how these relate to Outlook, Events (or Calendar meeting times) will match up with salesforce given the start and end time that you designate in either or in Outlook. Tasks will also sync with salesforce and show up in your To-Dos in Outlook. 

Salesforce for Outlook is also a great tool in that it creates an easy bridge for your users to add emails to salesforce w/o copy and pasting (just click a button and its automatically added in SFDC to the contact you sent). The only issue that some people have, which has less to do with Outlook & SFDC, is that Emails don't sync where they are supposed to. The reason for this is that users haven't built in the necessary contacts into Salesforce. Basically, SFO tries to look for a contact to relate to in Salesforce but because it doesn't exist it throws the email to an empty que.

In Sum:
Dashboards & Reports will help your users track their daily activities (tasks and events)
Salesforce for Outlook will help make it possible by creating a bridge between the two interfaces

Best of luck!  Let me know if you have any more questions!
Ted STed S 
Salesforce describes the "Num Sent" field in Help as follows:

Number of individuals targeted by the campaign. For example, the number of emails sent.

Based on that description, I interpret this field to mean "the total number of members for this campaign."  If my interpretation is correct, why didn't Salesforce make this field automatically reflect the number of records in the Campaign Members related list?
Best Answer chosen by Moderator ( 
Sunil KeshariSunil Keshari
The "Num Sent" field is a user-defined value that must be manually set, unlike most of the other campaign statistic fields you see. "Num Sent" is typically a value that is defined once at the beginning of a campaign to gauge how large your marketing effort is.
Aliza SeeberAliza Seeber 

We are currently integrating with HubSpot and it collects city and state information in a custom object  based on the ip location of the lead.
However, it uses the state full name and our org uses State abbreviations. Does anyone have any ideas or workflow on how I could convert the full state name into an abbreviation?

Best Answer chosen by Moderator ( 
Keith CulkinKeith Culkin
Here's the full formula I use so you don't have to type it all out, including all American states and Canadian provinces. Not that this is the field update formula, but you'll also need criteria for the workflow rule. My criteria is that the state name equals one of the states listed in my formula. If doesn't touch anything that doesn't have a matching state name in there.

Case (BillingState, 
"Alabama", "AL", 
"Alaska", "AK", 
"Arizona", "AZ", 
"Arkansas", "AR", 
"California", "CA", 
"Colorado", "CO", 
"Connecticut", "CT", 
"Delaware", "DE", 
"Florida", "FL", 
"Georgia", "GA", 
"Hawaii", "HI", 
"Idaho", "ID", 
"Illinois", "IL", 
"Indiana", "IN", 
"Iowa", "IA", 
"Kansas", "KS", 
"Kentucky", "KY", 
"Louisiana", "LA", 
"Maine", "ME", 
"Maryland", "MD", 
"Massachusetts", "MA", 
"Michigan", "MI", 
"Minnesota", "MN", 
"Mississippi", "MS", 
"Missouri", "MO", 
"Montana", "MT", 
"Nebraska", "NE", 
"Nevada", "NV", 
"New Hampshire", "NH", 
"New Jersey", "NJ", 
"New Mexico", "NM", 
"New York", "NY", 
"North Carolina", "NC", 
"North Dakota", "ND", 
"Ohio", "OH", 
"Oklahoma", "OK", 
"Oregon", "OR", 
"Pennsylvania", "PA", 
"Rhode Island", "RI", 
"South Carolina", "SC", 
"South Dakota", "SD", 
"Tennessee", "TN", 
"Texas", "TX", 
"Utah", "UT", 
"Vermont", "VT", 
"Virginia", "VA", 
"Washington", "WA", 
"West Virginia", "WV", 
"Wisconsin", "WI", 
"Wyoming", "WY", 
"Ontario", "ON", 
"Quebec", "QC", 
"QuéBec", "QC", 
"British Columbia", "BC", 
"Alberta", "AB", 
"Manitoba", "MB", 
"Saskatchewan", "SK", 
"Nova Scotia", "NS", 
"New Brunswick", "NB", 
"Newfoundland And Labrador", "NL", 
"Prince Edward Island", "PE", 
"Northwest Territories", "NT", 
"Yukon", "YT", 
"Nunavut", "NU" 
Nate HembreeNate Hembree 
Soooooooo yeah. The component Salesforce provides for customers to close/reopen cases doesn't really work unless your Closed status reads Closed (i.e. you use Closed - Archived and the button says "Close Case" rather than "Reopen Case"). And we can't used record update actions in the community, so that's a no go. Any non-custom component ways of doing this?
Best Answer chosen by Nate Hembree
Swayam ChoukseySwayam Chouksey

In short no way apart from creating a custom component. Can you please provide the Use Case what exactly you want to achieve with Change Status button.

Hope this helps

Julie GranilloJulie Granillo 
I'm creating an email template, and I need to include today's date.  I can't find any date fields though by using the field selector thing on the email editor.  I need today's date to be displayed as "mmddyy" - no slashes or dashes.  Ideas?
Best Answer chosen by Julie Granillo
Deepak AnandDeepak Anand
I don't think you'll have a way to do that from within the Email Template. You'll have to create a Text based Formula Field like as below and use that in the Email Template instead:

Formula Field Label: Date for Email Template
Formula Field Return Type: TEXT
Jeffrey BrochsteinJeffrey Brochstein 
Is there a way to do an overall search of all fields both standard and custom, in SFDC? 
Best Answer chosen by Jeffrey Brochstein
Chad SealesChad Seales
Hey Jeffrey,

If you are simply wanting to search for a specific field you can use the "Search All Setup" tool from the Setup page. (Setup > Search box in top left corner). This tool searches across all objects.

If you want a list of all fields on specific objects you can view all fields from the object page. (Setup > Select The Object > Fields)

If you want a more exhaustive list of all metadata you can use From this tool (Info > MetaData Types & Componenets > CustomField > Expand All) This will list every custom field within your org.