Skip to main content
Question

Banned or Censored Words

  • July 15, 2017
  • 0 replies
  • 76 views
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.
    This topic has been closed for replies.

    How long is the list?
    • MCFNeil
    • Quickbase Alumni
    • July 15, 2017
    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)
    • anomDiebolt
    • Quickbase Alumni
    • July 17, 2017
    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
    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?
    Terms & ConditionsAccessibility statement