Visibility Rule for State/Province based on multiple Country entries

[mwmarketing]

Does anyone have an updated excel master list or shared file of a province list that Marketo accepts? My visibility workflow doesn't work. The Markeo docs don't have any free resource online for this. The old marketo rockstar guide links all seem to be removed now.

I'm trying to do something similar to the pictures in these threads below. When I select Canada on my form, the province form field doesn't populate my province keys.

https://nation.marketo.com/t5/product-discussions/visibility-rule-for-state-based-on-multiple-countr...

Select...|
AB|AB
BC|BC
MB|MB
NB|NB
NF|NF
NT|NT
NS|NS
NU|NU
ON|ON
PE|PE
QC|QC
SK|SK
YT|YT

https://nation.marketo.com/t5/product-discussions/country-and-state-province-fields-on-forms/td-p/12...

[Jo_Pitts1]

@mwmarketing,

I don't quite understand the question. 

Is it 'how do I set up visibility rules'?  This isn't a workflow, just form configuration.

If so, the common mistake that people make is that you need to have ALL potential options (for say Provinces in Canada and States in the USA) loaded into the field.  You then need to control which ones appear with the visibility rules based on the value in a different field.

It is a frustrating piece of double handling, but cest la vie.

[SanfordWhiteman]

What do you mean by “accepts”? Marketo will accept any value for State/Province.

Like Jo says, make sure the main list of options on the field is a superset of the options in all Visibility Rules (this applies to all Select fields w/VRs, doesn’t relate to state/province in particular).

[mwmarketing]

Thanks for the reply guys. Where is the superset located? 

Below is a screen capture of where I dumped all my provinces.

<a href="https://ibb.co/6YzdwdV"><img src="https://i.ibb.co/MnrXSXW/Country.png" alt="Country" border="0"></a>

[SanfordWhiteman · Accepted solution]

---

Thanks for the reply guys. Where is the superset located?

---

In the Values link of the field itself. Not under Visibility Rules. The main Values must contain every possible value across all VRs.

[mwmarketing]

That values section did the trick, thank you! I didn't realize we need to dump every possible choice in there from ALL countries states/provincial locals..

Frank_Bean in this thread had an excel sheet I will use to populate the remaining international labels on our forms. The master global locals are  still attached and linked in his original msg from 2016 if anyone wants to download it. Kind of hard to notice, but it's under the Tags  section of the forum message.

https://nation.marketo.com/t5/product-discussions/country-and-state-standardization/m-p/51843/highli...

[Jo_Pitts1]

Oh - And further to the technicalities, I'd hope your display values would be human readable (i.e. Alberta for AB).

Much better for accessibility if nothing else.