If Zip key matches then filter for zip key

How To
1

GOAL:

  1. Google sheet searches rows for matching ZIP KEY, a zip key is the first 2 digits of a zipcode.
  2. As of now I filter for if ZIP KEY text match contains the ZIP KEY, BUT it does not work as a good filter for mutiple numbers.
  3. Zip keys are a users service area which would look like (45, 41, 43)
  4. If the location zip key matches any of the 3 for example then it will filter users for that key.
  5. The main issue I am finding is that if a zip key contains a (4) then it will send emails to all 4s regardless of the second digit 45, 41, 43. I need it to filter for both digits if it is contained in the zip key.

image

image

image
image148×658 4.44 KB

2

Welcome to the Make community!

You can try a filter like this

Zip Keys (O)
Text operators: Matches Pattern
/\b{{1.ZIPKEY}}\b/

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like
3

This did not work. I don’t thing this worked. I tested it and it returned no values.

4

You might have to provide a link to your sheets so we can perform more testing.

1 Like
5

Hi @Brandon2

Please go to the history of your execution. Go to filter and just mouse hover over the failed filter and share screenshots to understand the values passed.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel