Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Shubhashini RajaShubhashini Raja 
Hello Trailblazers!!
I cleared my Admin Certification today. I'm so happy. Thank you so much Trailblazer Community for helping me accomplish this. You guys have responded immediately for every question I posted and thanks a lot for sharing the required materials on topics I need referencing. You guys are amazing. Let's keep Blazing!!

Next prep for "Advanced Admin"
Best Answer chosen by Shubhashini Raja
Sakthivel MadeshSakthivel Madesh
Wow.. Congratulation Shubhashini !!

Try this trailmix from trailhead -

Advanced Administrator Quiz from SalesforceBen Website -
Bob JohnsonBob Johnson 
For the life of me I cannot figure this out.   The Admin Cert 2021 is a simple item but it is acting very buggy for me.   I did the major steps:

1.  Set up new org
2.  Import the CSV to create object
3.  Edited the Dynamic Form as intended (since this is the showcase item of the mini badge)

But it will not complete verification -- each timve giving the message below:

We can’t find the custom object with api name 'Laptop_Warranty'.

NOTE:   Shouldn't it be looking for Laptop_Warranty__c ???  Since it has to be a custom object, is there a bug in the check-for-complete code perhaps?

Did anyone else get stuck on this?

Course Link (
Best Answer chosen by Bob Johnson
Bob JohnsonBob Johnson
Ok, I finally solved it and I figured out the two problems I had were, and I do not believe they were related. 

1st -- even though I created a new org like the instructions suggest, AND I was using the "Launch" button with that Org selected, because I was logged into two different orgs at the time the "validation" function was clearly going to the right org.  When I started over with a new reboot (no changes at all) and fresh Chrome, the validation now found the object.   Then the error changed to something like "please set your filters correct" (sorry I missed exact error).

I had set the filters correctly on the Active Warranty field -- but because I had messed up the page originally, somehow it got renamed as Laptop_Warranty_Record_Page2.     Once I fixed the name of the page by removing that number, it now successfully completed the challenge.

1.  If you are getting the "cant find object" message, make sure you log out of all sandbox/sf instances and start fresh.
2.  If you are getting an error on the record_detail component, check your page name and make sure it is correct.

Thanks for the replies all. 
Steve MolisSteve Molis 

A place of worship, thanks, and admiration for the Answers Community Demi-God, Deepak Anand.
User-added image
Best Answer chosen by Jayson ( 
Steve MolisSteve Molis
@Viorel Pascu

dude, there is WAY more to being a Role Model than collecting Trailhead Badges, just read though some of the solutions he's posted. 

Deepak Anand is The G.O.A.T.  (end of story)
Ismail KhanIsmail Khan 
Hi All, 

I had to create a field on an opportunity record type. I am wondering if it's possible for that field to appear on the opportunity depending on a value of another field. I know this can be done by dependent picklists. Unfortunately this is a date field that needs to pop up when a location is selected on antother field. 

Thanks in Advance
Best Answer chosen by Ismail Khan
Jayson MoralesJayson Morales
Hi Ismail,

Unfortunately, it's not possible through standard functionalities to show a field based on the value of another field. You need to use custom coding for this or you can vote for the idea below.

Idea: Dependent page layouts - data rules to show, hide, or make fields/sections req'd

Hope that helps.

Michael FaberMichael Faber 
I am trying to write a report formula that will return the % of one option from a picklist.

Lets say we have 10 items returned in an activity report, and we are grouping by Type (picklist) and Sub Type (picklist). The Sub Type picklist contains options Inquiry and Transfer

We are trying to create a column that will return the percentage of rows that have selected Sub Type Transfer, irrespective of Type.

User-added image

Is this possible without configuration changes?
Best Answer chosen by Michael Faber
Steve MolisSteve Molis
These are the Formulas that I used (keep in mind I uswed an Opportunity Report in my example to approximate the data)

Formula A

Formula B
RowCount / 
Formula C 
IF( PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, Opportunity.Do_you_owe_SteveMo_a_beer__c) = 0, 0, 
RowCount / 
PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, Opportunity.Do_you_owe_SteveMo_a_beer__c))

David HollingworthDavid Hollingworth 

I am confused by the challenge to verify the Trailhead lesson Get Started with APEX.

At the top of the challenge it stest "Create an Apex class with a method that returns an array (or list) of strings"

Then further down it says "The method must return a string value in the format Test n where n is the index of the current string in the array".

So, what must it do? Return an array of strings or a single string "Test n".



Best Answer chosen by David Hollingworth
Seyran MammadovSeyran Mammadov
Hi David,

Method must return array of strings in the form of "Test n" (i.e., Test 1, Test 2, Test 3..)
Katie HarttKatie Hartt 

I am working on the Build a Suggestion Box App Module in Trailhead and am receiving the following error for the second step "Add Custom Fields".

"There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST, Status: bad value for restricted picklist field: test: [Status__c]"

I've repeated the steps from the module in two separate playgrounds and keep getting the same issue... Does anyone know how to resolve?

Best Answer chosen by Katie Hartt
Keiji OtsuboKeiji Otsubo
Trude RustadTrude Rustad 


I need to make reports on Email object - by who created the email, group by subject and so on. 

However there is no standard Report on this. Read up on another article on creating a custom report - joinging the case with Emails. 

That shows me many emails - but it does not show me the emails I need to show. Somehow it seams like it shows all the support emails, but not the ones sent by sales?? I am a bit lost, can someone pls share some insight?

Best Regards: 


Best Answer chosen by Trude Rustad
Dmitry ZhagrovDmitry Zhagrov

Looks like you are looking how to create report about SF user activities related with email sending.
Try to explore report types for Activities section.
Look the recommendation how to create report to track all Outbound emails

Dylan TurpinDylan Turpin 
Apex is bringing in the timestamp of a user click in milliseconds and need to convert to date/time.

Posting to document for the Community.
Best Answer chosen by Dylan Turpin
Dylan TurpinDylan Turpin
Formula: Date/Time
DATETIMEVALUE("1970-1-1 00:00:00") + 
((0.001 * TimeStamp_milliseconds__c ) / 86400 )

Epoch milliseconds = 1524159037555 = TimeStamp_milliseconds__c
Returns 4/19/2018 12:30 PM CST

Salesforce converts it from GMT based on your user's timezone.
David NavaDavid Nava 
I created a custom object in Salesforce Lightning to record survey results. The fields on the survey object that record the respondent's answers are all picklists. All picklists reference the same global value set. The global value set is a Likert Scale, as follows:
5-Very High Confidence
1-Very Low Confidence

The survey object has master detail relationships to the Contact and Campaign records.
I created a custom Contacts with Surveys and Campaigns report.
There are twelve questions on the survey that need to be reflected in the report that I am trying to create.

I need the report to list each of the twelve questions. This is easy and already accomplished. I also need the report to calculate the average value of each of the question columns and return a summary value. For example, column one lists the Likert Scale results for each user for Question 1. I need the values for the Likert Scale responses to be averaged for that column, and for the next 11 columns (one column per survey question). See below for a screenshot of my report as currently structured.
Survey Report Snapshot

This is where I am struggling. I can't figure out how to summarize each of the question columns. My company want to be able to review the collective results from the survey and be able to immediately tell which questions they scored low in,out of the 12 questions. A chart showing thjs would be awesome.

I can't gfigure out how to do this. Is a formula column or columns the way to go? 
Pleas help. Thank you in advance!!!

Dave Nava
Awesome Admin
Best Answer chosen by David Nava
Sunil SarillaSunil Sarilla
Hi David,
I don't think you will be able to summarize the report by 12 different fields and show it on a chart with the way your data is structured.
whats possible is showing the avg value for each question in a campaign.
so you will need 12 charts i.e a chart for each question and then show the information in a dashboard but this is not scalable if you want to show the avg scores for each question for a different campaign.
or a Lightning Table component Dashboard

In order to summarize by the question, you will need to convert the picklist field into a numeric value, so you will need a formula field (12 formula fields)
the formula will be as below
'5-Very High Confidence',5,
'1-Very Low Confidence',1,
How flexible are you in changing the data structure?