How do I create a calculated field to show if something is null or empty? isNullOrEmpty.

If you need to create a calculated field or put a conditional setting on a field in a rich text editor, then you may want to use the isNullOrEmpty function.

For example, if you want to create a conditional block in the Key Facts widget to not display a data item, you might use an expression like the following:

isNullOrEmpty(workItem.proceedingDetails.courtCaseReference) <> true

Creating a calculated field for use in a matching rule

Matching rule functionality allows you to set:

if(isNullOrEmpty(form-hdm-contentious.hdm-matter-contentious.name)=false,'Set','')

Important: This function only applies to Strings. To use this function with a number, like a date, you must convert it to a string with toString().
E.g., to see if a date is older than 7 years:
if (isNullOrEmpty(keyDates.kd-initial-instructions-confirmed.taskDueDate.date.utc.value.toString()))
Then false
Else dateAdd('y', 7 , keyDates.kd-initial-instructions-confirmed.taskDueDate.date.utc.value) < now()

Related Articles