Monday, November 5, 2018

Highlight Cases Created on Saved Searches during Weekdays

To highlight cases which are created on weekdays, follow the steps:

1. Create a Case Saved Search, List > Search > Saved Searches > New > Case.
2. Navigate to the Highlighting Tab and add Formula (text)
3. On the Formula field enter:

Case WHEN to_char({createddate},'D') between 2 AND 6 then 'T' END

4. On the Formula (Text) field Select the option is not empty.
5. Click Set.
6. Change the Background Color and Text as desired.
7. Click Save and Run.

No comments:

Post a Comment