Monday, November 5, 2018

Highlight Cases Created on Saved Searches during Weekends

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

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') NOT 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