Salesforce Certified Platform App Builder — Question 347
Universal Containers uses a custom picklist field Account Region on the account record. They want this region to be reflected on all related contact records and stay in sync if the value of this field changes on the Account.
How should an app builder meet this requirement?
Answer options
- A. Create a picklist field called ‘Account Region’ on Contact object > Create a workflow rule to update this picklist field if the Account Region field on the Account is changed.
- B. Create a formula field on the Contact object > Set the value of the formula to ISPICKVAL(Account.Account_Region__c).
- C. Create a text field called ‘Account Region’ on Contact object > Create a workflow rule to update this picklist field if the Account Region field on the Account is changed.
- D. Create a formula field on the Contact object > Set the value of the formula to TEXT(Account.Account_Region__c).
Correct answer: D
Explanation
The correct answer is D because a formula field can dynamically pull the value from the Account's picklist, ensuring it updates automatically if the Account Region changes. Option A is incorrect as a workflow rule would require manual updates and may not keep the data in sync in real-time. Option B is wrong because ISPICKVAL is not suitable for this scenario, and option C fails because a text field cannot maintain the picklist functionality needed for synchronization.