-
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 Build a Basic Salesforce REST API Integration
Being within the package as a Service house, you have got to admire what Salesforce has managed to accomplish. It might be exhausting to argue…
Flows in Salesforce - Some Expert Tips to Take On
Here mention some tips on flows which is very useful for everyone to start working on Flows and also mention some use cases to practice…
Generate QR Code for any Salesforce Object in 5 Min
What is a QR Code? So you may have heard that QR Codes are set to become the 'next big thing' but thinking to yourself,…
Popular Salesforce Videos
Salesforce For Beginners - Create Lookup , Master-Detail Relationship and Rollup Summary
Salesforce Administration tutorial which demonstrates how to create Lookup Relationship, Master-Detail Relationship and Rollups . Things to be learned from the video : How to…
Salesforce Security – An Encryption Guide For The Paranoid
If you are using Salesforce, you would be having a lot of data stored in Salesforce objects. Some of it would even be sensitive enough…
Salesforce Partner Program 2020: Everything You Need to Know!
Embarking on this new program year, PY21, Salesforce will be implementing some enhancements to its Partner program to ensure the central focus on customer success…