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?
To select the contact's preferred name for email communications, the formula needs to check if the Nickname__c field is filled. If it is filled, the formula should use the value in Nickname__c; if it is not filled, it should default to using the FirstName. The formula 'IF(NOT(ISBLANK(Nickname__c)),Nickname__c,FirstName)' does this by using the ISBLANK function to check if Nickname__c is blank. If it is not blank, it returns Nickname__c; otherwise, it returns FirstName, making it the correct choice in this scenario.
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.
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.
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
A is correct.
A is correct, it's tested
blankvalue syntax is BLANKVALUE(expression, substitute_expression) so correct answer is A.