Skip to main content
Question

Color Coding

  • November 1, 2019
  • 0 replies
  • 45 views
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
------------------------------
This topic has been closed for replies.

AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Registered
  • November 1, 2019
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
------------------------------
Terms & ConditionsAccessibility statement