-
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.
-
Log In to reply.
Popular Salesforce Blogs
How to do Salesforce Customization Right?
When it comes to serving potential customers while balancing the sales of the business, Salesforce has unlocked countless opportunities for us to get involved. It…
DML Operations in Apex: All You Need to Know
In this Blog, we will study DML Operations in Apex. DML is used to insert, update, delete and undelete records. We can use upsert to…
The All-New Salesforce Service Cloud - Transforming Customer Service from Anywhere
Salesforce launched the next generation of Service Cloud, to support evolving customer service standards and deliver linked, personalized service from anywhere on a single digital…
Popular Salesforce Videos
Salesforce Einstein Search
Salesforce Einstein Search makes your users more productive by bringing the power of Einstein and AI to Salesforce Search. Einstein Search is Personal, Natural, and…
SALESFORCE LIGHTS: The Crown above San Francisco
Visible by more than 20 miles away, Jim Campbell's massive LED art installation on the crown of the Salesforce Tower premiered last week. Situated above…
Relationships in Salesforce | Why Relationships are Created?
In this video, Salesforce Rangers goes into detail about what relationships are in Salesforce and why they are necessary in the first place. This is…
