I don't know why anyone created filters for "Starts with", but not "Ends Width". This is silly because a lot of typos commonly happen at the end and I could fix them if I could filter with "Ends With."
Never gonna happen that quickly (the idea exists elsewhere, too).
Add a formula field that's the email field followed by the standard end of line character $.
Of course this isn't going to find everyone in the EU. Hope your legal understands that!
Yes, I'm aware it won't find everyone and thank you for the suggestion. We are doing other things to identify them, however it is less than 1% of our list since our products only apply to the US market. I'm just doing my part.
Is this what you meant? (on the calculated field)
I meant on the CRM side and sync it to Marketo.
Oh, funny story there. That isn't an option for me due to how we "link" our CRM with Marketo... Any other ideas?
Yep, the same thing only with another email field and a trigger to Change Data Value to
whenever the primary Email Address changes.
Plus a batch to backfill.
Sorry, I need a bit longer of an explanation. Are you still talking about on the calculated field? I was contemplating making a token at this point with velocity script looking for ends with... although I don't know how to do that yet either. I just started searching
I'm not talking about a calculated/formula field here, just an additional custom field that you populate using Change Data Value.
Velocity won't be a help here as it only runs in the context of assembling emails.
A webhook would do the trick perfectly, of course (since it can do endsWith).
OK, trying that. Thank you.
why will it never happen, Sanford?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.