AnsweredAssumed Answered

Smart list filter to check alphabet used in a field value

Question asked by David Garrido on Sep 6, 2019

Hi Marketo folks,

 

We have a form in our Chinese website that can be filled in using any type of characters. However, one of the campaigns triggered upon form submission wants to check which alphabet was used in some of the fields of the form.

That's why we have created a filter logic that checks whether those fields contain any of the characters of the Latin alphabet.

 

4. Country is "China"
AND

5. "First name" contains a; b; c; ... ; z

AND

6. "Last name" contains a; b; c; ... ; z

AND

7. "Company name" contains a; b; c; ... ; z

...

 

And the filter logic looks like this:

(1 and 2 and 3) or (4 and 5 and 6 and 7 and 8 and 9 and 10)

The first part applies for all other countries except China, second Part applies only to China.

But there must be something wrong with the way the filters have been built or with the logic because my Chinese submissions filled using Latin alphabet do not qualify in the campaign. Do you know why? Do you have any other ideas for how to check the alphabet typed in certains fields of the form?

Thanks in advance for your help!

Attachments

Outcomes