topic Re: Validation on phone numbers in Tips, Tricks & Best Practices

Validation on phone numbers

LBKoch — Mon, 04 Apr 2022 12:26:13 GMT

Has difficulty seeing the value of the hole new feature on the contact phone numbers, with "Phone number validation".
On any contact persons, direct an mobile phone number.

Has anyone found a possible solution, so not all numbers need to be manually validated.

On Sales Professional

We have country codes on all contacts.

Regards
Lars

Re: Validation on phone numbers

karstenkoehler — Mon, 04 Apr 2022 12:19:59 GMT

Hi @LBKoch,

Could you specify which feature you're referring to (feel free to share a screenshot)?

If you're referring to phone number fields on HubSpot forms, then you can specify a minimum and maximum number of digits in the left sidebar:

If you're referring to phone number formatting, Operations Hub has data formatting workflows which can help with the phone number clean-up: https://knowledge.hubspot.com/workflows/format-your-data-with-workflows

I'm not aware of any out of the box features for validating all phone numbers.

Best regards

Re: Validation on phone numbers

LBKoch — Mon, 04 Apr 2022 12:22:53 GMT

Re: Validation on phone numbers

karstenkoehler — Mon, 04 Apr 2022 12:25:23 GMT

Hi @LBKoch,

Thank you for sharing. If you want this to be a bulk feature, I'd recommend requesting it in the HubSpot Ideas section of the community. The product team reviews these requests based on their popularity.

Best regards!

Re: Validation on phone numbers

LBKoch — Mon, 04 Apr 2022 12:27:45 GMT

Thanks, it not on landing pages or forms, but on contacts persons, an it all new, I got it on two of my costomers.

Re: Validation on phone numbers

CSwinburne — Tue, 05 Apr 2022 15:11:10 GMT

Can this feature be disabled or removed, it's an issue as can't copy number from hubspot contact property, now adds another step?

Re: Validation on phone numbers

michaeljay201 — Mon, 25 Apr 2022 19:45:14 GMT

@LBKoch,

After digging through existing Knowledge Base articles and blog posts to find any information on this update/change to phone number validation and formatting directly from Hubspot, I found...pretty much nothing.

So, I created a new Idea that encapsulates this Idea / feature request as well as others that I have come across in my search for info on phone number validation and auto-formatting. You can find it here.

Knowing that Hubspot only makes feature requests when a sufficient number of users request it, I would recommend upvoting and commenting as many of these ideas and posts as possible. The ones I found are here, here, here, and here.

Re: Validation on phone numbers

DocWatson — Thu, 28 Apr 2022 13:15:31 GMT

Yes, this is a pain. 99% of my contact numbers are within the US, and yet all of a sudden contact phone numbers are popping up forfoprmatting and not allowng me to just copy them into my dialer, etc.

Can we turn off international codes or something?

Mass edit the formats? Something please.. I'm using Starter Hub versions

Re: Validation on phone numbers

brittanyCP1 — Thu, 28 Apr 2022 14:35:43 GMT

AGREE! This is a huge waste of time and we want this feature turned OFF!

Re: Validation on phone numbers

brittanyCP1 — Thu, 28 Apr 2022 14:36:08 GMT

I completely agree with this! Being forced into "validating phone numbers" with no solutions for having Hubspot help us accomplish this, is a huge waste of time. Contacts fill out Hubspot forms on our website, and their phone numbers still come in "invalid." If we are forced into this change, Hubspot needs to make changes that allow Hubspot Forms to validate numbers on the forms themselves.

Re: Validation on phone numbers

cpsam — Thu, 28 Apr 2022 14:37:50 GMT

Can this feature be disabled? This is a waste of time; all of my contacts are in the US & I can't just copy & paste the phone #s in my phone quickly anymore. If we don't do the phone # exactly how HS wants it, it jumbles up the phone # & it's completely wrong.

Re: Validation on phone numbers

kvlschaefer — Thu, 28 Apr 2022 17:17:37 GMT

Hi @brittanyCP1, @DocWatson, and @cpsam,

Thanks for your feedback. I would encourage you to upvote the idea that @michaeljay201 created.

Our product team, who monitors the forum regularly, can read your specific use case and understand why this would be a useful functionality or change. It also helps other customers facing the same issue to advocate for its implementation on your behalf by upvoting on the thread as well.

Thank you,

Kristen

Re: Validation on phone numbers

CP-BWG — Sun, 01 May 2022 19:43:16 GMT

You referenced the Operations Hub workflows article, but there is nothing specific in there about phone numbers or region codes. Could you provide your method for putitng phone numbers through any of the "Formatting" Operations Hub workflow actions with the formatting steps that yield the desired result? We want to apply a region code and also format them all the same (ie, +1 (555) 555-1212, or +1 555-555-1212)

Re: Validation on phone numbers

dhartzer — Mon, 01 Aug 2022 17:11:54 GMT

I agree. There are several "new" features that require extra steps. When a CRM has 2 or 3 steps over the prior 1 step, that's a waste of time, in my opinion. I don't see any advantage to having a pop out box to enter a simple phone number. The other extra step occurs when adding associated companies. I much preferred the old way of typing and hitting <save>. Quick, easy and done. Please consider the end-user when creating these extra, unnecessary button pushes.

Re: Validation on phone numbers

Camille_Balhorn — Fri, 17 Feb 2023 23:17:15 GMT

Hey LBKoch,

I've found success importing these en masse since you posted a year ago!

Option 1: Format all phone numbers in your spreadsheet as '+11234567890 ext123 according to this Knowledge Base article. This one is for the US: +1. The ' is important so that it doesn't create a formula.

Option 2: Use Insycle. This is a data cleansing import application, and one of the pieces of data it cleanses/formats is phone number. See photo below--it can accurately import with country code. It shows USA here, but I've had other countries work!

Hope this helps--let me know if you try it again!

Re: Validation on phone numbers

MiaSrebrnjak — Tue, 21 Feb 2023 12:41:24 GMT

This is great, thanks for sharing @Camille_Balhorn! 🙂

Re: Validation on phone numbers

NDewey — Wed, 13 Mar 2024 20:44:53 GMT

COMPLETELY AGREE!

Re: Validation on phone numbers

AD42 — Thu, 06 Jun 2024 22:05:35 GMT

bump

Re: Validation on phone numbers

CCollins16 — Sun, 23 Jun 2024 19:55:02 GMT

Hey LBKoch

To remover the need for manual validation I user Zapier to automate phone number verification checks.

Zapier is compatible with Hubspot and you can link it to the OpenAI API (ChatGPT) to analyze fields in your Hubspot CRM. I use the OpenAI prompt function within Zapier to analyze the phone number field and the country field from Hubspot to produce a formatted response which I then use Zapier to pass to the Numverify API.

I provided some further screenshots on this link

https://community.hubspot.com/t5/Calling/Best-phone-number-validation-options-in-HubSpot/m-p/757659/thread-id/289

Simply link Hubspot upto Zapier then link in OpenAI API to analyze fields in your Hubspot

Zapier and Hubspot

Using Zapier pass number to be validated from the OpenAI API to Numverify API

Pass number to be validated by Numverify

Numverify will provide you with validation details about the number

Phone number validation results

Use Zapier automation to send the results back to Hubspot or a Google Sheet.

Hope this helps

Christopher