I want to look for certain text in addresses when I receive new orders in Shopify. I have a list of strings to look out for in google sheets, such as "SHS" or "Uni" in it. Then I could get the zap to email me. I know I could use many many filters but it would be a huge amount, because not only would I need a filter for every string, but a filter for every string for multiple address fields, such as company name, street address 1, street address 2. Then it would be useful to search within billing address also. I'm only thinking about maintenance of such a filter because more words would be added later on. If I could just look for these strings in each part of the address it would be easier to maintain. Hope that makes sense.
Best answer by AndrewJDavison_LuhhuView original