Questions tagged [country-and-state]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
18 views

What fields are converted by State and Country/Territory Picklist?

I am looking to implement this. what fields will be changed by this? Only the default ones? Or does this apply to custom fields from custom objects as well? For example, we have a field called ...
0 votes
0 answers
141 views

Address State and Country not visible on the records

Dear friends I have an interesting problem. The address fields are not correct visible on the records. On the account page I see all address fields, but on the Address record and Service Territory I ...
1 vote
1 answer
466 views

Error Country after enabling state and country picklist

Since I have enabled state and country picklist I get the following error: Update failed. First exception on row 0 with id 0013O00000rrYAFQA2; first error: FIELD_INTEGRITY_EXCEPTION, There's a ...
  • 2,184
0 votes
0 answers
164 views

Variable does not exist: MailingCountryCode

When I try to deploy to a scratch org a class that references the field MailingCountryCode on the object Contact, I receive the following error message : Variable does not exist: MailingCountryCode (...
  • 87
0 votes
2 answers
681 views

How to Get List Of Countries in Apex

I'm aware that Salesforce provides a native way to use country and state values in Account and Contact address fields. But what if I want to use apex to get those list of countries so that I can use ...
  • 531
2 votes
1 answer
171 views

SOQL Address Country not localized / translated

I'm querying an Account Address and want the country to be translated into the language of the requesting user. Sample query: SELECT BillingAddress FROM Account I maintained the translation of the ...
  • 23
0 votes
1 answer
101 views

AddressSettings / State & Country picklists translation

Question on AddressSettings / State & Country picklists: Does anyone know if there is a way to retrieve translations of country picklist by language via Metadata API / any other exposed salesforce ...
2 votes
1 answer
213 views

Importing missing State in State and Countries Picklist via API

I am trying to import a missing state code in Italy, SU (see https://www.iso.org/obp/ui/#iso:code:3166:IT IT-SU) so I created the state code manually on a scratch org and I fetched the modified ...
  • 1,642
0 votes
0 answers
27 views

How to insert a list of States in Salesforce with the Metadata API [duplicate]

Is it possible to insert a list of States in Salesforce with the Metadata API? How? Thank you very much. Additional Question (02-June-2021@12:11CEST): I have retrieved the XML file containing the ...
  • 1
1 vote
1 answer
500 views

Using Apex to query Country Picklist Integration Values

We are using global country picklist in our org. For historical reasons, some of our countries have a difference in the name of the country and the integration value of the country. From Apex, I ...
  • 2,611
0 votes
1 answer
252 views

Account Billing Address Picklist without State and Country Picklists

I'm trying to replace the Standard BillingCountry field on the Account with a picklist, but it seems I can't remove the standard field and replace it with a custom picklist - does anyone have any idea ...
0 votes
2 answers
513 views

The ShippingStateCode field contains 21, which is not an available state

I changed some integration values from the country / state pick list: When I try to insert a record by integration, I get the error: "The ShippingStateCode field contains 21, which is not an ...
1 vote
1 answer
1k views

Can we query State and Country/Territories Picklist via SOQL? [closed]

We need to check the validations manually in Batch Apex while creating SF Accounts? We have a scenario where we store all the data in our Custom Object (brought the data from the third party). In a ...
1 vote
1 answer
3k views

Display State Picklist Values in Custom LWC Record-Edit-Form

I have a custom LWC that displays contact information to edit. One of the fields is the MailingState. Currently this field is a standard input field but I would like it to display as a picklist. Its ...
  • 466
2 votes
1 answer
66 views

A user at higher role should have access to his subordinates records only. Is the solution to create multiple roles for the same level?

I have the following situation for role hierarchy: World | ------------- | | Europe Asia | |...
  • 466
0 votes
0 answers
70 views

Country/State Picklist Management through trigger

I am trying to map country and state from one custom object say 'User Submission' to Account's billing address. My custom object has more values of countries and states than standard Country/State ...
0 votes
1 answer
573 views

Can I add additional fields to "State and Country Picklists"

My org uses "State and Country Picklists" and I've been asked if it's possible add additional fields to the object so we can align each country to a region, sub-region and cluster and the ISO 3 digit ...
2 votes
1 answer
433 views

State and Country/Territory picklist enabled

Why is apex Trigger unable to get value from Country/BillingCountry field in a BEFORE INSERT/UPDATE trigger when State and Country/Territory picklist enabled and data created from salesforce UI in ...
1 vote
1 answer
5k views

How to apply State and Country Picklist on a Custom Object after enabling the feature

I followed the instructions for enabling the State and Country Picklist from https://resources.docs.salesforce.com/222/latest/en-us/sfdc/pdf/state_country_picklists_impl_guide.pdf And afterwards when ...
  • 11
1 vote
1 answer
338 views

SFDX - Can't Create Unlocked Package Version With BillingCountryCode/BillingStateCode

I am getting an error when trying to create a version of my unlocked package after adding Apex code that references the Account.BillingCountryCode and Account.BillingStateCode fields. Everything is ...
0 votes
1 answer
149 views

How to Enable all state list for State and country picklist

We were using the state and country text field in address. Now, we have enabled the standard state and country picklist. But the state picklist is shown for only 9 countries. Eg. USA has state ...
  • 187
2 votes
1 answer
1k views

Enabling State and Country/Territory Picklists

Currently we are using text field to store state and country. Now we want to enable State and Country/Territory Picklists to maintain data quality in salesforce. If I enable the picklist, what all ...
  • 187
0 votes
0 answers
153 views

Unable to convert a lead if country if country is not defalut country

few dacks back we have enabled country & state picklist values. So, when trying to convert a lead with a country called Canada they are facing an issue. because currently, the default country is ...
  • 1,474
0 votes
1 answer
2k views

Country Code(telephone) values in Salesforce

I have a scenario wherein we want to provide users with list of CountryName Country Code to select when providing contact details , here is how the list looks like : Has anybody had a requirement and ...
  • 45
1 vote
1 answer
389 views

Add value to list of valid States

I added a new State for the Country 'Canada' in Setup -> State and Country/Territory Picklists. The State is 'BC' and StateCode is 'BC2'. See the image below for how it looks: Now that 'BC' is a ...
  • 171
2 votes
1 answer
264 views

Why does the DependentPicklists class returns empty Map when trying to output Country and State picklist?

We are implementing the DependentPicklists class found in another answer on this site. Our org has State and Country picklists enabled, so we are trying to get this to work using the Contact....
9 votes
2 answers
508 views

New BUG in Winter 19: We can't turn ON Country State Picklists on fresh new Orgs (Confirmed as Know Issue by Salesforce)

We turn on Country-State-Picklists on almost every Org we touch. Assume we act on a NEW and BLANK Org, just fresh spun DE (Developer Edition) Org. But it is the same on any Org and we have tried lots ...
  • 33.8k
2 votes
0 answers
265 views

Issue with Datacloud.FindDuplicates & County-State-Picklist & PURGE Data

We have a strange issue arising in the context of the Salesforce Standard Deduplication functionality. It happens only, when Country-State-Picklist are enabled and a record (Account) is set to a ...
  • 33.8k
0 votes
1 answer
2k views

How do I retrieve Country and State Picklist Values (AddressSettings) via API?

How do I get a dependent list of States by Country from Salesforce via API? Our Use Case is: We need dependent Picklists on an integrated 3rd party web platform we intend to pass the returned ...
0 votes
1 answer
2k views

State/Country Picklist: The BillingStateCode field contains New Jersey, which isn't an available state

I am trying to migrate our production org to State/Country picklists. I followed the instructions of scanning my org in a Dev sandbox. There was no data to convert because it was a new blank sandbox, ...
0 votes
0 answers
494 views

Find state from Area Code

Our leads come in with just a phone number. I am looking to populate a custom field for the Lead State based off of that area code. I have already added a custom formula field to populate the time ...
  • 49
0 votes
1 answer
5k views

How do I get Country State Picklist Values in a lightning component? [duplicate]

We have State and Country Picklist enabled in the org. I cannot find a way to find out the list of states based on the selected country. I need this in the lightning component. I've used ...
  • 179
4 votes
1 answer
4k views

How to present state and country picklists with dependency logic in a Lightning Component?

It's not too hard to present the Contact/Account state and country picklists themselves, but the dependency filtering where when you select "United States" as the country only the 50 or so relevant ...
  • 131k
2 votes
1 answer
360 views

StateCode, CountryCode fields not available in SalesforceDX

I am trying to switch to DX but noticed that the CountryCode and StateCode are no longer being recognized by Salesforce in DX environment. Trying to reference those fields gives me an invalid field ...
  • 4,531
3 votes
1 answer
932 views

Visualforce State and Country Picklists - Standard Fields

Question Can a Visualforce Page be built so it displays the actual picklist values and dependencies for fields which incorporate State and Country Picklists? I tried using Field Sets as well as hard-...
  • 144k
1 vote
2 answers
603 views

Use Ampscript to convert state abbreviation to full state name

So the state data in our database is abbreviation but we have a client who wants to display the state dynamically in the body of the email but they want to display the full state name. I'm fairly new ...
  • 11
3 votes
1 answer
88 views

Account History tracking shows codes instead of full names after enabling State/Country picklists

I'm seeing that changes made on an Account after we have enabled State & Country/Territory Picklists on our sandbox default to showing the shortcodes for Country & State. Isn't it possible to ...
  • 1,989
4 votes
2 answers
2k views

SFDX Country/State picklist on scratch org

When I create new scratch org I'm not able push code which uses country/state picklist. Following command: force:source:push give error for class: Variable does not exist: Account....
  • 155
3 votes
1 answer
532 views

Automate creation of Salesforce states for countries

I would like users to be able to easily add new states to the state territory country picklist. See the picture We are an international business and it is not feasible to prefill out all the states ...
1 vote
1 answer
2k views

How to get the BillingstateCode from BillingState?

I have a requirement like, If user enter BillingState manually in visualforce page then BillingStateCode must have to set automatically based on the BillingState. I am thinking to use MAP in this ...
2 votes
1 answer
3k views

How to convert a two letter country code into a country name?

Before implementing country and state picklists we want to change our APEX to insert country names instead of country codes. Now. I could just have a big map of country codes to country names but the ...
3 votes
1 answer
4k views

Get two letter country code in Apex method

I want to write an Apex method that takes a country name as input and returns the equivalent two letter country code (ISO A2). Is there a way to write it without explicitly hard coding all countries ...
  • 351
-2 votes
2 answers
1k views

How to search a custom object using one or more input pick list fields from a VF page and display the result(s) in a pageBlockTable

accept the input as strings (in an extension), build & execute the query, populate a list element, display the list. Please give an example.
1 vote
0 answers
24 views

Additional geographical area on State

I'd like to add additional information on the State in Salesforce, for example the macro-area it belongs to, so that it can be used in any report, view, feature that make usage of an Address / State. ...
  • 1,642
0 votes
0 answers
438 views

State and Country Picklist on Visualforce page

I have a page which displays input fields from a fieldset on Opportunity object. The fieldset contains Country and State picklists which render properly. The only problem is when the Opportunity ...
  • 731
0 votes
1 answer
85 views

Issues after enabling state country pick list

We have implemented state/ country pick list after converting data. The issue is one class is shown in the customizations list which i need to update. i have below line in this class which is ...
1 vote
2 answers
4k views

Error: There's a problem with this state, even though it may appear correct. Please select a state from the list of valid states

I am updating records through batch class. I have state/Country picklist enabled for my ORG, however for few set of records BillingState picklist is having following values i. UNKNOWN VALUE ...
0 votes
1 answer
1k views

Get English Country Name from Country-Picklist

we plan to enable the new Salesforce Country/State-Picklists. we love the idea to have ISO Country-Codes but for a different system we need all the country-names in US-english spelling/name. our org-...
  • 113
0 votes
0 answers
682 views

Best Way to Populate Visualforce Picklists of Countries and States?

I am currently making a Visualforce Page for registration and I have both Country and State fields (both picklist) to populate. I have looked for resources online and I found out some possible ...
  • 655
1 vote
0 answers
2k views

Find whether the state code is related to the Country code

When state/country picklists are enabled, in an apex class can i find whether the state code is related to the country code. Currently if no check is done. I'm getting the below error in the visual ...