Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce Plat-Admn-202 Exam - Topic 5 Question 15 Discussion

An app builder wants to create a formula field on an Account to include data from related Contacts but is unable to find the relationship in the formula editor. What is a limitation of formulas that could be causing the issue?
D) unable to reference the child records.
A) Control and Account objects: 0.00 or 1 have a Master-Detail Relationship.
B) Store Data: 3000 characters in the formula.
C) Formula field that reached on the Account object.

Salesforce Plat-Admn-202 Exam - Topic 5 Question 15 Discussion

Actual exam question for Salesforce's Plat-Admn-202 exam
Question #: 15
Topic #: 5
[All Plat-Admn-202 Questions]

An app builder wants to create a formula field on an Account to include data from related Contacts but is unable to find the relationship in the formula editor. What is a limitation of formulas that could be causing the issue?

Show Suggested Answer Hide Answer
Suggested Answer: D

The correct answer is D. Unable to reference the child records.

Formula fields can reference fields from related parent records using cross-object formulas, but they cannot directly pull values from multiple child records onto a parent record. Salesforce describes cross-object formulas as formulas that can reference fields from a parent object when the formula is created on the child/detail side of the relationship.

In this case, Account is the parent and Contacts are child records. Since the formula is being created on Account and trying to reference related Contacts, the relationship does not appear in the formula editor.

Correct design alternatives: use a roll-up summary where supported, Flow, Apex, or reporting.

===========


Contribute your Thoughts:

0/2000 characters
Camellia
21 hours ago
I think I saw a question like this in practice where it mentioned the type of relationship. Could it be that there's no Master-Detail relationship between them?
upvoted 0 times
...
Barrett
6 days ago
I remember that formulas can only reference parent records, so maybe it's because Contacts are children of Accounts?
upvoted 0 times
...

Save Cancel