- Print
- DarkLight
Country Code Formula
Replace MailingCountry with the API name of a country field of your choice. The field must live on a Mogli-Configured object.
Add and remove countries that aren’t in use, but be careful not to exceed formula character limits!
Please note that while most countries on Earth are on the list below, it should not be considered exhaustive and can be updated to meet your needs.
CASE(LOWER( MailingCountry ),
"afghanistan","93",
"åland","358 18",
"albania","355",
"algeria","213",
"american samoa","1 684",
"andorra","376",
"angola","244",
"anguilla","1 264",
"antigua and barbuda","1 268",
"argentina","54",
"armenia","374",
"aruba","297",
"ascension","247",
"australia","61",
"australian antarctic territory","672 1",
"australian external territories","672",
"austria","43",
"azerbaijan","994",
"bahamas","1 242",
"bahrain","973",
"bangladesh","880",
"barbados","1 246",
"barbuda","1 268",
"belarus","375",
"belgium","32",
"belize","501",
"benin","229",
"bermuda","1 441",
"bhutan","975",
"bolivia","591",
"bonaire","599 7",
"bosnia and herzegovina","387",
"botswana","267",
"brazil","55",
"british indian ocean territory","246",
"british virgin islands","1 284",
"brunei darussalam","673",
"bulgaria","359",
"burkina faso","226",
"burundi","257",
"cambodia","855",
"cameroon","237",
"canada","1",
"cape verde","238",
"cayman islands","1 345",
"central african republic","236",
"chad","235",
"chatham island, new zealand","64",
"chile","56",
"china","86",
"christmas island","61 89164",
"cocos (keeling) islands","61 89162",
"colombia","57",
"comoros","269",
"congo","242",
"congo, democratic republic of the","243",
"cook islands","682",
"costa rica","506",
"croatia","385",
"cuba","53",
"curaçao","599 9",
"cyprus","357",
"czech republic","420",
"denmark","45",
"diego garcia","246",
"djibouti","253",
"dominica","1 767",
"east timor (timor-leste)","670",
"easter island","56",
"ecuador","593",
"egypt","20",
"el salvador","503",
"equatorial guinea","240",
"eritrea","291",
"estonia","372",
"ethiopia","251",
"falkland islands","500",
"malvinas","500",
"faroe islands","298",
"fiji","679",
"finland","358",
"france","33",
"french guiana","594",
"french polynesia","689",
"gabon","241",
"gambia","220",
"georgia","995",
"germany","49",
"ghana","233",
"gibraltar","350",
"greece","30",
"greenland","299",
"grenada","1",
"guadeloupe","590",
"guam","1",
"guatemala","502",
"guinea","224",
"guinea-bissau","245",
"guyana","592",
"haiti","509",
"holy see","379",
"the vatican","379",
"vatican city state","379",
"honduras","504",
"hong kong","852",
"hungary","36",
"iceland","354",
"india","91",
"indonesia","62",
"iran","98",
"iraq","964",
"ireland","353",
"israel","972",
"italy","39",
"jamaica","1",
"japan","81",
"jordan","962",
"kazakhstan","7",
"kenya","254",
"kiribati","686",
"north korea","850",
"south korea","82",
"kuwait","965",
"kyrgyzstan","996",
"laos","856",
"lao pdr","856",
"latvia","371",
"lebanon","961",
"lesotho","266",
"liberia","231",
"libya","218",
"liechtenstein","423",
"lithuania","370",
"luxembourg","352",
"macao","853",
"republic of macedonia","389",
"macedonia","389",
"madagascar","261",
"malawi","265",
"malaysia","60",
"maldives","960",
"mali","223",
"malta","356",
"marshall islands","692",
"martinique","596",
"mauritania","222",
"mauritius","230",
"mayotte","262",
"mexico","52",
"micronesia","691",
"federated states of micronesia","691",
"moldova","373",
"monaco","377",
"mongolia","976",
"montenegro","382",
"montserrat","1",
"morocco","212",
"mozambique","258",
"myanmar","95",
"namibia","264",
"nauru","674",
"nepal","977",
"netherlands","31",
"netherlands antilles","599",
"new caledonia","687",
"new zealand","64",
"nicaragua","505",
"niger","227",
"nigeria","234",
"niue","683",
"norfolk island","672",
"northern mariana islands","1",
"norway","47",
"oman","968",
"pakistan","92",
"palau","680",
"palestine","970",
"palestinian territory","970",
"panama","507",
"papua new guinea","675",
"paraguay","595",
"peru","51",
"philippines","63",
"pitcairn","870",
"poland","48",
"portugal","351",
"puerto rico","1",
"qatar","974",
"réunion","262",
"romania","40",
"russia","7",
"russian federation","7",
"rwanda","250",
"saint helena","290",
"tristan da cunha","290",
"saint kitts","1",
"nevis","1",
"saint lucia","1",
"saint pierre","508",
"miquelon","508",
"saint vincent and the grenadines","1",
"the grenadines","1",
"samoa","685",
"san marino","378",
"são tomé and principe","239",
"saudi arabia","966",
"senegal","221",
"serbia","381",
"seychelles","248",
"sierra leone","232",
"singapore","65",
"slovakia","421",
"slovenia","386",
"solomon islands","677",
"somalia","252",
"south africa","27",
"spain","34",
"sri lanka","94",
"sudan","249",
"suriname","597",
"svalbard and jan mayen islands","47",
"norway","47",
"swaziland","268",
"antigua","268",
"barbuda","268",
"sweden","46",
"switzerland","41",
"syria","963",
"taiwan","886",
"tajikistan","992",
"tanzania","255",
"thailand","66",
"timor-leste","670",
"east timor","670",
"togo","228",
"tokelau","690",
"tonga","676",
"trinidad and tobago","1",
"tunisia","216",
"turkey","90",
"turkmenistan","993",
"turks and caicos islands","1",
"caicos islands","1",
"tuvalu","688",
"uganda","256",
"ukraine","380",
"united arab emirates","971",
"united kingdom","44",
"united states of america","1",
"us","1",
"usa","1",
"united states","1",
"america","1",
"uruguay","598",
"uzbekistan","998",
"vanuatu","678",
"venezuela","58",
"vietnam","84",
"virgin islands","1",
"wallis and futuna islands","681",
"yemen","967",
"zambia","260",
"zimbabwe","263",
NULL)