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...
Forum Discussion
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
------------------------------
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
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
------------------------------
------------------------------
Adam Keever
------------------------------
