function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
WPCMSWPCMS 

What is the difference between ISNULL and ISBLANK?

I am not sure which function should be used between ISNULL and ISBLANK.

 

Can anyone describe this for me?

 

Thank you in advance.

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

As @Johan Liljegren said, the answer is right in the Online Help>

https://na2.salesforce.com/help/doc/user_ed.jsp?section=help&target=customize_functions.htm&loc=help&hash=ISNULL

 

 

All Answers

JohanLiljegrenJohanLiljegren

This is very well described in the Help & Training area. Simply search for isblank or isnull to find it.

 

To put it short, use ISBLANK(). =)
Steve :-/Steve :-/

As @Johan Liljegren said, the answer is right in the Online Help>

https://na2.salesforce.com/help/doc/user_ed.jsp?section=help&target=customize_functions.htm&loc=help&hash=ISNULL

 

 

This was selected as the best answer
vijayabakarareddy yarrabothulavijayabakarareddy yarrabothula
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 value