- August 10, 2018 at 2:23 pm #31488
What is difference in ISNULL and ISBLANK?
What is difference in ISNULL and ISBLANK?August 10, 2018 at 3:39 pm #31492
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.
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.
- This reply was modified 1 week, 3 days ago by Anurag algoworks.
Please Register to reply to this topic. /