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 3 years, 8 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