Contacts Capitalization of Contact Fields

KeyWestScott

Sure that you all have lazy customers or even employees that when they enter their names do not capitalize their names.  

 

When sending out emails, or using personalization tokens on a page, it looks bad,

amateurish and just a poor UX to have someones name displayed as "john" instead of the first letter capitalized.

 

Needs to be a way to force or correct after the fact,  the first letter to go capitalized, on both first name and last name fields.  I realize that this isn't going to do anything for those that have two first  or last names, but this would be a great start.

 

Scott

11 Replies
Paul320
Participant | Gold Partner

This is a great idea.  I lose a lot of time over the course of a week correcting contact records I happend across where the capitalization in incorrect.  

 

To provide some flexibility, it would be really nice to have this as a function in a workflow where we can have some control over what gets capitalized.  So, for example, if someone entered in "mcdonald" in the last name field you could instruct the workflow to update it to look for "mcd" and if found in the beginning of the string, replace it with "McD".

 

You ought to be able to apply the function to any text field property so it can be used not just for first and last names, but also titles, company name, city, etc., etc.

 

If this was available, I'd run my entire database through it and create a Workflow to enroll every new contact record.

KeyWestScott
Key Advisor

Hey, @Paul320. I'm not sure that there would be any "logic" that you could effectively implement that would take into account a compound name. I've though about it as well.  If you used a workflow, you would need to have literlly hundreds of if/then statements to account for every iteration of this.

 

Personally, I'd be content with simply a first name (but then again you get caught with compound First Names as well.. ) maryellen  - Would that be Maryellen or Mary Ellen?????

 

Scott

Paul320
Participant | Gold Partner

Hey @KeyWestScott, Just having a function available in Workflows to capitalize the first letter of a text field (not just name fields) would be a huge step forward.  I'd be REALLY happy to get that.  But I think it is a small step forward to allow users to be able to list text substitutions if they are at the beginning of a string (mcd -> McD).  That way if I want to spend the time doing it, I can.  And if you don't, you won't.  This is no different than using a RegEx function when writing code.   It's totally doable and I'm surprised it hasn't already been done.  There's a forum post about this and a woman has created a free add-on you can install, but it's only for form submissions.  I'm going to post a link to your idea in the forum and ask folks to upvote it.  I hear you need to get north of 100 upvotes to get the attention of the HubSpot product managers.

Certemy-Malcolm
Participant

Absolutely agree there should be a system option to proper case any property inc contact names, company names, and city names. Should be smart enough to handle common quirks like MCDONALD to McDonald.

tcwir
Member

Please please please do this! 🙂 thanks

marcopolo
Participant

This would be really useful

aylalawlor
Member

Would love to see this added.

Fixing the formatting is time consuming for our team when we send out sequences, especially en mass.  

This can easily be done in excel so would like to see that option added here

ShaneJ
HubSpot Product Team

Hi There @KeyWestScott

 

We appreciate the idea and for the upvotes from the rest of the customers here. I will bring this idea to my team and come back to update this thread. Just for transparency it is unlikely we will make this change in this quarter so i will leave this as not currently planned for now. 

 

All the best and i will be back in touch soon.

 

Best,

Shane Janssens

PM Marketing Email

Status updated to: Not Currently Planned
ShaneJ
HubSpot Product Team
 
OCWatson
Member

How's the roadmap looking for this feature? Would be really helpful. Excel can do it (the "Proper") function, but it's a huge pain to export my entire list, apply the Proper function to their first names, and reimport. 

tcwir
Member

I'm guessing this is very simple coding... please 🙂