Wednesday, September 26, 2018

Highlight Field Column in a Saved Search Result

1. Navigate to Reports> Saved Searches> All Saved Searches> Edit a saved search.
2. Choose Formula (Text) under the Results subtab's field column.
3. Type the sample HTML code below under the Formula column:
'<td bgcolor="#333399"><font size="1">'||{assigned}||'</font></td>'
4. Type a single space under Custom Label column.
5. Under the Results subtab's field column that will show the highlight, choose Formula (Text).
6. Type a label under Custom Label column.
7. Hit Save.
8. View the saved search results.

Note: A single character missed can cause the result to display ERROR: Invalid Expression. Take note of the beginning and ending single quote (') and the format for '||{assigned}||'. The {assigned} is the Field id of 'Assigned to' field in the case record. The "#333399" is the hex color equivalent of Primary blue (column background). Make sure to end your <TD> tags properly. The highlighted column result is displayed in the second Formula (Text) field created.

 



No comments:

Post a Comment