Activity Forums Salesforce® Discussions In Salesforce formula editor there are two functions ISBLANK() and ISNULL(). What is the difference in both?

  • In Salesforce formula editor there are two functions ISBLANK() and ISNULL(). What is the difference in both?

    Posted by Udit on February 5, 2020 at 6:30 pm

    In Salesforce formula editor there are two functions ISBLANK() and ISNULL(). What is the difference in both?

    Arun replied 4 years, 10 months ago 2 Members · 1 Reply
  • 1 Reply
  • Arun

    Member
    February 6, 2020 at 9:59 am

    Hi Udit,

    ISBLANK – If an expression has a value and returns true if it does not. If it contains a value, this function returns false. Text fields cannot be null. So use mainly for text fields.

    ISNULL – If an expression is null (blank) and returns true if it is. If it contains a value, this function returns false. Numeric fields cannot be blank. So use mainly for numeric fields.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos