How to overcome 1000 Contact Properties limit for Postcode/ Zip and Suburb?

SOLVE
KerrieSheaves
Participant

Has anyone managed to work out how you can overcome the property limit? 

I need to include a list of 16000 suburbs, and their corresponding postcodes (the postcodes are under 1000 but each postcode has multiple Suburb names within that zip/postcode). 

For mailing purposes we need to be accurate with the suburb name.

 

Any ideas?? 

0 Upvotes
2 Accepted solutions

Accepted Solutions
Mike_Eastwood
Solution
Key Advisor | Gold Partner

Hi @KerrieSheaves 

 

My first reaction is to create a HubSpot Integration (App) that sets the property from an external source.

 

The App would work something like this:

1. when Suburb is changed in HubSpot call a Webhook (in the App)

2. the App looks up the suburb and populates the Suburb (with the correct capitalisation) and sets the Zip Code.

 

Alternately, if the data is entered by a HubSpot user (in the CRM) or a Form (on a website) you could have some Javascript to create a "predictive text" list. When a choice is made it populates all your required fields e.g. suburb, zip.

 

I would need to know more about your business process to narrow this down to a practical solution. And, the solutions I'm recommending require time and budget.

 

Do you need to handle countries? (We're in New Zealand so we often fight with forms that won't validate our address).

 

Feel free to contact me directly if I can help.


Cheers

Mike

 

p.s. thank you @jennysowyrda for the heads up!

View solution in original post

mike-ward
Solution
Key Advisor

Hi @KerrieSheaves ,

 

I may be missing something here, but the 1,000 contact properties limit is for creating custom fields. The number of fields you should need for this usecase is just zip and suburb, right? What you want is a restriction on the number of valid values for each one, right?

 

How is your data being entered here? From a form directly by users? If so, the solution suggested by @Mike_Eastwood to validate this upon entry is definitely the way to go. With 16,000 suburbs, you probably want to do something like store that in a JSON file then parse it using a search library in JavaScript so users pick out what they need. Your forms will then always be correct at the point of entry.

 

And you can use a similar approach for entering contacts internally, rather than using Create New Contact directly in the HubSpot UI. Given that you have 16,000 suburbs you'll also (presumably) need a process for updating those suburbs as new suburbs are created, so having a standard structured JSON file will help with that process.

 

For such a specific requirement, I definitely think you're looking at a little custom development here, I can't see any way of doing this just with out-of-the-box HubSpot functionality.

 

Master data is always fun 🙂

 

Cheers,

Mike

View solution in original post

3 Replies 3
jennysowyrda
Community Manager

HI @KerrieSheaves,

 

I wanted to begin by sharing this thread  where a user asked a similar question. 

 

@mike-ward@Mike_Eastwood@Ben_M do you have any suggestions for overcoming this limit?

 

Thanks,
Jenny


We are excited to announce that the Community will be launching a weekly newsletter on November 2, 2020!
Sign up today!
0 Upvotes
Mike_Eastwood
Solution
Key Advisor | Gold Partner

Hi @KerrieSheaves 

 

My first reaction is to create a HubSpot Integration (App) that sets the property from an external source.

 

The App would work something like this:

1. when Suburb is changed in HubSpot call a Webhook (in the App)

2. the App looks up the suburb and populates the Suburb (with the correct capitalisation) and sets the Zip Code.

 

Alternately, if the data is entered by a HubSpot user (in the CRM) or a Form (on a website) you could have some Javascript to create a "predictive text" list. When a choice is made it populates all your required fields e.g. suburb, zip.

 

I would need to know more about your business process to narrow this down to a practical solution. And, the solutions I'm recommending require time and budget.

 

Do you need to handle countries? (We're in New Zealand so we often fight with forms that won't validate our address).

 

Feel free to contact me directly if I can help.


Cheers

Mike

 

p.s. thank you @jennysowyrda for the heads up!

View solution in original post

mike-ward
Solution
Key Advisor

Hi @KerrieSheaves ,

 

I may be missing something here, but the 1,000 contact properties limit is for creating custom fields. The number of fields you should need for this usecase is just zip and suburb, right? What you want is a restriction on the number of valid values for each one, right?

 

How is your data being entered here? From a form directly by users? If so, the solution suggested by @Mike_Eastwood to validate this upon entry is definitely the way to go. With 16,000 suburbs, you probably want to do something like store that in a JSON file then parse it using a search library in JavaScript so users pick out what they need. Your forms will then always be correct at the point of entry.

 

And you can use a similar approach for entering contacts internally, rather than using Create New Contact directly in the HubSpot UI. Given that you have 16,000 suburbs you'll also (presumably) need a process for updating those suburbs as new suburbs are created, so having a standard structured JSON file will help with that process.

 

For such a specific requirement, I definitely think you're looking at a little custom development here, I can't see any way of doing this just with out-of-the-box HubSpot functionality.

 

Master data is always fun 🙂

 

Cheers,

Mike

View solution in original post