Skip to main content

I’m currently building a CPQ solution on Spark v2 for a client who is planning to implement soon, and I’m experiencing issues with the country and state picklists…specifically on Contact Object with the MailingCountryCode and MailingStateCode fields.

When a Country is selected/changed, the dependent states do not render.

This is a bit of an immediate problem, because users won’t be able to update Mailing Address info until this is resolved.

Any ideas on a workaround until a fix can be released?

Conlan,


I have Spark v2 (12.0.4) loaded in my developer org.  I just added the MailingStateCode and MailingCountryCode field to a Contact detail page and it appears to be working.


Can you share your page XML?  I want to see if it works in my org.


Thanks,


Bill


<skuid__page unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" showheader="true" theme="Ink">
<models>
<model id="Contact" limit="1" query="true" createrowifnonefound="false" datasource="salesforce" sobject="Contact">
<fields>
<field id="Name"/>
<field id="MailingState"/>
<field id="MailingStateCode"/>
<field id="MailingCountryCode"/>
<field id="MailingCountry"/>
</fields>
<conditions/>
<actions/>
</model>
</models>
<components>
<skuid__form showErrorsInline="true" model="Contact" uniqueid="sk-1zh-79" mode="edit" showSaveCancel="true">
<sections>
<section title="Contact Info">
<rows>
<row uniqueid="sk-1zl-89">
<fields>
<skuid__field uniqueid="sk-1zl-84" id="Name"/>
</fields>
</row>
<row uniqueid="sk-1zl-92">
<fields>
<skuid__field uniqueid="sk-1zl-85" id="MailingStateCode"/>
</fields>
</row>
<row uniqueid="sk-1zl-95">
<fields>
<skuid__field uniqueid="sk-1zl-86" id="MailingCountryCode"/>
</fields>
</row>
</rows>
</section>
</sections>
<styles>
<spacing top="6" bottom="6" left="6" right="6"/>
</styles>
</skuid__form>
</components>
<resources>
<labels/>
<javascript/>
<css/>
<actionsequences uniqueid="sk-1zZ-72"/>
</resources>
<styles>
<styleitem type="background" bgtype="none"/>
</styles>
</skuid__page>

Thanks Bill, see XML above. Also see screencast of the issue I am experiencing here: http://recordit.co/wxZaKXERWF


Conlan,


I was able to replicate what you saw using your page XML.


I then tried recreating the page from scratch just to make sure that the XML was good.  I found that if the form is set to Read with Inline Edit, the State Code changes as you change the Country Code.  When the form starts in ‘Edit’ mode as you have in you sample page; however, the State Code never changes (what you reported).


This is definitely a bug for the Skuid team to fix.


Thanks,


Bill


Bill,


Thanks for identifying this. I was able to use this information to create a workaround using an action sequence on the model that “refreshes” the State Code picklist.


It’s still less than ideal, because I can’t make the State Code field required, and the form disappears and re-appears when the Country Code is updated.


Nonethless, I’m attaching the XML of my workaround in case anyone else needs this until Skuid releases a patch.


                      Contact            row.updated   MailingCountryCode               Contact                         Contact                                                            

Conlan,

Thanks for sharing your workaround.  Nice use of the action framework.

Best,

Bill


Reply