Workflow to Set Contact Owner by Zip Code

[LMichael]

I'm trying to set up a workflow to set the contact owner based on zip codes here in California. We cover most of central and southern california divided between two sales people. I started the workflow with an if/then branch. I tried to add the filter as "zip code is equal to" then add all the zip codes seperated by commas. Nothing shows up when I click save.

Do I need to add each zip code as a new filter? ex. zip code is equal to 91342 OR zip code is equal to 91344 OR etc.

Does anyone have any other suggestions on how to set this up?

Thanks!

[karstenkoehler · Accepted solution]

Hi @LMichael,

HubSpot doesn't interpret commas as a separator – however semicolons should work. I explained this in a earlier post here.

Could you try with semicolons, following the steps from the link above and report back?

Best regards!

[SBamaca]

Hi There!

I was wondering if you could help me. We are trying to add over 1000 postal codes to each territory and I am getting an error message. Is there a limit to the number of postal codes you can add? 

Thanks in advance,

Samantha

[Jaycee_Lewis]

Hey, @SBamaca  👋 I did some searching through past support cases for similar issues. There is an internal limit of 60000 bytes for lists. Have you checked the network tab in your browser's dev tools for more info on the warning you get? This is an older screenshot from another case, but it should be similar to what the 2024 version of Chrome Dev tools should look like.

 

You may need to look at alternatives and loading in 1000 or less at a time to see if you can get around the error that way. Lastly, if you need to, filing a support ticket is also an option for getting additional clarification.

Best,

Jaycee

[LMichael]

Thanks Karsten! That makes sense. Now the issue I'm running into is I don't have the "is equal to any" option, just "is equal to." So when I paste my list into "is equal to" is goes blank. Is this something I can change regarding the zip code properpty?

[karstenkoehler]

Hi @LMichael,

It looks like your "Zip Code" property was created as a number property. The system default "Postal code" is a single-line text:

When you navigate to Settings > Properties, and search for "Zip Code" you can double check the property type. Usually, if the property is already in use (in lists, workflows etc.), you can't change the type anymore.

A fix could a contact-based workflow that copies the "Zip Code" into the "Postal code" for each contact:

You can then use the "Postal code" from now on.

Let me know if you have any follow up questions!

[LMichael]

You are a lifesaver! Thank you so much for your help!