MENU
Nickname__c is a custom text field on a contact record that is utilized to override the contact's 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?
Suggested Answer: D
Get Premium CRT-403 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
The formula that should be used to select the contact's preferred name for email communications is IF(NOT(BLANKVALUE(Nickname__c)),Nickname__c, FirstName). This formula checks if the Nickname__c field is blank or null, and if not, it returns the value of the Nickname__c field. Otherwise, it returns the value of the FirstName field.
20 comments · newest first
CE
Cecilia
10 months ago
Wait, is C even a valid formula? Looks off to me.
TE
Tesha
11 months ago
I think D is better, uses BLANKVALUE which is more reliable.
TE
Tenesha
11 months ago
Option A looks solid, checks for Nickname first.
SA
Santos
11 months ago
Why isn't Nickname required? Seems like a missed opportunity.
YU
Yuriko
11 months ago
A is definitely the right choice, straightforward logic!
LI
Lindsey
11 months ago
Option B seems off to me; I don't think TEXT is needed for a text field like Nickname__c.
TE
Tenesha
12 months ago
I think I might have seen a question similar to this one, but I can't recall if we used ISNULL or ISBLANK.
KR
Krystina
12 months ago
I'm not entirely sure, but I feel like option D looks familiar. It mentions BLANKVALUE, which we discussed in class.
AL
Allene
1 year ago
I remember we practiced using the NOT and ISBLANK functions, so I think option A might be the right choice.
CH
Cherelle
1 year ago
Ugh, these Salesforce formula field questions always trip me up. I'm going to have to really focus on this one and make sure I understand the requirements before selecting an answer.
JE
Jesus
1 year ago
This looks like a classic Salesforce formula field question. I've seen these before, so I'm feeling pretty confident. I think option D is the way to go, but I'll double-check the syntax just to be sure.
CL
Clorinda
1 year ago
Okay, let me think this through. We need to use a formula to select the contact's preferred name for email communications, and the Nickname__c field is optional. I'm leaning towards option A, but I want to double-check the syntax.
TR
Tracey
1 year ago
Hmm, I'm a little unsure about this one. The wording of the question is a bit tricky, and I want to make sure I understand the requirements correctly before answering.
CU
Curtis
1 year ago
I think this question is pretty straightforward. The key is to use the IF function to check if the Nickname__c field has a value, and if so, use that value, otherwise use the FirstName.
MA
Matilda
1 year ago
Ah, the old 'BLANKVALUE' function. I haven't seen that one in a while. It works, but I prefer the more modern 'NOT(ISBLANK())' approach. Option A gets my vote.
MA
Marge
1 year ago
I think the answer is A.
IS
Isabelle
1 year ago
Haha, 'Nteknarne _..c'? What kind of field name is that? I'm pretty sure that's not a valid Salesforce field. I'm going to have to go with option A on this one.
OZ
Ozell
1 year ago
Yeah, 'Nteknarne _..c' doesn't sound right at all. Option A is definitely the way to go.
GE
Gerri
1 year ago
Option A is the correct formula to use in this case.
GA
Gail
1 year ago
Okay, let's see... the question is asking about how to select the contact's preferred name for email communications. I'd say option A looks good - it checks if the Nickname__c field is not blank, and if so, it uses that value, otherwise it falls back to the FirstName field.