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 - https://trailhead.salesforce.com/en/users/strailhead/trailmixes/prepare-for-your-salesforce-advanced-administrator-credential

Advanced Administrator Quiz from SalesforceBen Website - https://www.salesforceben.com/certified-advanced-administrator-quiz/
Steve MolisSteve Molis 
https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009NMC 

A place of worship, thanks, and admiration for the Answers Community Demi-God, Deepak Anand.
User-added image
 
Best Answer chosen by Jayson (salesforce.com) 
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
URL: https://success.salesforce.com/ideaView?id=08730000000BroxAAC

Hope that helps.

Regards,
Jayson
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
IF(PARENTGROUPVAL(RowCount , CREATED_DATE, COLUMN_GRAND_SUMMARY) = 0, 0 ,
RowCount
 / 
PARENTGROUPVAL(RowCount , CREATED_DATE, COLUMN_GRAND_SUMMARY)
)

Formula B
IF(PARENTGROUPVAL(RowCount, TYPE, COLUMN_GRAND_SUMMARY) = 0, 0,
RowCount / 
PARENTGROUPVAL(RowCount, TYPE, COLUMN_GRAND_SUMMARY))
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))


​​​​​​​
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?


Link:  https://trailhead.salesforce.com/en/content/learn/modules/administrator-certification-maintenance-spring-21/maintain-your-administrator-certification-for-spring21
Course Link (https://trailhead.salesforce.com/en/content/learn/modules/administrator-certification-maintenance-spring-21/maintain-your-administrator-certification-for-spring21)
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.

So:
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. 
Trude RustadTrude Rustad 

Hi, 

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: 

Trude

Best Answer chosen by Trude Rustad
Dmitry ZhagrovDmitry Zhagrov
Trude,

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
https://help.salesforce.com/articleView?id=000321258&type=1&mode=1




 
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 )

Example
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 
Background
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
4
3-Confident
2
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.

Requirement
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

Problem
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!!!

Best,
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
CASE(Your_Response_Picklist_Field__c,
'5-Very High Confidence',5,
'4',4,
'3-Confident',3
'2',2,
'1-Very Low Confidence',1,
0)
 
How flexible are you in changing the data structure?
Lauren CoryLauren Cory 
[FYI: This is my first question posting to the Community. System Admin in training. Never used Process Builder before.]

In the Lightning Flow Trailhead module, in Step #2 Automate Simple Business Processes with Process Builder, the Challenge was to use Process Builder to create a process on the Account object that updates child Contact addresses when an account's address is updated. The process can have any name and must have an Update Records action that updates Contact mailing address fields (Street, City, State, Postal Code, Country) when the parent Account shipping address field values are updated. The process must be active.

My trigger is set to the Account object, when a record is created or edited. Criteria I set was that when Conditions are met, for every Shipping Address field on the Account is changed, with an OR, not an AND.
User-added image
The immediate action would be to update the records of the Contact Mailing Address fields to reference the Shipping Address fields on the Account.
User-added image
When I went to check the challenge, it said: "An update to an account record failed to update the mailing address fields of all child contact records. Make sure that the process is correct and that it is activated"

What did I do wrong?
Best Answer chosen by Lauren Cory
J. SteadmanJ. Steadman

Hi, Lauren!

Your criteria are currently set to "Is Changed" = False. Could you try cloning a new version of your process and changing those to "TRUE"? I think this will produce the desired outcome.

If this was helpful please consider marking this "best answer". Cheers!

J.

Admin UserAdmin User 
Does Salesforce have any sort of floating licenses, where a limited number of licenses can be shared among a larger number of users?
Best Answer chosen by Admin User
Stephen NoeStephen Noe
Unfortunately, no, all Salesfore licenses are tied directly to a specific user.