SOLVED

Visibility Rule for State based on multiple Country entries

Go to solution
Highlighted
Level 6 - Champion

Visibility Rule for State based on multiple Country entries

I am looking to hide the state field if country does not contain US, United States, or America. I noticed there is no plus button to add options for the If not contains field. So, I listed them "If [countryt] [not contains] [US, United States, America]". Picture 1. That didn't work, as in when I typed America in the Country field the State field didn't show up.

Then I tried to add more rule options (multiple "If" statements). Picture 2. That didn't work either. Again, I typed America in the Country field the State field didn't show up. Any advice?

Picture 1

pastedImage_2.png

Picture 2

pastedImage_1.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

I highly recommend using a picklist for Country standardization. Just put your most common countries at the top of the list for easy access. You should be able to get a list of country values from your CRM admin.

View solution in original post

16 REPLIES 16
Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

Have you tried just showing the State field when Country is United States:

pastedImage_0.png

This way State/Province only shows on your form when that Country is selected.

Highlighted
Level 6 - Champion

Re: Visibility Rule for State based on multiple Country entries

Hi Emily,

Thanks for your reply! I have done that and it works. It's just that this field is an open field as to not have to list every country in a drop down. So, people could input US and United States of America, instead of just United States. So, the is option just won't work.

Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

I highly recommend using a picklist for Country standardization. Just put your most common countries at the top of the list for easy access. You should be able to get a list of country values from your CRM admin.

View solution in original post

Highlighted
Level 6 - Champion

Re: Visibility Rule for State based on multiple Country entries

Hi Emily,

Good idea. So, do you know if you can or can not list options for the "not contains" or "contains" filters in the visibility rules?

Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

You absolutely can. But if you want State to only show up on the form when Country contains US, United States you need to use "Show" instead of "Hide"

pastedImage_0.png

Highlighted
Level 6 - Champion

Re: Visibility Rule for State based on multiple Country entries

I think it's listing different values with a comma that is the problem. For some reason it's only recognizing the first option.   I have it listed exactly "US, United States". When I enter United States in the form, the State field does not show, but when I enter "US", the state field does show.

pastedImage_0.png

Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

Yeah, it looks like that'll be a downside of the "contains" operator.

Highlighted
Level 10 - Champion Alumni

Re: Visibility Rule for State based on multiple Country entries

You need to use a semi-colon

But also, you should use IS, not CONTAINS here. And you will need to list all the State options in the State field first.

As Emily said, use a picklist instead. There is a list on docs.marketo.com and on my site if you look for ISO Country List.


DO NOT let people type whatever, because they will and it will break your Ux and database workflows.

Highlighted
Anonymous
Not applicable

Re: Visibility Rule for State based on multiple Country entries

where do you find the standardized list of provinces for Canada?  How do I determine if these are being pulled from our Salesforce values?