Banned or Censored Words

  • 0
  • 1
  • Question
  • Updated 1 year 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 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
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,438 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

  • 26,512 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
https://haversineconsulting.quickbase.com/db/bmxikq9bs?a=nwr

Pastie Databsase
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=589

Notes:

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

https://en.wikipedia.org/wiki/Metasyntactic_variable#Words_commonly_used_as_metasyntactic_variables

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

https://www.google.com/search?q=bad+word+list

(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 

https://www.youtube.com/watch?v=vbZhpf3sQxQ
(Edited)