SOLVED

Visibility Rule for State/Province based on multiple Country entries

Go to solution
mwmarketing
Level 2

Visibility Rule for State/Province based on multiple Country entries

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...

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Visibility Rule for State/Province based on multiple Country entries


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.

View solution in original post

6 REPLIES 6
Jo_Pitts1
Level 10 - Community Advisor

Re: Visibility Rule for State/Province based on multiple Country entries

@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
Level 10 - Community Moderator

Re: Visibility Rule for State/Province based on multiple Country entries

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
Level 2

Re: Visibility Rule for State/Province based on multiple Country entries

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
Level 10 - Community Moderator

Re: Visibility Rule for State/Province based on multiple Country entries


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
Level 2

Re: Visibility Rule for State/Province based on multiple Country entries

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
Level 10 - Community Advisor

Re: Visibility Rule for State/Province based on multiple Country entries

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.