Workflow Rule to check for null lookup

Question

I'm trying to write a very simple workflow where if the Case Contact is NULL do some action.

In my Rule Criteria, I've tried:

isNull( ContactId )

However, this doesn't seem to trigger the workflow.

|WF_FORMULA|Formula:ENCODED:[treatNullAsNull]isNull( {!ID:Contact} )|Values:ContactId=null
|WF_CRITERIA_END|false

What is the correct way to do this check?

Worst case you could pull the Id into a formula and evaluate that. Hopefully someone will have a better suggestion. — Adrian Larson, Commented Dec 14, 2015 at 20:38

Brian Mansfield · Accepted Answer · 2015-12-14 20:39:37Z

5

I tested with ISBLANK(ContactId) and it seems to work:

answered Dec 14, 2015 at 20:39

Brian Mansfield

6,4415 gold badges37 silver badges69 bronze badges

I had tried that earlier and I thought it didn't work, but I must have been doing something to prevent the workflow from firing. Looks like if you just edit and save the workflow without changing the contact field, it doesn't fire it again.
– NSjonas
Commented Dec 14, 2015 at 20:42

Add a comment |

1 Answer 1