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?
Thank you as always for your continued feedback, it helps us build a great product.
We are constantly evaluating and re-evaluating our priorities and roadmap to deliver as much value to our customers as possible. At this time this request is not something our team is currently planning to build natively into HubSpot. This is certainly subject to change in the future and we will update this idea if that becomes the case.
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.
@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.
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.
I agree this would be a great option to have. If properties had the capabilities of option groups, this could easily be filtered using Javascript on forms.
Thank you as always for your continued feedback, it helps us build a great product.
We are constantly evaluating and re-evaluating our priorities and roadmap to deliver as much value to our customers as possible. At this time this request is not something our team is currently planning to build natively into HubSpot. This is certainly subject to change in the future and we will update this idea if that becomes the case.
In Contacts, it seems Country is DropDown but for states, it shows the only US States.
For Companies there is no such option so if you guys can make country loading and states that would be great. We will be happy to wait for this feature.
Come on, you already have a logic structure on your forms! just get all the states/provinces of all countries (publicly available) and throw them all in one list, set the logic on which items to show respectively depending on the selected country - was that hard? I think this was already requested way older than this one but come one, this one is almost 3 years old and this features has been around way before that. Why can't you just copy how they do it? Seriously, is there anyone actually working on this?
I am totally surprised about this. I was able to import a standard country picklist to use in Hubspot. Why is there no similar option for States in the US.
Agree that these kinds of standard data points filled from forms SHOULD NEVER BE free text fields. THa'ts programming 101.
Come on Hubspot...like seriously disappointed about this and the lack of prioritization.
Has this been resolved in any way with conditional logic? I aimed to map a new State picklist with the State Province code picklist property in Salesforce, however error messages appear as you need ALL states in all countries on one list. Conditional logic therefore, can't be applied when picking USA, and only revealing the US states.
Instead, the only workaround I can think of is to have multiple custom properties for state for different countries (which isn't feasible) and then to apply conditional logic to each on forms, or at the account level. From there, you could create a workflow to then copy the picklist value as a 'copy to property' for the single text field in Mailing State Province.
This seems to be the only way to have Sales see the value in Salesforce...
I think it would be more than beneficial as the current process opens up to user errors / mis typing / utilising a variety of terms to address the same location - e.g. USA / United States / United States of America, Holland / Netherlands; United Arab Emirates / UAE or United Kingdom / Great Britain / UK / England as just a couple of examples. If you try then to filter by country you may inadvertently miss certain entries as they are not within the specified filter criteria.
In Salesforce there is definitely a defined country / state list option
