#State0 人正在讨论

Hello I I am hoping someone can tell me for the State and Country/Territory Picklists setup configuation where do the State Codes come from? Is there a universal standard list for State Codes or can I just create my own if I want to add State/Provinces for a Country that does not already have one setup in Salesforce?

I was working on setting up a new org this weekend for a rad community project and came across the question of enabling #State Country Picklist​. I referenced the NPSP docs about the limitations and they seemed like reasonable tradeoffs for increased data accuracy, etc. Then, I ran a scan and found a lot of NPSP apex classes that would need to be updated. Is this what the limitations doc is referring to? Should we get @Salesforce Commons & Sprint Events​ to contribute code to make State Country Picklists a viable thing for the SFDO community? Wondering what @Nonprofit Get Started Hub​ and @Nonprofit Success Pack​ peeps think. And @Nonprofit User Group, Philadelphia, US​  of course. I will post the scan results in the comments.

Hi there, we see pardot - salesforce sync issues for few prospects 

Error message - Field Integrity Exception: There's a problem with this state, even though it may appear correct. Please select a state from the list of valid states.: State/Province.

Please help me how to resolve this issue.

Hello, I am new to the developer side and I am looking for a way to pull the standard country and state field values into a lightning component. I have read I would need to use a wire adapter, but so far no luck on finding more information about this. I can not use the standard address component as I need it to be translatable, be able to change the labels and make of the values required. Any ideas where I could go to?

Thanks,

Ruth

We have a Custom name for the Household {!{!FirstName}} {!LastName} Household - {!Account.BillingState} . However, when there is a change in the Address (people do move to different states), the name doesn't update. IS there around this, or should we just be updating it manually?

Thanks,

Mia

Re: State and Country Picklists Enabled with full name of the state as both the Name and Integration Value.  Does anyone have experiencing changing the Integration Value only, from the full word to the 2-letter code?  We don't likely have any custom code that looks at state, but we do bring data in via API that includes State info.  

Hi Everyone,

We consider changing the fields Countr/state to picklist instead of text. As we understand from Salesforce instructions, we should fix the data backward. I want to know if someone had experience with the same process and didn't adjust the data backward? What was the impact? I am also concerned about how much QA did you invest during the migration?

** We have millions of records, So fixing backward can take time. 

Thanks,

Omer

@Lior Harpaz  

Hi All, We are currently working to integrate Demandbase with our Pardot forms and we have run into an issue regarding States.  For some reason, Demandbase only supports the 2 or 3 character ISO code for State/Province and we need to pass the full State name to Salesforce with the Lead. 

Does anyone know a way to use Automation or Completion Rules in Pardot to allow us to translate 50 different State codes into the matching Full State Name?  Does Pardot support anything like a lookup table to make this process easier?

Appreciate any thoughts or guidance from the group!