Salesforce
Spam and Web-to-Lead Forms
Stem the tide of Cialis, Viagra, Phentermine and Online Casino leads. This requires using Validation Rules (click "Setup" then "Customize" then "Validation Rules" (under "Leads")). Click New to create a new validation rule, and then enter in your rule. Here's ours:
AND(
ISPICKVAL( ourfieldname , "ourwebtoleadfieldvalue"),
OR(
CONTAINS( Description , "mortgage") ,
CONTAINS( Description , "diploma") ,
CONTAINS( Description , "auto loan"),
CONTAINS( Description , "viagra"),
CONTAINS( Description , "levitra"),
CONTAINS( Description , "cialis"),
CONTAINS( Description , "phentermine"),
CONTAINS( Description , "href"),
CONTAINS( Description , "[URL=")
))
Here's how it works: In a field that identifies the lead as created by Web to Lead ("ourfieldname" and "ourwebtoleadfieldvalue"), it looks for any of the text in the description fields that matches the strings in quotes. In addition to the popular pills, I threw in strings that don't get submitted in valid leads but are almost always included in spam submissions: hyperlinks (formatted in either HTML or in popular bulletin board markup, [URL=]). When a lead matches this rule, it effectively aborts the lead creation process and triggers an alert message to the default lead owner. The designated default owner can have a rule in Email that traps the alert message and throws it away.