I recently helped a customer solve a problem and figured I’d share it with the rest of the community. They had some validation scripts that prevented the workflow from progressing for certain criteria (in this case, if a check box was selected on the item details page). To help give their end users a visual indicator of this, they wanted an alert to appear in red if the check box is selected. This can easily be accomplished using a Computed Field.
Pretty simple – if a check box is checked, display some text to alert the end user any time they navigate to the record (bonus! Did a bit of HTML formatting to make it stand out).
Field set up:
Here’s what’s in the Computed Field Formula:
WHEN (CAST(CHECK_BOX as CHAR) = 't')
THEN '<b><font color="red">Project is on hold, No Workflow transitions allowed!</font></b>'
Note – after the ELSE, that’s two single quotes, not a double quote to denote no value.
And what it looks like on the front end:
If the check box is unchecked, no alert: