I had an idea that adding the County Name for each Account record would be helpful when we split a Sales Territory by County. We are in an On-Demand environment so adding a table and doing a join isn't an option.
I was thinking that maybe a simple Business Rule that looks at the Postal Code and Returns the County Name would do the trick, but I'm really not excited about the challenge of keying the line item for each Postal Code - As you probably know, there are more than 40,000 of them in the USA (not counting the four digit extensions) :-)
I don't see a way to import the values into a business rule. I created the rule with three entries and exported it, but I don't see a way to edit the PBR file to add the codes effectively and import it.
Writing an Action element in a Process would also be very tedious and the execution of that action would be VERY slow.
Are there any other suggestions?
