Problem with State/Province Code showing the wrong 'state' in a template field

We are using Salesforce's State and Country picklists. When we display the State/Province Code in a separate column on a table component, the field shows the appropriate 'state' based on the selected country code and state/province code on the record. When we display the State/Province Code in a template field, it pulls in the wrong 'state' for the selected country code and state/province code on the record.

In this example, you can see that we have set the state and country to be Pennsylvania and United States.

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1191949/RackMultipart20150421-984-3hx9m0-2015-04-21_11_41_51-salesforcecom_-_Enterprise_Edition_inlinepng1429630938

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1191949/RackMultipart20150421-984-3hx9m0-2015-04-21_11_41_51-salesforcecom_-_Enterprise_Edition_inlinepng1429630938

Viewing the same record in a template field, shows:

Note that 'Palermo' is a province in Italy. It's State/Province Code is 'PA' and matches Pennsylvania's code.

Bill McCullough, Champion

13,602 Points

Posted 5 years ago

5 years ago

Rob Hatch, Official Rep

44,968 Points

There are two sets of fields - for State and Country, there is a picklist field titled code and a text field. Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1191979/31696-uzn2lf_inline.png?1429633451

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1191979/31696-uzn2lf_inline.png?1429633451

In my testing, if you change the countryCode field to Italy, the Normal State field will not update automatically while the State Code field will be updated to Palermo.

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1191981/8331-1aiopo2_inline.png?1429633726

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1191981/8331-1aiopo2_inline.png?1429633726

So, make sure you are showing the same set of fields. Either the code or the normal ones. But not a mix...

Comment

1 person likes this

2017-05-10T12:53:50+00:00

Rajesh Kumar

788 Points

Thanks Buddy ,

2017-05-11T10:33:02+00:00

Bill McCullough, Champion

13,592 Points

Rajesh,

As a workardound, we added a Salesforce formula field to display the value from the StateCode field. We use this in reference fields or template fields to display the correct 2 letter code instead of the rendered 'State Name' that shows the wrong state.

I think using a triple mustache should work to display the 2 letter code instead of the rendered name (e.g. {{{MailingStateCode}}}).

Thanks,

Bill

2017-05-23T13:31:34+00:00

Rajesh Kumar

788 Points

Hi Bill ,

This is very easy to show state name according to Country Name .We have used filed editor component in Skuid page ,

After is working fine , U can also use table .

Thanks,

Rajesh

5 years ago

Bill McCullough, Champion

13,602 Points

Rob,

Thanks for your reply. I was able to isolate what the issue seems to be. It's not a problem with the template field. It seems to be with using the Parent relationship to traverse the object data and pull in the State Code field from the Parent object. In my first screenshot I was building a list view based on a junction object. I was using the Parent relationship to pull in the State Code field.

I have created a list view based on the Contact object. As you can see I can pull in the State Code field for the Contact object without issue. When I use the Parent relationship to the Account object and pull in the State Code field, I get the results that I reported where the Shipping State Code on the parent Account to the Contact object shows as a 'state/province' for another country.

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192296/RackMultipart20150422-28196-11sasez-2015-04-22_08_17_57-salesforcecom_-_Enterprise_Edition_inlinepng1429705198

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192296/RackMultipart20150422-28196-11sasez-2015-04-22_08_17_57-salesforcecom_-_Enterprise_Edition_inlinepng1429705198

I have attached the xml for my page so you can install it in your org. Let me know if you need more details.

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" showsidebar="true" showheader="true" tabtooverride="Contact">
   <models>
      <model id="Contact" limit="100" query="true" createrowifnonefound="false" sobject="Contact">
         <fields>
            <field id="FirstName"/>
            <field id="LastName"/>
            <field id="CreatedDate"/>
            <field id="MailingCity"/>
            <field id="MailingCountryCode"/>
            <field id="MailingStateCode"/>
            <field id="MailingStreet"/>
            <field id="AccountId"/>
            <field id="Account.Name"/>
            <field id="Mailing_Zip_Code_Lookup__r.Name"/>
            <field id="Account.ShippingCountryCode"/>
            <field id="Account.ShippingStateCode"/>
         </fields>
         <conditions/>
         <actions/>
      </model>
   </models>
   <components>
      <pagetitle model="Contact">
         <maintitle>
            <template>{{Model.labelPlural}}</template>
         </maintitle>
         <subtitle>
            <template>Home</template>
         </subtitle>
         <actions>
            <action type="savecancel"/>
         </actions>
      </pagetitle>
      <skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Contact" mode="read">
         <fields>
            <field id="FirstName" allowordering="true"/>
            <field id="LastName" allowordering="true"/>
            <field id="AccountId"/>
            <field id="Account.ShippingStateCode"/>
            <field id="Account.ShippingCountryCode"/>
            <field type="COMBO" valuehalign="">
               <label>Account Template Field</label>
               <template>{{Account.ShippingStateCode}} {{Account.ShippingCountryCode}}</template>
            </field>
            <field id="MailingStateCode" valuehalign="" type=""/>
            <field id="MailingCountryCode"/>
            <field type="COMBO" valuehalign="">
               <label>Contact Template Field</label>
               <template>{{MailingStreet}}, {{MailingCity}}, {{MailingStateCode}} {{Mailing_Zip_Code_Lookup__r.Name}} {{MailingCountryCode}}</template>
            </field>
         </fields>
         <rowactions>
            <action type="edit"/>
            <action type="delete"/>
         </rowactions>
         <massactions usefirstitemasdefault="true">
            <action type="massupdate"/>
            <action type="massdelete"/>
         </massactions>
         <views>
            <view type="standard"/>
         </views>
      </skootable>
   </components>
   <resources>
      <labels/>
      <css/>
      <javascript/>
   </resources>
</skuidpage>

Comment

1 person likes this

5 years ago

Rob Hatch, Official Rep

44,968 Points

Thanks for the XML. In the org where we have state / country picklist values implemented I get the results I would expect and its hard to get a record to save with a bad state code. Would you mind showing me what the account detail page for Kennedy Health Alliance looks like? (with both the regular values and the state values) I'm still not convinced there isn't a mismatch in that record.

Comment

1 person likes this

5 years ago

Bill McCullough, Champion

13,602 Points

Rob...I created simple pages for the Account record--both a list view and detail view. They show the Account record with the correct data. Here are the screenshots:
Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192641/RackMultipart20150422-25690-12tg575-2015-04-22_17_46_12-salesforcecom_-_Enterprise_Edition_inlinepng1429739332

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192641/RackMultipart20150422-25690-12tg575-2015-04-22_17_46_12-salesforcecom_-_Enterprise_Edition_inlinepng1429739332

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192642/RackMultipart20150422-8391-146ahhv-2015-04-22_17_49_25-salesforcecom_-_Enterprise_Edition_inlinepng1429739392

I also did an SOQL query using Workbench. It shows the right StateCode and CountryCode for Kennedy Health Alliance.
Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192645/RackMultipart20150422-12892-1l0zs9b-2015-04-22_17_51_17-Workbench__SOQL_Query_inlinepng1429739496

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1192645/RackMultipart20150422-12892-1l0zs9b-2015-04-22_17_51_17-Workbench__SOQL_Query_inlinepng1429739496

Comment

2015-04-23T17:15:20+00:00

Bill McCullough, Champion

13,602 Points

Rob...I was able to reproduce the problem I am seeing in a Developer Org. where I just installed Skuid and just enabled the State and Country picklists. I used the same page that I sent to you in an earlier thread. In this screenshot, the State Province code should show as California.

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1193068/RackMultipart20150423-14569-fwa9ys-2015-04-23_13_11_05-salesforce.com_-_Developer_Edition_inline.png?1429809201

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1193068/RackMultipart20150423-14569-fwa9ys-2015-04-23_13_11_05-salesforce.com_-_Developer_Edition_inline.png?1429809201

2015-04-23T21:52:55+00:00

Rob Hatch, Official Rep

44,968 Points

Tomorrow I'll spin up a new Dev Org. The org I was in was a little old.... We'll keep trying to figure this out.

2015-08-12T14:24:06+00:00

Bill McCullough, Champion

13,602 Points

Rob...any update on this issue?

2016-03-02T10:54:26+00:00

Bill McCullough, Champion

13,602 Points

Rob,

We still have a problem with the State/Province code not showing the right value in Template fields. We were able to work around this issue with some of our users. We now have a situation where we can't use the work around.

Would you you look into this.

Thanks,

Bill

3 years ago

Karen Waldschmitt, Official Rep

9,082 Points

Hi Bill~

I believe the problem is actually stemming from how Salesforce handles the data. When you use the state/country picklist, the states are dependent on the country. When you change the country, your options for the states also change. Unfortunately, when there is a state in the new country that has the same state code, it will automatically change to that state. See my example below.

Here is the correct state info based on a country selection of the U.S.
Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1516358/13352-5xwldl_inline.png?1480452920

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1516358/13352-5xwldl_inline.png?1480452920

However, when I change the country to Italy, notice that 2 things happen.

The billing state gets overriden to None because there isn't a state in Italy that has TX as its state code.
The shipping state changed to Palermo because Palermo has the same state code as Pennsylvania.

Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1516359/12121-1y4mx5n_inline.png?1480452927

This faulty data, then, gets passed into your Skuid page as well. We will open up a case with Salesforce about this issue and let you know what we find out.

Hope this clarifies the problem.

Thanks!
Karen

Comment

2016-11-30T11:25:00+00:00

Bill McCullough, Champion

13,602 Points

Karen,

Thanks for looking into this. This does seem to be strange behavior in Salesforce.

I am not sure that this is the cause of the issue I see in Skuid. Here is a Skuid page from my developer org. that shows what I am seeing.

I have a list of Contact records and I am showing fields from the 'parent' Account record. I also added a drawer to show the data from the Account. You can see that the state and country are correctly set. The data in the table incorrectly shows the state as 'Cagliari' instead of 'California'. This seems more like a display issue for Skuid.

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1516623/RackMultipart20161130-92962-3abp2q-2016-11-30_06_16_42-Salesforce_-_Developer_Edition_inlinepng1480504921

Image https//d2r1vs3d9006apcloudfrontnet/s3_images/1516623/RackMultipart20161130-92962-3abp2q-2016-11-30_06_16_42-Salesforce_-_Developer_Edition_inlinepng1480504921

<skuidpage unsavedchangeswarning="yes" showsidebar="false" showheader="true" tabtooverride="Contact" personalizationmode="server"> <models>
<model id="Contact" limit="100" query="true" createrowifnonefound="false" sobject="Contact" adapter="salesforce" service="salesforce" type="">
<fields>
<field id="FirstName"/>
<field id="LastName"/>
<field id="CreatedDate"/>
<field id="MailingCity"/>
<field id="MailingCountryCode"/>
<field id="MailingStateCode"/>
<field id="MailingStreet"/>
<field id="AccountId"/>
<field id="Account.Name"/>
<field id="Account.ShippingCountryCode"/>
<field id="Account.ShippingStateCode"/>
<field id="Account.Id"/>
</fields>
<conditions/>
<actions/>
</model>
<model id="AccountDrawer" limit="20" query="false" createrowifnonefound="false" adapter="salesforce" service="salesforce" type="" sobject="Account">
<fields>
<field id="Name"/>
<field id="Id"/>
<field id="ShippingCountry"/>
<field id="ShippingCountryCode"/>
<field id="ShippingState"/>
<field id="ShippingStateCode"/>
<field id="ShippingStreet"/>
<field id="ShippingPostalCode"/>
<field id="ShippingCity"/>
</fields>
<conditions>
<condition type="fieldvalue" value="" enclosevalueinquotes="true" field="Id" state="filterableoff" inactive="true" name="AccountIdDrawer"/>
</conditions>
<actions/>
</model>
</models>
<components>
<pagetitle model="Contact" uniqueid="sk-2qqdCo-87">
<maintitle>
<template>{{Model.labelPlural}}</template>
</maintitle>
<subtitle>
<template>Home</template>
</subtitle>
<actions>
<action type="savecancel"/>
</actions>
</pagetitle>
<skootable showconditions="true" showsavecancel="false" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" createrecords="true" model="Contact" mode="read" uniqueid="sk-2qqdCo-88">
<fields>
<field id="FirstName" allowordering="true"/>
<field id="LastName" allowordering="true"/>
<field id="AccountId"/>
<field id="Account.ShippingStateCode" valuehalign="" type="">
<label>State Code from Account</label>
</field>
<field id="Account.ShippingCountryCode" valuehalign="" type="">
<label>Country Code from Account</label>
</field>
<field type="COMBO" valuehalign="">
<label>Account Address Template Field</label>
<template>{{Account.ShippingStateCode}} {{Account.ShippingCountryCode}}</template>
</field>
<field id="MailingStateCode" valuehalign="" type="">
<label>Contact State Code</label>
</field>
<field id="MailingCountryCode" valuehalign="" type="">
<label>Contact Cournry Code</label>
</field>
<field type="COMBO" valuehalign="">
<label>Contact Address Template Field</label>
<template>{{MailingStreet}}, {{MailingCity}}, {{MailingStateCode}} {{Mailing_Zip_Code_Lookup__r.Name}} {{MailingCountryCode}}</template>
</field>
</fields>
<rowactions>
<action type="edit"/>
<action type="delete"/>
<action type="drawer" label="Run multiple actions" icon="sk-icon-account-profile" openicon="fa-long-arrow-up">
<drawer title="Drawer Area" width="90%" closehandle="true">
<components>
<basicfieldeditor showheader="true" showsavecancel="true" showerrorsinline="true" model="AccountDrawer" buttonposition="" uniqueid="sk-2qxxd6-204" mode="read">
<columns>
<column width="50%">
<sections>
<section title="Section A" collapsible="no">
<fields>
<field id="Name" valuehalign="" type=""/>
<field id="ShippingCity"/>
<field id="ShippingCountry"/>
<field id="ShippingCountryCode"/>
<field id="ShippingState"/>
<field id="ShippingStateCode"/>
<field id="ShippingStreet"/>
<field id="ShippingPostalCode"/>
</fields>
</section>
</sections>
</column>
<column width="50%">
<sections>
<section title="Section B" collapsible="no">
<fields/>
</section>
</sections>
</column>
</columns>
<conditions/>
</basicfieldeditor>
</components>
<beforeload>
<action type="setCondition" model="AccountDrawer" condition="AccountIdDrawer" value="{{AccountId}}"/>
<action type="requeryModel" model="AccountDrawer" behavior="loadmore"/>
</beforeload>
</drawer>
</action>
</rowactions>
<massactions usefirstitemasdefault="true">
<action type="massupdate"/>
<action type="massdelete"/>
</massactions>
<views>
<view type="standard"/>
</views>
</skootable>
</components>
<resources>
<labels/>
<css/>
<javascript/>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuidpage>

2017-08-15T00:14:45+00:00

Paul

864 Points

Any feedback on this? Same problem here, looking up country code on parent account and getting the wrong interpretation, is correct in the db...

2017-08-15T02:22:21+00:00

Bill McCullough, Champion

13,602 Points

Paul,

I still see the problem in 10.0.4. If you show the CountryCode field from the parent account as a template field and use a triple mustache, you will get the 2 letter code for the country (i.e. {{{ShippingCountryCode}}}). If you need the country name, I'd suggest a Salesforce formula field.

Skuid,

Any update on this? Is it in the queue for a fix?

Thanks,

Bill

2017-12-04T22:35:53+00:00

Eulogio Gallo

1,906 Points

I just recently started experiencing this issue. Any news on this?