How can I filter out leads that only have one letter in else their job title or company name | Community
Skip to main content
February 26, 2014
Question

How can I filter out leads that only have one letter in else their job title or company name

  • February 26, 2014
  • 2 replies
  • 845 views
Essentially we have people appearing in our leads that have filled in one letter in each field in a form.

How can I stop this in the form ?
or
How can I exclude them after the fact - what filters do I need to do this.
or
Is it possible to delete these leads automatically so they don't appear.

Thanks in advance for your ideas.

Cheers
KC
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

February 26, 2014
Sure, create a list of single characters. a, b, c, ...., z, !, @, etc. 

Use that list in a workflow that looks to see if certain fields match exactly one of the items in the list. If they do match you could delete them in a workflow step. '

Hope that helps! 

- Jeff
February 27, 2014
Great - simple solution. 

I have added this list to my exclusion list.  I haven't gone as far as the deletion step.

Thanks for your help.

Cheers
KC