You need to sign in to do that
Don't have an account?
Forcedotcom737
Solution to highlight text in call notes based on a list of words?
Any ideas on a SFDC.com based native solution (not buying third pary app's) that can scan call records / notes and identify keywords (based on a word list) in the call records. The solutions goal is to identify inappropriate words in call notes (e.g the word bribe).
Possible Solution (Need help with solving point 4 or open to completely new ideas):
1. Create a table / List / object with the word list that needs to be scanned (e.g the word 'bribe' would be in that list)
2. Export existing call record data into a database and perform a SQL join with 'word list' to identify calls with the word bribe (this will be a monthly process)
3. Load the suspect calls back into SFDC for examination by say managers / auditors etc
4. Is there a way to highlight the words that were picked up by the SQL process in the call notes that were identified as suspect. Perhaps a SFDC formatting class that maybe available. This is the part that I dont have an initial solution for. The goal is to make it easier for a manager to know which word caused the call note to be flagged without having to manually scan for words in the call note.
Also although this is not ideal are you aware of any third party solutions that can do this?
Possible Solution (Need help with solving point 4 or open to completely new ideas):
1. Create a table / List / object with the word list that needs to be scanned (e.g the word 'bribe' would be in that list)
2. Export existing call record data into a database and perform a SQL join with 'word list' to identify calls with the word bribe (this will be a monthly process)
3. Load the suspect calls back into SFDC for examination by say managers / auditors etc
4. Is there a way to highlight the words that were picked up by the SQL process in the call notes that were identified as suspect. Perhaps a SFDC formatting class that maybe available. This is the part that I dont have an initial solution for. The goal is to make it easier for a manager to know which word caused the call note to be flagged without having to manually scan for words in the call note.
Also although this is not ideal are you aware of any third party solutions that can do this?
Create a custom setting (list type) with the Name and a custom field of "wrapper",
Populate the custom setting with data like:
Name: "bribe"
Wrapper: '<SPAN STYLE="background-color: #ffffcc">bribe</SPAN>'
Create a custom visualforce extension / page for displaying the call notes, and use something similar to this snippet of code to replace every instance of a word in the custom setting with it's wrapper value.
(Warning, I just spit that out off the top of my head, there may be syntax errors.)
All Answers
Create a custom setting (list type) with the Name and a custom field of "wrapper",
Populate the custom setting with data like:
Name: "bribe"
Wrapper: '<SPAN STYLE="background-color: #ffffcc">bribe</SPAN>'
Create a custom visualforce extension / page for displaying the call notes, and use something similar to this snippet of code to replace every instance of a word in the custom setting with it's wrapper value.
(Warning, I just spit that out off the top of my head, there may be syntax errors.)