-
What is the difference between ISBLANK() AND ISNULL() in salesforce?
What is the difference between ISBLANK() AND ISNULL() in salesforce?
-
2 Replies
-
Hi saurabh,
Text fields are never null, that means even if you didn't provide any value ISNULL() function takes empty as a value.
so using ISNULL() with a text field always returns false.
For example, the formula field==== IF(ISNULL(new__c) 1, 0) is always zero regardless of the value in the New field.For text fields, use the ISBLANK function instead.
IF(ISBLANK(new__c) 1, 0) true if if has a value
IF(ISBLANK(new__c) 1, 0) false if it don't have a valueThanks.
- [adinserter block='9']
-
Log In to reply.
Popular Salesforce Blogs
Understanding the Salesforce Data Import Tool
Introduction Salesforce is a powerful customer relationship management (CRM) platform that helps organizations streamline their sales, service, and marketing processes. One of the key aspects…
Understanding The True Potential of Salesforce Integration With SAP
Being one of the most popularly used customer relationship management (CRM) software in the market, Salesforce offers multitudes of functionalities towards managing critical business processes…
How to Hire a Salesforce Consulting Partner in India?
Hey there! When you are reading this, you must have come to realize that Salesforce is a business growth game changer. But to be truthful,…
Popular Salesforce Videos
Salesforce Spring 22 Release Dates and Preview!
Watch this video to learn about the Salesforce Spring 22 Release Dates and Preview. Timecodes 0:00 - Intro & Overview 1:32 - Spring 22 Release…
Salesforce Lightning Tutorial - How to Delete Records from Server
In this particular video you'll learn how to delete records from custom Salesforce Lightning Component using Apex Controller Method.
What is Salesforce in Simple Words | Who Can Learn Salesforce
What Exactly is Salesforce, Why is Salesforce CRM tool most demand in the IT market nowadays, Who can learn Salesforce course, what is the average…