Activity Forums Salesforce® Discussions What is the difference between the ISBLANK() and ISNULL () in Salesforce?

  • What is the difference between the ISBLANK() and ISNULL () in Salesforce?

    Posted by MOHIT on August 11, 2020 at 1:28 PM

    What is the difference between the ISBLANK() and ISNULL () in Salesforce?

    Manish replied 6 years ago 4 Members · 3 Replies
  • 3 Replies
  • Anjali

    Member
    August 11, 2020 at 1:28 PM

    Both determines if an expression has a value and returns TRUE if it does not. If it contains a value. this function returns FALSE.

    • ISBLANK(expression) : The expression allows both number and text fields
    • ISNULL(expression): Here the expression allows only number fields.
  • [adinserter block='9']
  • Kirandeep

    Member
    August 11, 2020 at 1:52 PM

    ISBLANK() has the same functionality as ISNULL(), but also supports text fields. Salesforce will continue to support ISNULL, so you do not need to change any existing formulas. ISNULL(): Text fields are never null, so using ISNULL() with a text field always returns false.

  • Manish

    Member
    August 11, 2020 at 3:44 PM

    ISBLANK() has the same functionality as ISNULL(), but also supports text fields. Salesforce will continue to support ISNULL, so you do not need to change any existing formulas. ISNULL(): Text fields are never null, so using ISNULL() with a text field always returns false.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Salesforce Admin Certification 2020 Questions Explained with References - Part II

Video in

How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam Questions Salesforce Administrator Certification Exam…