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". whic...
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
------------------------------
Laura_Thacker's avatar
Laura_Thacker
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
    ------------------------------