Banned or Censored Words

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
Has anyone used a banned/censored word list? When users enter text in a free form text field, I want to compare the words against a banned/censored word list and then display a message and prevent saving of the record.
Photo of Mark Kastner

Mark Kastner

  • 90 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
How long is the list?
Photo of Mark Kastner

Mark Kastner

  • 90 Points 75 badge 2x thumb
For now it's about 20 words.  I don't imagine it growing to more than 50.  This isn't for profanity, rather it is to prevent people from including some identifiable information in a record.
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
You can have a formula-checkbox automatically check itself if the text field 'contains' one of the banned words.  

Then the form rule would kick in when the checkbox was activated.

The formula for the checkbox could be something like

If(Contains([Text Box], "Poop")
OR Contains([Text Box] "Fart"),
OR etc... ,
 true, false)
Photo of Mark Kastner

Mark Kastner

  • 90 Points 75 badge 2x thumb
Do you have a suggestion on how I can get the formula to refer to a list instead of including each word in the formula?  I will have up to 50 words.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
See this example:

Banned Words ~ Add New Record
BANNED WORDS: foo, bar, baz, qux, quux, quuz, corge, grault, garply, waldo, fred, plugh, xyzzy

Pastie Databsase


(1) To keep it safe for the office I used a metasyntatical set of words:

(2) There are all sorts of predefined bad words list you can find on the internet with a Google search

(3) You list of bad words could be stored in a table or code page and accessed by the script using an AJAX call

(4) To keep it unsafe for the office here is a link to George Carlin's famous  - 7 dirty words
Photo of Christine


  • 130 Points 100 badge 2x thumb
In the example above, it looks like once you enter "foo", the word is blocked so that if you wanted to type foot or food, you couldn't. Is there a way to scrub a field against a list of words when a part of a phrase contains an exact match to a banned word? So if my banned word is "odd" the name "Todd" would still go through? Or the word "personal" is banned but "personalization" would go through?