Discussions

Expand all | Collapse all

Banned or Censored Words

  • 1.  Banned or Censored Words

    Posted 07-15-2017 00:32
    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.


  • 2.  RE: Banned or Censored Words

    Posted 07-15-2017 00:34
    How long is the list?


  • 3.  RE: Banned or Censored Words

    Posted 07-17-2017 16:55
    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.


  • 4.  RE: Banned or Censored Words

    Posted 07-15-2017 03:51
    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)


  • 5.  RE: Banned or Censored Words

    Posted 07-17-2017 16:56
    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.


  • 6.  RE: Banned or Censored Words

    Posted 07-17-2017 14:40
    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


  • 7.  RE: Banned or Censored Words

    Posted 04-10-2019 16:43
    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?