{"id":5949,"date":"2017-03-22T04:18:46","date_gmt":"2017-03-22T04:18:46","guid":{"rendered":"http:\/\/www.jitendrazaa.com\/blog\/?p=5949"},"modified":"2017-03-29T22:08:45","modified_gmt":"2017-03-29T22:08:45","slug":"state-country-picklist-in-salesforce-supporting-alpha-3-iso-code","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/state-country-picklist-in-salesforce-supporting-alpha-3-iso-code\/","title":{"rendered":"State &#038; Country picklist in Salesforce supporting Alpha-3 ISO code"},"content":{"rendered":"<p style=\"text-align: justify;\">Recently there was an interesting requirement in using <strong>State &amp; Country picklist of Salesforce<\/strong>. Salesforce saves ISO code of State &amp; Country picklist in Alpha-2 format however external system connecting to Salesforce needed Alpha-3 format.<\/p>\n<p style=\"text-align: justify;\">There has been <a href=\"https:\/\/success.salesforce.com\/ideaView?id=08730000000keCJAAY\">already an Idea on Idea Exchange<\/a> created around 4 year back to support the Alpha-3 format however doesn&#8217;t seems much progress from Salesforce product team.<\/p>\n<p style=\"text-align: justify;\">Anyways, there could be multiple way to handle this like, Maintaining Custom Setting ,\u00a0<a href=\"https:\/\/www.jitendrazaa.com\/blog\/tag\/custom-metadata-types\/\">Custom metadata <\/a>\u00a0or Custom object for mapping between ISO Alpha-2 and Alpha 3 and use trigger to populate custom ISO field on Account or Contact.<\/p>\n<p style=\"text-align: justify;\">While going through <a href=\"https:\/\/resources.docs.salesforce.com\/202\/latest\/en-us\/sfdc\/pdf\/state_country_picklists_impl_guide.pdf\">implementation guide<\/a> of <strong>State &amp; Country picklist<\/strong>, \u00a0there was mention of <strong>Integration Value\u00a0<\/strong>setting, which could be used to store the ISO Aplha-3 code. To see this option, navigate to &#8220;<em>Setup | Data Management |\u00a0State and Country\/Territory Picklists |\u00a0Configure States and Countries and Territories | country name | Edit&#8221; .\u00a0<\/em>Below image shows the setting<\/p>\n<figure id=\"attachment_5950\" aria-describedby=\"caption-attachment-5950\" style=\"width: 840px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-5950\" src=\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?resize=840%2C245&#038;ssl=1\" alt=\"State &amp; Country Picklist in Salesforce\" width=\"840\" height=\"245\" srcset=\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?resize=1024%2C299&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?resize=300%2C88&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?resize=768%2C224&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?resize=1200%2C351&amp;ssl=1 1200w, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/03\/State-Country-Picklist-in-Salesforce.png?w=1259&amp;ssl=1 1259w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/a><figcaption id=\"caption-attachment-5950\" class=\"wp-caption-text\">State &amp; Country Picklist in Salesforce<\/figcaption><\/figure>\n<p><!--more--><\/p>\n<h3>Impact of using Integration Value on State &amp; Country picklist<\/h3>\n<p style=\"text-align: justify;\">On Standard page layouts, reports, list views and other places, we will still see country name, however at database (SOQL) level it would be stored as ISO alpha-3. That means, if you have Apex code written and trying to compare state or country with free text then it would not work. you would need to use ISO alpha-3 code.<\/p>\n<p style=\"text-align: justify;\">Below short video\u00a0shows <strong>before and after impact of using integration value in State &amp; Country picklist<\/strong>.<\/p>\n<p><iframe loading=\"lazy\" title=\"Before and After   Using Integration value in State and Country Picklist\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/3-m-U8AfN4g?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><strong>Moving changes of State &amp; Country picklist<\/strong><\/p>\n<p style=\"text-align: justify;\">We can use <a href=\"https:\/\/www.jitendrazaa.com\/blog\/tag\/ant-migration-tool\/\">metadata API<\/a> to move changes from one org to another org instead of changing these values manually everywhere.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to use Integration Value in State &#038; Country picklist in Salesforce<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[385],"class_list":["post-5949","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-state-country"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":5070,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/dependent-picklist-in-salesforce-flow-using-custom-metadata-type-video\/","url_meta":{"origin":5949,"position":0},"title":"Dependent picklist in Salesforce flow using Custom Metadata type &#8211; Video","author":"Jitendra","date":"December 7, 2015","format":false,"excerpt":"Salesforce flow is great alternative for Visualforce pages used by admin. I have written, multiple blog post on Salesforce flow already and in this post we will discuss how we can create dependent picklist in Flow. If you are already using flow, might know that creating dependent picklist is not\u2026","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Salesforce flow - Dependent picklist output","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/12\/Salesforce-flow-Dependent-picklist-output.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":6877,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/get-picklist-values-in-apex\/","url_meta":{"origin":5949,"position":1},"title":"Get Picklist Values in Apex","author":"Jitendra","date":"August 22, 2017","format":false,"excerpt":"Code snippet of reading Picklist values in Salesforce Apex","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6252,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-path-read-only-lightning-component\/","url_meta":{"origin":5949,"position":2},"title":"Salesforce Path &#8211; Read Only Lightning Component","author":"Jitendra","date":"September 17, 2017","format":false,"excerpt":"Chevron Component build in Lightning with Same look and feel as of Salesforce Path in read only mode","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Read only Path (Chevron) Component in Salesforce Lightning","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/Chevron-Lightning-Component-Salesforce.gif?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/Chevron-Lightning-Component-Salesforce.gif?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/Chevron-Lightning-Component-Salesforce.gif?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2017\/09\/Chevron-Lightning-Component-Salesforce.gif?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4967,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-flow-interview-questions-for-admins-part-23\/","url_meta":{"origin":5949,"position":3},"title":"Salesforce Flow Interview Questions for admins &#8211; Part 23","author":"Jitendra","date":"December 7, 2015","format":false,"excerpt":"\ufeff Consider it interview questions or FAQs, However below are some high level information or gotchas related to Salesforce Flow. 221. How to create lookup field in Salesforce flow? Ans : There is no direct way to create a lookup field in flow but we can use workaround mentioned in\u2026","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Sample Salesforce flow using loop element","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/11\/Sample-Salesforce-flow-using-loop-element.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/11\/Sample-Salesforce-flow-using-loop-element.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/11\/Sample-Salesforce-flow-using-loop-element.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":4942,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-winter-16-top-features\/","url_meta":{"origin":5949,"position":4},"title":"Salesforce Winter 16 &#8211; Top features","author":"Jitendra","date":"October 28, 2015","format":false,"excerpt":"You can watch recording of my live stream channel as well to know more on Winter 16 features.\u00a0Powerpoint presentation used in livestream can be accessed from here. 1. Object Manager Objects are objects, even if they are standard or custom objects. Salesforce simplified navigation to access Objects, we can access\u2026","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Setup Audit Trail - Salesforce Winter 16","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Setup-Audit-Trail.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1038,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/salesforce-interview-questions-part-2\/","url_meta":{"origin":5949,"position":5},"title":"Salesforce Interview Questions \u2013 Part 2","author":"Jitendra","date":"September 11, 2010","format":false,"excerpt":"Interview questions of salesforce.com, interview questions of visualforce.com and APEX","rel":"","context":"In &quot;Salesforce&quot;","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Account Child relationship in salesforce","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/09\/Account-Child-relationship-in-salesforce.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/5949","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=5949"}],"version-history":[{"count":1,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/5949\/revisions"}],"predecessor-version":[{"id":5951,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/5949\/revisions\/5951"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=5949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=5949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=5949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}