These questions are designed to be similar to ones that will be asked on certification exams. Aim to get most of these questions correct on the first attempt.
To view the remainder of this content, you must purchase the Salesforce.com Certified Administrator Study Guide. Please Login or purchase the study guide.
Sorry to trouble. I am not sure whether my understanding to question2 is correct or not.
Is the point to question?
Because the formula field is a text type, the phone number cannot be converted and displayed?
Thank you very much
The intention of the question is to see determine what will happen if a cross object formula doesnt have a record populated
Hi John, Just wondering, why isn’t there a related list possible on opportunity, displaying account information, which would enable you to display the roll-up summary field on the opportunity layout?
The related list displays lists of related records – the “many” side of the relationship.
You wouldn’t have a list of related accounts (this is what would show in the related list) on the opportunity, as an opportunity is related to one account. Hope that makes sense 🙂
Hi John, Formula is always created on child object. In question 2 we are creating formula on campaign which means it is a child object. But we can’t use standard object on the child side. How this is going to work.
The relationship from Campaign to Venue would have to be a lookup relationship (rather than m/d)- therefore the relationship could be created on the campaign object.
Why can’t we create a roll-up summary field on opportunity to aggregate the lifetime sales of the account (Question 3).
The field has been created… you need to display that field on the opp
Also, isn’t it that Roll-up Summary fields work downwards? That is, Parent to Child? Meaning we couldn’t perform a Roll-up on the Opportunities since they are the Children of Accounts?
Yep- so the rollup field has been created on the account and is in place already. What this question is asking is – how would you display that account data on the opportunity. The field type of the data on the account is actually not important – it’s the replication of the information on the opp.
can we add a roll-up summary field on account record to display all closed-won opportunity related to the particular account?Is it a M-D relationship? plz clarify…
Yes you can summarize opportunity data on the account using roll up summaries. To use a rollup field with a non-standard relationship you need a master/detail relationship between the objects.
thank you John..
Where is a list of the “valid formula functions”? I don’t even see the lastmodifieddate as an available option. YES, I know what is listed is not an exhaustive list. However, if there are questions such as this I would like to be familiar with the most common options.
Here you go: https://help.salesforce.com/HTViewHelpDoc?id=customize_functions.htm&language=en_US
Note that lastmodifieddate is a FIELD not a formula function. You would need to compare that field data using some sort of formula function.
Quick question, how much formula syntax should we learn or expected to know for this test?
Very good question- although I don’t know an exact answer to it unfortunately.
I would suggest the following:
Study the syntax of formula itself (e.g. be able to identify a formula that is missing a parenthesis or missing quotations, etc.)
Study the different types of functions available
Know how to implement the more common examples (e.g. cross object to display info, simple formulas using IF AND OR CASE, etc.)
Can a cross object formula reference a rollup summary field..Isn’t a limitation?
sorry, my bad…its the other way around.You can’t reference cross-object formulas in roll-up summary fields.
Correct – you can probably do some sort of workaround for that now with process builder. But a good limitation to know about for sure.
Thanks, John! I just implemented your question 3 into my actual SF environment! lol
A roll-up summary field called “Lifetime Sales” has been added to the account object and displays the total of all closed/won opportunities associated with an account.
Isn’t opportunity a standard object?
Is it possible to create a A roll-up summary field that reference it?
Yes- and yes (on account only)
Sorry to keep bombarding you with questions.
Please could you clarify the answer for Q3… I do not understand why you cannot use a roll-up summary field.
Could you elaborate please?
A rollup summary is needed to summarize the info (amount) from related objects (opportunity). This is the only field type that can capture information from more than one related record (without additional automation)
yeah 100% on this one too. woot!
I think there might be a typo in the first question: “(…) to display the date 7 after today’s date?”
Perhaps it should state “to display the date 7 *days* after today’s date?” (otherwise, it sounds like you are asking about the 7th day of the following month)
Thanks Roger – updated.
Please let me know the procedure to purchase Admin guide..
Hi Sai – you can sign up here: http://classic.certifiedondemand.com/register/certified-administrator-study-guide/
The syntax within a cross-object formula uses __r when referencing a relationship through a custom field (instead of __c). The actual API name of the field is still includes __c, however (it is just when referenced in relationships that it changes to __r). If you create a formula referencing a cross-object formula, you can see this in action. I can understand how this would be confusing – I’ll look at rewording the question.
The syntax refers to Venue__r and the question refers to Venue__c