Forum Discussion

JoshuaCrunelle's avatar
JoshuaCrunelle
Qrew Member
6 years ago

Color Coding

Does anyone have a formula for highlighting a list of words that should not be in a specific field? For example: when a staff member is typing in comments about a day and use the word "agitated". which is not to be used in comments. How do I get the word "agitated" to be highlighted so when I'm browsing the comments it's easy to spot.

------------------------------
Joshua Crunelle
------------------------------
Formulas and functions
reports and charts
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    You could create a formula text field and use the Contains() function in an If() statement to return "agitated" if the filed contains the word agitated. Then you can make a table report filtered to only show records that return the word "agitated." You can do color coding of a field, but not a single word without custom coding.

    Example:
    If(
Contains([specific field],"agitated")=true,"agitated",
""
)​

    Result:

    Report filter:

    Report:

    ------------------------------
    Adam Keever
    ------------------------------
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      6 years ago
      Using a formula; and if you have a long list of "inappropriate" words; you might want to build a List() formula - you can then use a form rule to abort the save when the formula contains an output.  The visual on screen will notify the User they have used inappropriate words; but the form rule will prevent them from ignoring it.

      ------------------------------
      Laura Thacker (IDS)
      laura@intelligentdbs.com
      (626) 771 0454
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        6 years ago
        Great suggestion Laura. You could also use the recently added data rules function in the table advanced settings to achieve the same ends:


        ------------------------------
        Adam Keever
        ------------------------------