SOLVED

Re: Visibility Rule for State based on multiple Country entries

Go to solution
Amanda_Thomas6
Level 9

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

Amanda_Thomas6
Level 9

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.

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.

Amanda_Thomas6
Level 9

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?

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

Amanda_Thomas6
Level 9

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

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.

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

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?