Toggle Side Panel
Close search

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

  • Salesforce® Discussions

    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 5 years, 7 months 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.

  • 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