Salesforce Certified Platform App Builder — Question 449

Ursa Major Solar want to see the Type field from the parent object Galaxy listed on the child record Star. The app builder is receiving an error stating `Picklist values are only supported in certain functions`.
What formula should an app builder use to achieve the desired result?

Answer options

• A. TEXT(Galaxy__r.Type__c)
• B. VALUE(Galaxy__r.Type__c)
• C. ISPICKVAL(Galaxy__r.Type__c)
• D. FIND(Galaxy__r.Type__c)

Correct answer: A

Explanation

The correct answer is A, as the TEXT function converts a picklist value to text, allowing it to be displayed. Option B is incorrect because VALUE is used to convert text to a number, which is not applicable here. Option C, ISPICKVAL, is a function used to check if a picklist field has a specific value, but it does not retrieve the value itself. Option D, FIND, is used for text searching, which does not apply to retrieving picklist values.