Skip to main content

Use SWITCH to add a country flag in a record summary

E
Forum|alt.badge.img+6

A formula field can be used to SWITCH a country name to it's corresponding flag emoji (full formula below)

This can be handy to add a visual cue to a country and works nicely when added in record summaries like below/

This formula will include your flag emoji and using \n you can list other record attributes with a new line

"โ˜‘๏ธ " &{SOME_OTHER_FIELD}&"\n"&"โ˜‘๏ธ "&{YOUR_COUNTRY_FIELD}&" "&{FLAG}

 

SWITCH for Flag

SWITCH( {YOUR_COUNTRY_FIELD}, "Afghanistan", "๐Ÿ‡ฆ๐Ÿ‡ซ", "ร…land Islands", "๐Ÿ‡ฆ๐Ÿ‡ฝ", "Albania", "๐Ÿ‡ฆ๐Ÿ‡ฑ", "Algeria", "๐Ÿ‡ฉ๐Ÿ‡ฟ", "American Samoa", "๐Ÿ‡ฆ๐Ÿ‡ธ", "Andorra", "๐Ÿ‡ฆ๐Ÿ‡ฉ", "Angola", "๐Ÿ‡ฆ๐Ÿ‡ด", "Anguilla", "๐Ÿ‡ฆ๐Ÿ‡ฎ", "Antarctica", "๐Ÿ‡ฆ๐Ÿ‡ถ", "Antigua & Barbuda", "", "Argentina", "๐Ÿ‡ฆ๐Ÿ‡ท", "Armenia", "๐Ÿ‡ฆ๐Ÿ‡ฒ", "Aruba", "๐Ÿ‡ฆ๐Ÿ‡ผ", "Ascension Island", "๐Ÿ‡ฆ๐Ÿ‡จ", "Australia", "๐Ÿ‡ฆ๐Ÿ‡บ", "Austria", "๐Ÿ‡ฆ๐Ÿ‡น", "Azerbaijan", "๐Ÿ‡ฆ๐Ÿ‡ฟ", "Bahamas", "๐Ÿ‡ง๐Ÿ‡ธ", "Bahrain", "๐Ÿ‡ง๐Ÿ‡ญ", "Bangladesh", "๐Ÿ‡ง๐Ÿ‡ฉ", "Barbados", "๐Ÿ‡ง๐Ÿ‡ง", "Belarus", "๐Ÿ‡ง๐Ÿ‡พ", "Belgium", "๐Ÿ‡ง๐Ÿ‡ช", "Belize", "๐Ÿ‡ง๐Ÿ‡ฟ", "Benin", "๐Ÿ‡ง๐Ÿ‡ฏ", "Bermuda", "๐Ÿ‡ง๐Ÿ‡ฒ", "Bhutan", "๐Ÿ‡ง๐Ÿ‡น", "Bolivia", "๐Ÿ‡ง๐Ÿ‡ด", "Bosnia & Herzegovina", "๐Ÿ‡ง๐Ÿ‡ฆ", "Botswana", "๐Ÿ‡ง๐Ÿ‡ผ", "Bouvet Island", "๐Ÿ‡ง๐Ÿ‡ป", "Brazil", "๐Ÿ‡ง๐Ÿ‡ท", "British Indian Ocean Territory", "๐Ÿ‡ฎ๐Ÿ‡ด", "British Virgin Islands", "๐Ÿ‡ป๐Ÿ‡ฌ", "Brunei", "๐Ÿ‡ง๐Ÿ‡ณ", "Bulgaria", "๐Ÿ‡ง๐Ÿ‡ฌ", "Burkina Faso", "๐Ÿ‡ง๐Ÿ‡ซ", "Burundi", "๐Ÿ‡ง๐Ÿ‡ฎ", "Cambodia", "๐Ÿ‡ฐ๐Ÿ‡ญ", "Cameroon", "๐Ÿ‡จ๐Ÿ‡ฒ", "Canada", "๐Ÿ‡จ๐Ÿ‡ฆ", "Canary Islands", "๐Ÿ‡ฎ๐Ÿ‡จ", "Cape Verde", "๐Ÿ‡จ๐Ÿ‡ป", "Caribbean Netherlands", "๐Ÿ‡ง๐Ÿ‡ถ", "Cayman Islands", "๐Ÿ‡ฐ๐Ÿ‡พ", "Central African Republic", "๐Ÿ‡จ๐Ÿ‡ซ", "Ceuta & Melilla", ":ceuta_&_melilla:", "Chad", "๐Ÿ‡น๐Ÿ‡ฉ", "Chile", "๐Ÿ‡จ๐Ÿ‡ฑ", "China", "๎”“", "Christmas Island", "๐Ÿ‡จ๐Ÿ‡ฝ", "Clipperton Island", "๐Ÿ‡จ๐Ÿ‡ต", "Cocos (Keeling Islands", "๐Ÿ‡จ๐Ÿ‡จ", "Colombia", "๐Ÿ‡จ๐Ÿ‡ด", "Comoros", "๐Ÿ‡ฐ๐Ÿ‡ฒ", "Congo - Brazzaville", "๐Ÿ‡จ๐Ÿ‡ฌ", "Congo - Kinshasa", "๐Ÿ‡จ๐Ÿ‡ฉ", "Cook Islands", "๐Ÿ‡จ๐Ÿ‡ฐ", "Costa Rica", "๐Ÿ‡จ๐Ÿ‡ท", "Cรดte dโ€™Ivoire", "๐Ÿ‡จ๐Ÿ‡ฎ", "Croatia", "๐Ÿ‡ญ๐Ÿ‡ท", "Cuba", "๐Ÿ‡จ๐Ÿ‡บ", "Curaรงao", "๐Ÿ‡จ๐Ÿ‡ผ", "Cyprus", "๐Ÿ‡จ๐Ÿ‡พ", "Czech Republic", "๐Ÿ‡จ๐Ÿ‡ฟ", "Czechia", "๐Ÿ‡จ๐Ÿ‡ฟ", "Denmark", "๐Ÿ‡ฉ๐Ÿ‡ฐ", "Diego Garcia", "๐Ÿ‡ฉ๐Ÿ‡ฌ", "Djibouti", "๐Ÿ‡ฉ๐Ÿ‡ฏ", "Dominica", "๐Ÿ‡ฉ๐Ÿ‡ฒ", "Dominican Republic", "๐Ÿ‡ฉ๐Ÿ‡ด", "Ecuador", "๐Ÿ‡ช๐Ÿ‡จ", "Egypt", "๐Ÿ‡ช๐Ÿ‡ฌ", "El Salvador", "๐Ÿ‡ธ๐Ÿ‡ป", "Equatorial Guinea", "๐Ÿ‡ฌ๐Ÿ‡ถ", "Eritrea", "๐Ÿ‡ช๐Ÿ‡ท", "Estonia", "๐Ÿ‡ช๐Ÿ‡ช", "Ethiopia", "๐Ÿ‡ช๐Ÿ‡น", "European Union", "๐Ÿ‡ช๐Ÿ‡บ", "Falkland Islands", "๐Ÿ‡ซ๐Ÿ‡ฐ", "Faroe Islands", "๐Ÿ‡ซ๐Ÿ‡ด", "Fiji", "๐Ÿ‡ซ๐Ÿ‡ฏ", "Finland", "๐Ÿ‡ซ๐Ÿ‡ฎ", "France", "๐Ÿ‡ซ๐Ÿ‡ท", "French Guiana", "๐Ÿ‡ฌ๐Ÿ‡ซ", "French Polynesia", "๐Ÿ‡ต๐Ÿ‡ซ", "French Southern Territories", "๐Ÿ‡น๐Ÿ‡ซ", "Gabon", "๐Ÿ‡ฌ๐Ÿ‡ฆ", "Gambia", "๐Ÿ‡ฌ๐Ÿ‡ฒ", "Georgia", "๐Ÿ‡ฌ๐Ÿ‡ช", "Germany", "๐Ÿ‡ฉ๐Ÿ‡ช", "Ghana", "๐Ÿ‡ฌ๐Ÿ‡ญ", "Gibraltar", "๐Ÿ‡ฌ๐Ÿ‡ฎ", "Greece", "๐Ÿ‡ฌ๐Ÿ‡ท", "Greenland", "๐Ÿ‡ฌ๐Ÿ‡ฑ", "Grenada", "๐Ÿ‡ฌ๐Ÿ‡ฉ", "Guadeloupe", "๐Ÿ‡ฌ๐Ÿ‡ต", "Guam", "๐Ÿ‡ฌ๐Ÿ‡บ", "Guatemala", "๐Ÿ‡ฌ๐Ÿ‡น", "Guernsey", "๐Ÿ‡ฌ๐Ÿ‡ฌ", "Guinea", "๐Ÿ‡ฌ๐Ÿ‡ณ", "Guinea-Bissau", "๐Ÿ‡ฌ๐Ÿ‡ผ", "Guyana", "๐Ÿ‡ฌ๐Ÿ‡พ", "Haiti", "๐Ÿ‡ญ๐Ÿ‡น", "Heard & McDonald Islands", "", "Honduras", "๐Ÿ‡ญ๐Ÿ‡ณ", "Hong Kong", "๐Ÿ‡ญ๐Ÿ‡ฐ", "Hungary", "๐Ÿ‡ญ๐Ÿ‡บ", "Iceland", "๐Ÿ‡ฎ๐Ÿ‡ธ", "India", "๐Ÿ‡ฎ๐Ÿ‡ณ", "Indonesia", "๐Ÿ‡ฎ๐Ÿ‡ฉ", "Iran", "๐Ÿ‡ฎ๐Ÿ‡ท", "Iraq", "๐Ÿ‡ฎ๐Ÿ‡ถ", "Ireland", "๐Ÿ‡ฎ๐Ÿ‡ช", "Isle of Man", "๐Ÿ‡ฎ๐Ÿ‡ฒ", "Israel", "๐Ÿ‡ฎ๐Ÿ‡ฑ", "Italy", "๐Ÿ‡ฎ๐Ÿ‡น", "Jamaica", "๐Ÿ‡ฏ๐Ÿ‡ฒ", "Japan", "๐Ÿ—พ", "Jersey", "๐Ÿ‡ฏ๐Ÿ‡ช", "Jordan", "๐Ÿ‡ฏ๐Ÿ‡ด", "Kazakhstan", "๐Ÿ‡ฐ๐Ÿ‡ฟ", "Kenya", "๐Ÿ‡ฐ๐Ÿ‡ช", "Kiribati", "๐Ÿ‡ฐ๐Ÿ‡ฎ", "Kosovo", "๐Ÿ‡ฝ๐Ÿ‡ฐ", "Kuwait", "๐Ÿ‡ฐ๐Ÿ‡ผ", "Kyrgyzstan", "๐Ÿ‡ฐ๐Ÿ‡ฌ", "Laos", "๐Ÿ‡ฑ๐Ÿ‡ฆ", "Latvia", "๐Ÿ‡ฑ๐Ÿ‡ป", "Lebanon", "๐Ÿ‡ฑ๐Ÿ‡ง", "Lesotho", "๐Ÿ‡ฑ๐Ÿ‡ธ", "Liberia", "๐Ÿ‡ฑ๐Ÿ‡ท", "Libya", "๐Ÿ‡ฑ๐Ÿ‡พ", "Liechtenstein", "๐Ÿ‡ฑ๐Ÿ‡ฎ", "Lithuania", "๐Ÿ‡ฑ๐Ÿ‡น", "Luxembourg", "๐Ÿ‡ฑ๐Ÿ‡บ", "Macau SAR China", "๐Ÿ‡ฒ๐Ÿ‡ด", "Macedonia", "๐Ÿ‡ฒ๐Ÿ‡ฐ", "Madagascar", "๐Ÿ‡ฒ๐Ÿ‡ฌ", "Malawi", "๐Ÿ‡ฒ๐Ÿ‡ผ", "Malaysia", "๐Ÿ‡ฒ๐Ÿ‡พ", "Maldives", "๐Ÿ‡ฒ๐Ÿ‡ป", "Mali", "๐Ÿ‡ฒ๐Ÿ‡ฑ", "Malta", "๐Ÿ‡ฒ๐Ÿ‡น", "Marshall Islands", "๐Ÿ‡ฒ๐Ÿ‡ญ", "Martinique", "๐Ÿ‡ฒ๐Ÿ‡ถ", "Mauritania", "๐Ÿ‡ฒ๐Ÿ‡ท", "Mauritius", "๐Ÿ‡ฒ๐Ÿ‡บ", "Mayotte", "๐Ÿ‡พ๐Ÿ‡น", "Mexico", "๐Ÿ‡ฒ๐Ÿ‡ฝ", "Micronesia", "๐Ÿ‡ซ๐Ÿ‡ฒ", "Moldova", "๐Ÿ‡ฒ๐Ÿ‡ฉ", "Monaco", "๐Ÿ‡ฒ๐Ÿ‡จ", "Mongolia", "๐Ÿ‡ฒ๐Ÿ‡ณ", "Montenegro", "๐Ÿ‡ฒ๐Ÿ‡ช", "Montserrat", "๐Ÿ‡ฒ๐Ÿ‡ธ", "Morocco", "๐Ÿ‡ฒ๐Ÿ‡ฆ", "Mozambique", "๐Ÿ‡ฒ๐Ÿ‡ฟ", "Myanmar (Burma", "๐Ÿ‡ฒ๐Ÿ‡ฒ", "Namibia", "๐Ÿ‡ณ๐Ÿ‡ฆ", "Nauru", "๐Ÿ‡ณ๐Ÿ‡ท", "Nepal", "๐Ÿ‡ณ๐Ÿ‡ต", "Netherlands", "๐Ÿ‡ณ๐Ÿ‡ฑ", "New Caledonia", "๐Ÿ‡ณ๐Ÿ‡จ", "New Zealand", "๐Ÿ‡ณ๐Ÿ‡ฟ", "Nicaragua", "๐Ÿ‡ณ๐Ÿ‡ฎ", "Niger", "๐Ÿ‡ณ๐Ÿ‡ช", "Nigeria", "๐Ÿ‡ณ๐Ÿ‡ฌ", "Niue", "๐Ÿ‡ณ๐Ÿ‡บ", "Norfolk Island", "๐Ÿ‡ณ๐Ÿ‡ซ", "North Korea", "๐Ÿ‡ฐ๐Ÿ‡ต", "Northern Mariana Islands", "๐Ÿ‡ฒ๐Ÿ‡ต", "Norway", "๐Ÿ‡ณ๐Ÿ‡ด", "Oman", "๐Ÿ‡ด๐Ÿ‡ฒ", "Pakistan", "๐Ÿ‡ต๐Ÿ‡ฐ", "Palau", "๐Ÿ‡ต๐Ÿ‡ผ", "Palestinian Territories", "๐Ÿ‡ต๐Ÿ‡ธ", "Panama", "๐Ÿ‡ต๐Ÿ‡ฆ", "Papua New Guinea", "๐Ÿ‡ต๐Ÿ‡ฌ", "Paraguay", "๐Ÿ‡ต๐Ÿ‡พ", "Peru", "๐Ÿ‡ต๐Ÿ‡ช", "Philippines", " ๐Ÿ‡ต๐Ÿ‡ญ", "Pitcairn Islands", "๐Ÿ‡ต๐Ÿ‡ณ", "Poland", "๐Ÿ‡ต๐Ÿ‡ฑ", "Portugal", "๐Ÿ‡ต๐Ÿ‡น", "Puerto Rico", "๐Ÿ‡ต๐Ÿ‡ท", "Qatar", "๐Ÿ‡ถ๐Ÿ‡ฆ", "Rรฉunion", "๐Ÿ‡ท๐Ÿ‡ช", "Romania", "๐Ÿ‡ท๐Ÿ‡ด", "Russia", "๐Ÿ‡ท๐Ÿ‡บ", "Rwanda", "๐Ÿ‡ท๐Ÿ‡ผ", "Samoa", "๐Ÿ‡ผ๐Ÿ‡ธ", "San Marino", "๐Ÿ‡ธ๐Ÿ‡ฒ", "Sรฃo Tomรฉ & Prรญncipe", "๐Ÿ‡ธ๐Ÿ‡น", "Saudi Arabia", "๐Ÿ‡ธ๐Ÿ‡ฆ", "Senegal", "๐Ÿ‡ธ๐Ÿ‡ณ", "Serbia", "๐Ÿ‡ท๐Ÿ‡ธ", "Seychelles", "๐Ÿ‡ธ๐Ÿ‡จ", "Sierra Leone", "๐Ÿ‡ธ๐Ÿ‡ฑ", "Singapore", "๐Ÿ‡ธ๐Ÿ‡ฌ", "Sint Maarten", "๐Ÿ‡ธ๐Ÿ‡ฝ", "Slovakia", "๐Ÿ‡ธ๐Ÿ‡ฐ", "Slovenia", "๐Ÿ‡ธ๐Ÿ‡ฎ", "Solomon Islands", "๐Ÿ‡ธ๐Ÿ‡ง", "Somalia", "๐Ÿ‡ธ๐Ÿ‡ด", "South Africa", "๐Ÿ‡ฟ๐Ÿ‡ฆ", "South Georgia & South Sandwich", "๐Ÿ‡ฌ๐Ÿ‡ธ", "South Korea", "๐Ÿ‡ฐ๐Ÿ‡ท", "South Sudan", "๐Ÿ‡ธ๐Ÿ‡ธ", "Spain", "๐Ÿ‡ช๐Ÿ‡ธ", "Sri Lanka", "๐Ÿ‡ฑ๐Ÿ‡ฐ", "St. Barthรฉlemy", "๐Ÿ‡ง๐Ÿ‡ฑ", "St. Helena", "๐Ÿ‡ธ๐Ÿ‡ญ", "St. Kitts & Nevis", "๐Ÿ‡ฐ๐Ÿ‡ณ", "St. Lucia", "๐Ÿ‡ฑ๐Ÿ‡จ", "St. Martin", "๐Ÿ‡ฒ๐Ÿ‡ซ", "St. Pierre & Miquelon", "", "St. Vincent & Grenadines", "๐Ÿ‡ป๐Ÿ‡จ", "Sudan", "๐Ÿ‡ธ๐Ÿ‡ฉ", "Suriname", "๐Ÿ‡ธ๐Ÿ‡ท", "Svalbard & Jan Mayen", "๐Ÿ‡ธ๐Ÿ‡ฏ", "Swaziland", "๐Ÿ‡ธ๐Ÿ‡ฟ", "Sweden", "๐Ÿ‡ธ๐Ÿ‡ช", "Switzerland", "๐Ÿ‡จ๐Ÿ‡ญ", "Syria", "๐Ÿ‡ธ๐Ÿ‡พ", "Taiwan", "๐Ÿ‡น๐Ÿ‡ผ", "Tajikistan", "๐Ÿ‡น๐Ÿ‡ฏ", "Tanzania", "๐Ÿ‡น๐Ÿ‡ฟ", "Thailand", "๐Ÿ‡น๐Ÿ‡ญ", "Timor-Leste", "๐Ÿ‡น๐Ÿ‡ฑ", "Togo", "๐Ÿ‡น๐Ÿ‡ฌ", "Tokelau", "๐Ÿ‡น๐Ÿ‡ฐ", "Tonga", "๐Ÿ‡น๐Ÿ‡ด", "Trinidad & Tobago", "๐Ÿ‡น๐Ÿ‡น", "Tristan da Cunha", "๐Ÿ‡น๐Ÿ‡ฆ", "Tunisia", "๐Ÿ‡น๐Ÿ‡ณ", "Turkey", "๐Ÿ‡น๐Ÿ‡ท", "Turkmenistan", "๐Ÿ‡น๐Ÿ‡ฒ", "Turks & Caicos Islands", "๐Ÿ‡น๐Ÿ‡จ", "Tuvalu", "๐Ÿ‡น๐Ÿ‡ป", "U.S. Outlying Islands", "๐Ÿ‡บ๐Ÿ‡ฒ", "U.S. Virgin Islands", "๐Ÿ‡ป๐Ÿ‡ฎ", "Uganda", "๐Ÿ‡บ๐Ÿ‡ฌ", "Ukraine", "๐Ÿ‡บ๐Ÿ‡ฆ", "United Arab Emirates", "๐Ÿ‡ฆ๐Ÿ‡ช", "United Kingdom", "๐Ÿ‡ฌ๐Ÿ‡ง", "United Nations", "๐Ÿ‡บ๐Ÿ‡ณ", "United States", "๐Ÿ‡บ๐Ÿ‡ธ", "Uruguay", "๐Ÿ‡บ๐Ÿ‡พ", "Uzbekistan", "๐Ÿ‡บ๐Ÿ‡ฟ", "Vanuatu", "๐Ÿ‡ป๐Ÿ‡บ", "Vatican City", "๐Ÿ‡ป๐Ÿ‡ฆ", "Venezuela", "๐Ÿ‡ป๐Ÿ‡ช", "Vietnam", "๐Ÿ‡ป๐Ÿ‡ณ", "Wallis & Futuna", "๐Ÿ‡ผ๐Ÿ‡ซ", "Western Sahara", "๐Ÿ‡ช๐Ÿ‡ญ", "Yemen", "๐Ÿ‡พ๐Ÿ‡ช", "Zambia", "๐Ÿ‡ฟ๐Ÿ‡ฒ", "Zimbabwe", "๐Ÿ‡ฟ๐Ÿ‡ผ")

 

0 replies

Be the first to reply!

Reply


Most helpful members this week

Terms & Conditions