Olá! Nós temos uma Comunidade em Português!

Global Solution for Addresses: Country + State

We need a global solution for Countries and States.

 

The problem: With open text Country/State/City form fields, it's common for users to misspell their locations, or do things like selecting Berlin as a city and Brazil as a country. This basically makes it impossible to create reliable filters and often important leads get lost.

 

The Solution:

  • Select country from a dropdown list
  • After that, matching states should load into the State Picklist
  • Could even load matching cities after that

 

This is a problem we find in most CRM's in the world, and not even Salesforce seems to want to solve this. It is a really simple implementation since this kind of information is publically available

 

Pretty please Hubspot <3, this is simple to solve and EVERYONE would profit greatly from this. Help us keep our data up to date!

 

EDIT: it is very important that this be implemented in both the backend (CRM contacts + companies) and the frontend (Form submissions), so data stays consistent everywhere.

 

EDIT2: We would be willing to participate in a fundraiser to get this developped. Could some Hubspot developper post a getfunded campaign with a price proposal for this?

HubSpot updates
8 Comentários
HubDoPete Regular Contributor | Gold Partner | Certified Trainer
Regular Contributor | Gold Partner | Certified Trainer

Country field on Contacts is already a drop down, but is free-text on the Company Record.

In practice that is usually OK, as form fills go to the Contact so you can have a workflow that copies from Contact to Company when their Contact.Country is known but the Company.Country is unknown.

 

What is needed per this request is the additional mechanism of matching states per country, as a subset in the State Picklist.

 

City is troublesome to standardize as it's often where the Suburb name of the city is used rather than actual City name. 

Alternatively for some countries such as UK, you only need Postcode and Street Number and you can source the full address but it varies so widely by country it would be a stretch to add globally.

erikblues
Conselheiro estimado

@HubDoPete I agree. I added cities as an optional step, but what we need most is the Country -=> State Relationship.

 

But it is very important that this be implemented in both the backend (CRM contacts + companies) and the frontend (Form submissions), so data stays consistent everywhere.

Anonymous

I find this interesting and honestly... my forms never have the option to create drop down for the country field. Just created this quick form...

 

https://share.hsforms.com/1GowlvmSvTA2Oxt0q1bk1Fgr7ah

HubDoPete Regular Contributor | Gold Partner | Certified Trainer
Regular Contributor | Gold Partner | Certified Trainer

Innogo I find it strange your contact forms are not drop-down.

Ours are like this every time: https://www.hubdo.com/pandadoc-4-hubspot-partners-pd4hsp

I recommend checking with HubSpot Support - and please let us know here out of interest why yours is different.

HubDoPete Regular Contributor | Gold Partner | Certified Trainer
Regular Contributor | Gold Partner | Certified Trainer

Innogo you probably need to be setting different options when you create the form field.

Set it as drop down and click the load button to populate it with countries.

Delete any you don't need, if you have that requirement

https://knowledge.hubspot.com/articles/kcs_article/forms/add-new-options-to-a-form-field

Anonymous

@HubDoPete It worked... never knew about that feature of loading. Thanks! 

HubDoPete Regular Contributor | Gold Partner | Certified Trainer
Regular Contributor | Gold Partner | Certified Trainer

Great to hear Innogo, you're very welcome.

 

Hopefully in time, we'll get a feature upgrade for a Country->State schema for forms.

erikblues
Conselheiro estimado

@Anonymous nice to have you on board with this Smiley feliz

For us, it always gets very complicated when form contribution gets sent in a different format. Abbreviated or not, wrong spelling, capital letters or even weird simbols. It all makes the database get messy and breaks lot's of reports an automation.

 

For example: I assign leads based on countries and states. If the lead fills out the country with a tipping mistake, the workflow will not work.

 

So it all generates unnecessary manual work and errors. Basically, lots of time is lost on this.