• #31488
    Forcetalks

    What is difference in ISNULL and ISBLANK?

    What is difference in ISNULL and ISBLANK?

    #31492
    Forcetalks

    Hi Chanchal,

    ISNULL:

    Determines if an expression is null (blank) and returns TRUE if it is. If it contains a value, this function returns FALSE.
    Text fields are never null, so using this function with a text field always returns false. For example, the formula field IF(ISNULL(new__c) 1, 0) is always zero regardless of the value in the New field. For text fields, use the ISBLANK function instead.

    ISBLANK:

    Determines if an expression has a value and returns TRUE if it does not. If it contains a value, this function returns FALSE.
    Use ISBLANK instead of ISNULL in new formulas. ISBLANK has the same functionality as ISNULL, but also supports text fields. Salesforce.com will continue to support ISNULL, so you do not need to change any existing formulas.

Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2018 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?