Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam Certified Platform App Builder topic 1 question 556 discussion

Actual exam question from Salesforce's Certified Platform App Builder
Question #: 556
Topic #: 1
[All Certified Platform App Builder Questions]

Nickname_c is a custom text field on a contact record that is utilized to override the contact name appearing on an email template. This field is not required and is not always filled in.

Which formula should an app builder use to select the contact's preferred name for email communications?

  • A. IF(NOT(ISBLANK(Nickname__c)),Nickname__c,FirstName)
  • B. IF(TEXT(Nickname__c),Nickname__c,FirstName)
  • C. IF(ISNULL(Nickname_c),Nickname_c,FirstName)
  • D. IF(NOT(BLANKVALUE(Nickname__c)),Nickname__c,FirstName)
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
wlthorn
Highly Voted 1 year, 3 months ago
A. IF(NOT(ISBLANK(Nickname__c)),Nickname__c,FirstName) The formula "IF(NOT(ISBLANK(Nickname__c)),Nickname__c,FirstName)" checks if the "Nickname__c" field is not blank. If it is not blank, it returns the value in the "Nickname__c" field, otherwise it returns the value in the "FirstName" field. This formula allows the app builder to select the contact's preferred name, whether it is stored in the "Nickname__c" field or the "FirstName" field.
upvoted 7 times
...
Zahral
Most Recent 1 week, 5 days ago
A is correct, it's tested
upvoted 1 times
...
Im_Him
2 weeks, 5 days ago
Selected Answer: A
A is correct.
upvoted 1 times
...
BrainMelt12
1 month, 1 week ago
Selected Answer: D
A is correct but D is the best option for the scenario. Handling Null Values: BLANKVALUE handles both null values and blank values, whereas ISBLANK specifically checks if the field is blank (empty string, whitespace) but doesn't handle null values. In practical scenarios, null values might exist, especially in custom fields that are not required. BLANKVALUE ensures that if the field is null, it still behaves as expected, providing a default value. This makes option D more robust in handling various scenarios. Although both options A and D could achieve the desired outcome, option D (using BLANKVALUE) is preferred due to its ability to handle null values, improved readability, consistency, and potential performance benefits.
upvoted 1 times
Bluezila
1 month ago
BLANKVALUE require two parameters, if you use it as D you´ll get this error: "Error: Incorrect number of parameters for function 'BLANKVALUE()'. Expected 2, received 1". So A is the correct answer. https://help.salesforce.com/s/articleView?id=sf.customize_functions_blankvalue.htm&type=5
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...