-
What is the Difference between isBlank and isNull in Salesforce?
What is the Difference between isBlank and isNull in Salesforce?
-
2 Replies
-
ISBLANK determines if an expression has a value then returns TRUE if it does not. If an expression contains a value, then this function returns FALSE.Whereas,
ISNULL determines if an expression is null (blank) then returns TRUE if it is. If the expression contains a value, then this function returns FALSE. -
The ISBLANK formula field returns a TRUE while the ISNULL does not. This is because, when a Text field is left EMPTY, it is internally assigned with an EMPTY STRING and hence it is not NULL. The technical meaning of NULL is that it is not assigned with a memory for storage. Since we need some memory for storing an EMPTY STRING, it is obviously not NULL.
The ISBLANK returns a TRUE since the field does not carry anything(a value).
Log In to reply.
Popular Salesforce Blogs
How File Sync and Share Can Help You Stay Organized? | Salesforce Sales Cloud
Are you tired of wasting time searching for files on your computer? If you’re like most people, you probably have several folders spread out across…
Salesforce Marketing Cloud Content Builder Can Help You Succeed
Salesforce Marketing Cloud is a robust marketing automation platform that enables firms to drive their marketing activities and convert leads into sales. The Content Builder,…
The Only Guide You Will Ever Need for Customer Self-service | Salesforce Guide
What makes the customer experience great? How well do you interact with your customers? The empathy that you show toward them Timely response to their…
Popular Salesforce Videos
Generative AI: What Diverse Data Types Can It Create? | Salesforce
Imagine a technology that can take various types of data – from text and images to music and even beyond – and create something entirely…
Why are Salesforce Releases Named After Seasons?
If you are wondering “Why are Salesforce releases named after Northern Hemisphere Seasons?” then get an expert answer by Megan Peterson and Salesforce Co-Founder Parker…
Unfolding Code Builder | Salesforce Development Tutorial
Working with Salesforce Development has been a challenge especially when we are working with Lightning Web Component. As we have to install the VS code…
