-
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
OAuth 2.0 Client Credentials Flow | Salesforce Developer Guide
OAuth 2.0 has a flow called Client Credentials that is useful when there are requests to APIs that don't involve the user. The client credentials…
9 Reasons Why Salesforce Is The Best CRM In 2021
Well, owing to the bulky data back in the past, there was a need for cloud computing. Additionally, the list of customer concerns, supporting them…
Don’t Neglect these Salesforce Application Development Considerations
Are you a Salesforce user and have the thought of building dynamic apps on the Salesforce platform? If yes, then you have come to the…
Popular Salesforce Videos
Salesforce Developer Career Path | How to Become Salesforce Developer
Watch this video to get a good idea about the Salesforce Developer Career Path. In this video you will learn how to become Salesforce Developer.…
Salesforce For Beginners - Introduction To Salesforce | Salesforce CRM Developement Tutorials
Contents for this Salesforce Training Video: 1:05 - Index 1:31 - What is CRM ? (Customer Relationship Management) 2:17 - What is Salesforce CRM? 3:18…
What is Salesforce Roles? Explain in Details
Salesforce Roles deals with the hierarchy of your organizations, So it will actually be based on the record level access and it can override the…
