Populating Country Codes

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!

CASE( MailingCountry ,

"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",

"Mayotte","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",

"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)