Scenario Overview

In this scenario the business requirement is to prevent notes being changed or updated on a Case after it has been closed. New notes can be added, but old notes cannot be updated.

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • Formula of type 'Validation' is created on the Note entity
  • Event is set to 'Update' (formula will only trigger on updates, not on newly created notes)
  • Source Property is set to 'All Properties'

Note: You can find the Case Status Reason Codes via the Source Tab. Expand Related (N:1) for Incident  and select Attributes and then Status Reason. In this example we will prevent changes to the notes if the Case is marked as either Cancelled, Problem Solved or Information Provided.

N52 Formula Manager Steps

The following set of steps outline how to create this Formula

  • Create a formula of type 'Validationon the Notes entity
  • Set the Source Properties as 'All Properties'
  • Copy and paste the formula below into the formula canvas
  • Save and test!

Error Message being shown to user when they try and update a note.


If([annotation.objecttypecode] = 'incident' and In([annotation.objectid.statuscode.?],  6, 1000, 5),
  ThrowError('This Case is closed - you must reopen it before attempting to update any notes!'),

Wizard - ThrowError

Please see below the wizard you can use to create the ThrowError() function call used in this formula. 

Note you will need to either type or paste in the following.

 This Case is closed - you must reopen it before attempting to update any notes!