PLAT-ADMN-202 practice question 2 of 35
Ursa Major Solar wants to see the Type field from the parent object Galaxy listed on the child recordStar. 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?
Full set: 311 questionsDomain Object Manager and Lightning App Builder
To display the value of a parent object's picklist field in a child object's formula field, the picklist value must be converted to a text data type. The TEXT() function is specifically designed for this purpose; it returns the API name of a picklist value as a text string. Using TEXT(Galaxyr.Typec) correctly retrieves the value from the parent Galaxy record's Type field and allows it to be displayed on the child Star record, resolving the "Picklist values are only supported..." error.
A. ISPICKVAL(Galaxyr.Typec) is syntactically incomplete. This function checks if a picklist has a specific value and returns a boolean (true/false), not the text value itself.
B. VALUE(Galaxyr.Typec) converts a text string that represents a number into a number data type. It is not used for retrieving the text label of a picklist.
D. FIND(Galaxyr.Typec) is syntactically incomplete. This function finds the position of a string within another string and is not used for displaying a field's value. ---
1. Salesforce Help Documentation, "Formula Operators and Functions T–Z":
Section: TEXT(value)
Content: "Converts a percent, number, date, date/time, or currency type field into text. Also, converts a picklist value to a text value with the API name of the value, not the label." This directly confirms that TEXT() is the correct function for converting a picklist value to text for use in formulas.
2. Salesforce Help Documentation, "Tips for Working with Picklist and Multi-Select Picklist Formula Fields":
Section: "Using Picklists in Formulas"
Content: "To return the API name of a picklist value in a formula, use TEXT(). For example, TEXT(Status) returns the API name for the Status picklist, such as 'New'." This provides a clear example and reinforces the correct usage.
3. Salesforce Help Documentation, "Formula Field Data Types":
Section: "Text"
Content: This section explains the text data type in formulas. The error message "Picklist values are only supported in certain functions" arises because a picklist is not a standard text type. The TEXT() function is the bridge to convert it to a compatible type for display.
Keep practicing
Take the free PLAT-ADMN-202 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PLAT-ADMN-202 practice questions
- Question 1Universal Containers manages leads in a Lead qualification queue where sales reps can acc…
- Question 3Universal Containers (UC) utilizes two custom picklist fields called sales_Organization__…
- Question 4Which two features can be used to allow users to access Flows? Choose 2 answers
- Question 5Universal Containers wants some enhancements on its Opportunity page layout to improve ef…
- Question 6A business user wants a quick way to edit a record's status and enter a custom due date f…
- Question 7Sales Managers want to be automatically notified any time there is a change to an Opportu…
