# Complex Country, State, City Suggestions

**URL:** <https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375>\
**Category:** Concepts\
**Created:** [February 23, 2022, 6:18am UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375 "2022-02-23T06:18:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![webchip1](https://forum.johnnydecimal.com/letter_avatar_proxy/v4/letter/w/3ab097/32.png) [@webchip1](https://forum.johnnydecimal.com/u/webchip1)\
**Post date:** [February 23, 2022, 6:18am UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375/1 "2022-02-23T06:18:04Z")

</div>

I work for a company that deals with several states, cities, and countries.

Any suggestions/ideas would be helpful as I try to simplify this somehow.

Here is an example:

Customers  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;United\_States  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AK  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cordova  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 2  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OH  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amelia  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 2  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;International  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Canada  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NB  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 2  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Greece  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Athens  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 1  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 2  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quotes  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Designs

Thank you for your time and input.

---

<div class="post-metadata">

**Author:** ![jdnumbers](https://forum.johnnydecimal.com/letter_avatar_proxy/v4/letter/j/c6cbf5/32.png) [@jdnumbers](https://forum.johnnydecimal.com/u/jdnumbers)\
**Post date:** [February 23, 2022, 11:48am UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375/2 "2022-02-23T11:48:57Z")

</div>

Hi. I’ll be following to see responses. See my post on 4 number JD numbers. I’m having a similar issue with several clients.

---

<div class="post-metadata">

**Author:** ![johnnydecimal](https://forum.johnnydecimal.com/user_avatar/forum.johnnydecimal.com/johnnydecimal/32/1759_2.png) [@johnnydecimal](https://forum.johnnydecimal.com/u/johnnydecimal)\
**Post date:** [February 23, 2022, 6:59pm UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375/3 "2022-02-23T18:59:15Z")

</div>

Here’s an idea I’ve never tried but have had in my mind for a while.

Countries already have a numerical identifier that everyone agrees on: their international dialling code. Australia is 61, for example. The UK 44. USA is 1 obviously, is Canada the same? That’s unhelpful but hey.

So do many cities and states. I know the USA’s area codes are well defined. Australian states each have a code.

Could you construct numbers for the first part of your tree, up to the point where you reach your projects/clients, using these already-known numbers?…

Otherwise I think I’d just be advocating for a use-the-alphabet-with-numbers-after-the-items approach like explained [here](https://forum.johnnydecimal.com/t/what-about-my-johnny-decimal-level-is-alphabetical/363/2).

---

<div class="post-metadata">

**Author:** ![webchip1](https://forum.johnnydecimal.com/letter_avatar_proxy/v4/letter/w/3ab097/32.png) [@webchip1](https://forum.johnnydecimal.com/u/webchip1)\
**Post date:** [February 23, 2022, 9:29pm UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375/4 "2022-02-23T21:29:44Z")

</div>

Thank you both for your replies it has been very helpful! I am trying to come up with something that will play well with SharePoint, PowerAutomate, and CRM365.

This is what I have so far and then I have an explanation below the example:

Africa\_101  
Canada\_102  
Caribbean\_103  
Central\_104  
&nbsp;&nbsp;&nbsp;MO-Joplin\_104.100  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 1\_104.100.01  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Project 2\_104.100.01  
East\_105  
Eastern Asia\_106  
Europe\_107  
Middle East\_108  
North America\_109  
South America\_110  
West\_111

The above regions line up with a choice field on our CRM and the city and state is also entered in the CRM when creating a new customer. This means with Power Automate when a customer is created I can automate creating the folder in sharepoint and create the relationship of the CRM customer to the folder location in SharePoint using the JD number (104.100) as a reference. (A column on the customer will have the JD number permanently stored and can be used by power automate to find the sharepoint folder)

Another plus is emails sent from the CRM can be tagged with the number automatically.

When an opportunity (project) is created on a customer it can nest inside the correct folder automatically because of the JD reference on the customer and I can tag the opportunity with the project reference JD number (104.100.01). Hope that makes some sense I am still trying to unpack it all from my mind.

I will experiment with brackets though as well to see how I like the look.

In my mind I don’t see it as a big of a deal to have a 4 digit number so is there something I am missing? For example I am sure there are more than 999 state-cities in the central region so if the number gets to something like this 104.8015.03 is that really a big deal?

I still need to do some more reading on your site though because I just found your site last night and has got me thinking.

In a perfect world I would have the users only use CRM to interface with the files then I could do just about whatever with the structure but unfortunately it would be hard to sell to leadership. They are too used to traditional folder structures so I am brainstorming a solution that can possibly work together.

This topic has come up so many times at the office and I always hit a brick wall however I think you are on to something here and I finally have hope that we can move toward better organization.

Thanks again guys!!

---

<div class="post-metadata">

**Author:** ![johnnydecimal](https://forum.johnnydecimal.com/user_avatar/forum.johnnydecimal.com/johnnydecimal/32/1759_2.png) [@johnnydecimal](https://forum.johnnydecimal.com/u/johnnydecimal)\
**Post date:** [February 24, 2022, 1:05am UTC](https://forum.johnnydecimal.com/t/complex-country-state-city-suggestions/375/5 "2022-02-24T01:05:29Z")

</div>

> [@webchip1](#):
>
> In my mind I don’t see it as a big of a deal to have a 4 digit number so is there something I am missing? For example I am sure there are more than 999 state-cities in the central region so if the number gets to something like this 104.8015.03 is that really a big deal?

Agree, not a big deal.