function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Riley SwartzRiley Swartz 

Help with Process Builder recognizing null values

Hello, I am having trouble with Process Builder being able to recognize null fileds. What I'm trying to do is have an email alert sent 14 days after the Invoice is received, if a PO number has not yet been assigned (no value in the PO Number field) - see pic below
User-added image
I have set the following conditions:
  • PO Number ISNULL Boolean True
  • Invoice Received equals yes
User-added image
However, when testing this process in Dev, it still sends email alerts even when I have assigned a PO Number to the issue. I only want it to do this is there is no PO Number. I have also tried a couple other conditions to recognize this, none of which I could get to work:
  • Is null > Boolean > false
  • Equals > GlobalConstant >$GlobalConstant.Null
  • Custom formula > PO Number__c = null
Additionally, when I do get an email alert, it sends two identical emails.

Any help would be greatly appreciated!
 
Jean Grey 10Jean Grey 10
Just a guess but it could be based on your settings of how blank values are treated (treat as blank or treat as 0). This option is selected when you first create the custom field. You could try testing in Sandbox with the two different settings and see if that helps.
JAYABALAJI TKM 1JAYABALAJI TKM 1
Hi Riley Swartz,

For me below thing is working fine.Better u check custom field creation is blank or 0.

Equals > GlobalConstant >$GlobalConstant.Null

Thanks 
Jayabalaji