Why is the LastName field required for the contact? What is the best approach to import contacts that only have the first name?Upper / Lower caseData Import Wizard for Contacts, prevent duplicates?Make contact firstname and lastname mandatoryError with new unified import wizardwhen importing data into salesforce for a custom object I got some rows that were not importedDisplay contacts with same user firstname and lastnameHad a user put parentheses in a last name for a contact and the contact wouldn't update after thatSOQL - Query for Last Name of ContactsContacts with MiddleName values and queriesFormula for a field
What does this symbol on the box of power supply mean?
When the Torah was almost lost and one (or several) Rabbis saved it?
Why are C64 games inconsistent with which joystick port they use?
Where is the logic in castrating fighters?
Have 1.5% of all nuclear reactors ever built melted down?
Caught student / friend cheating on the final exam that I proctored
Can I tell a prospective employee that everyone in the team is leaving?
How should I introduce map drawing to my players?
What are the real benefits of using Salesforce DX?
Pirate democracy at its finest
What is the object moving across the ceiling in this stock footage?
Should breaking down something like a door be adjudicated as an attempt to beat its AC and HP, or as an ability check against a set DC?
Apache redirect to https:/www only partially working
Can a person survive on blood in place of water?
Why were helmets and other body armour not commonplace in the 1800s?
Are these reasonable traits for someone with autism?
Why didn't Thanos use the Time Stone to stop the Avengers' plan?
Sitecore 9.0 works with solr 7.2.1?
Would Jetfuel for a modern jet like an F-16 or a F-35 be producable in the WW2 era?
Why didn't Project Mercury advance to an orbital flight on their second mission?
Website returning plaintext password
Is the Indo-European language family made up?
Popcorn is the only acceptable snack to consume while watching a movie
I know that there is a preselected candidate for a position to be filled at my department. What should I do?
Why is the LastName field required for the contact? What is the best approach to import contacts that only have the first name?
Upper / Lower caseData Import Wizard for Contacts, prevent duplicates?Make contact firstname and lastname mandatoryError with new unified import wizardwhen importing data into salesforce for a custom object I got some rows that were not importedDisplay contacts with same user firstname and lastnameHad a user put parentheses in a last name for a contact and the contact wouldn't update after thatSOQL - Query for Last Name of ContactsContacts with MiddleName values and queriesFormula for a field
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
The reason for this question is that I have a spreadsheet with lots of contacts to import, but some of them only have the first name. The LastName, being mandatory, will make my job harder.
I have seen people switching the FirstName and LastName labels so that the first name is mandatory for the user (but on the API, the user is filling the last name), but that seems to be a bad workaround to me.
What would be the best practice to import contacts that do not have the last name? Put something generic on the field?
contact required-field data-import
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
add a comment |
The reason for this question is that I have a spreadsheet with lots of contacts to import, but some of them only have the first name. The LastName, being mandatory, will make my job harder.
I have seen people switching the FirstName and LastName labels so that the first name is mandatory for the user (but on the API, the user is filling the last name), but that seems to be a bad workaround to me.
What would be the best practice to import contacts that do not have the last name? Put something generic on the field?
contact required-field data-import
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
1
I have seen elsewhere people useLNUwhich representsLast Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.
– Jayant Das
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago
add a comment |
The reason for this question is that I have a spreadsheet with lots of contacts to import, but some of them only have the first name. The LastName, being mandatory, will make my job harder.
I have seen people switching the FirstName and LastName labels so that the first name is mandatory for the user (but on the API, the user is filling the last name), but that seems to be a bad workaround to me.
What would be the best practice to import contacts that do not have the last name? Put something generic on the field?
contact required-field data-import
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
The reason for this question is that I have a spreadsheet with lots of contacts to import, but some of them only have the first name. The LastName, being mandatory, will make my job harder.
I have seen people switching the FirstName and LastName labels so that the first name is mandatory for the user (but on the API, the user is filling the last name), but that seems to be a bad workaround to me.
What would be the best practice to import contacts that do not have the last name? Put something generic on the field?
contact required-field data-import
contact required-field data-import
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
asked 8 hours ago
Renato OliveiraRenato Oliveira
5,52422158
5,52422158
1
I have seen elsewhere people useLNUwhich representsLast Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.
– Jayant Das
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago
add a comment |
1
I have seen elsewhere people useLNUwhich representsLast Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.
– Jayant Das
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago
1
1
I have seen elsewhere people use
LNU which represents Last Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.– Jayant Das
8 hours ago
I have seen elsewhere people use
LNU which represents Last Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.– Jayant Das
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago
add a comment |
1 Answer
1
active
oldest
votes
As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get away with it.
As for the workaround, as you have noted you can either switch the FirstName to the LastName
OR
I have seen people using a notion LNU which represents Last Name Unknown (or UND Último Nome Desconhecido in Portuguese :) ) to populate the LastName field. I have also seen this used widely with some Organizations when people don't have a valid Last Name.
One other approach that I have seen around especially with Government Authorities where Last Name is always required, they use the approach of populating the First Name as Last Name and then using FNU for the First Name which represents First Name Unknown. (I have had a personal experience with this)
So as long as you have a way to identify such records, you can go with any of these approaches.
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f263648%2fwhy-is-the-lastname-field-required-for-the-contact-what-is-the-best-approach-to%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get away with it.
As for the workaround, as you have noted you can either switch the FirstName to the LastName
OR
I have seen people using a notion LNU which represents Last Name Unknown (or UND Último Nome Desconhecido in Portuguese :) ) to populate the LastName field. I have also seen this used widely with some Organizations when people don't have a valid Last Name.
One other approach that I have seen around especially with Government Authorities where Last Name is always required, they use the approach of populating the First Name as Last Name and then using FNU for the First Name which represents First Name Unknown. (I have had a personal experience with this)
So as long as you have a way to identify such records, you can go with any of these approaches.
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
add a comment |
As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get away with it.
As for the workaround, as you have noted you can either switch the FirstName to the LastName
OR
I have seen people using a notion LNU which represents Last Name Unknown (or UND Último Nome Desconhecido in Portuguese :) ) to populate the LastName field. I have also seen this used widely with some Organizations when people don't have a valid Last Name.
One other approach that I have seen around especially with Government Authorities where Last Name is always required, they use the approach of populating the First Name as Last Name and then using FNU for the First Name which represents First Name Unknown. (I have had a personal experience with this)
So as long as you have a way to identify such records, you can go with any of these approaches.
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
add a comment |
As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get away with it.
As for the workaround, as you have noted you can either switch the FirstName to the LastName
OR
I have seen people using a notion LNU which represents Last Name Unknown (or UND Último Nome Desconhecido in Portuguese :) ) to populate the LastName field. I have also seen this used widely with some Organizations when people don't have a valid Last Name.
One other approach that I have seen around especially with Government Authorities where Last Name is always required, they use the approach of populating the First Name as Last Name and then using FNU for the First Name which represents First Name Unknown. (I have had a personal experience with this)
So as long as you have a way to identify such records, you can go with any of these approaches.
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
As for the LastName being mandatory, I can only say that it's by design. And seems there were ideas to get it optional, but Salesforce doesn't have any plan to do so. So it is very unlikely we can get away with it.
As for the workaround, as you have noted you can either switch the FirstName to the LastName
OR
I have seen people using a notion LNU which represents Last Name Unknown (or UND Último Nome Desconhecido in Portuguese :) ) to populate the LastName field. I have also seen this used widely with some Organizations when people don't have a valid Last Name.
One other approach that I have seen around especially with Government Authorities where Last Name is always required, they use the approach of populating the First Name as Last Name and then using FNU for the First Name which represents First Name Unknown. (I have had a personal experience with this)
So as long as you have a way to identify such records, you can go with any of these approaches.
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
edited 7 hours ago
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
answered 8 hours ago
Jayant DasJayant Das
21.8k21433
21.8k21433
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
add a comment |
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
2
2
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
Brilliant workaround, reminds me of a former colleague in previous company having name as firstname.lnu@company.com
– Raul
7 hours ago
2
2
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
@Raul I have also seen another approach on this especially with government authorities where say Last Name is always required and that a person doesn't have one but only First Name, they will use the First Name as Last Name and then have the First Name referred as FNU (First Name Unknown).
– Jayant Das
7 hours ago
add a comment |
Thanks for contributing an answer to Salesforce Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f263648%2fwhy-is-the-lastname-field-required-for-the-contact-what-is-the-best-approach-to%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
I have seen elsewhere people use
LNUwhich representsLast Name Unknown. Salesforce doesn't have any plan to remove this validation from last name.– Jayant Das
8 hours ago
That sounds reasonable enough, actually. 🤔 UND ("Último Nome Desconhecido", in Portuguese) sounds good.
– Renato Oliveira
8 hours ago
Please answer the question! I'll happily accept that as the answer.
– Renato Oliveira
8 hours ago