Activity › Forums › Salesforce® Discussions › What is the Difference between isBlank and isNull in Salesforce?

  • MOHIT

    Member
    February 11, 2020 at 6:54 pm

    ISBLANK determines if an expression has a value then returns TRUE if it does not. If an expression contains a value, then this function returns FALSE.Whereas,
    ISNULL determines if an expression is null (blank) then returns TRUE if it is. If the expression contains a value, then this function returns FALSE.

  • Pooja

    Member
    February 12, 2020 at 2:22 pm

    The ISBLANK formula field returns a TRUE while the ISNULL does not. This is because, when a Text field is left EMPTY, it is internally assigned with an EMPTY STRING and hence it is not NULL. The technical meaning of NULL is that it is not assigned with a memory for storage. Since we need some memory for storing an EMPTY STRING, it is obviously not NULL.

    The ISBLANK returns a TRUE since the field does not carry anything(a value).

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .