Visibility Rule for State based on multiple Country entries

[Amanda_Thomas6]

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

Picture 2

[Anonymous]

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

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

[Amanda_Thomas6]

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.

[Anonymous · Accepted solution]

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.

[Amanda_Thomas6]

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?

[Anonymous]

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"

[Amanda_Thomas6]

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.

[Anonymous]

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

[Josh_Hill13]

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.

[Anonymous]

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