-
What is the difference between ISBLANK() AND ISNULL() in salesforce?
What is the difference between ISBLANK() AND ISNULL() in salesforce?
-
2 Replies
-
Hi saurabh,
Text fields are never null, that means even if you didn't provide any value ISNULL() function takes empty as a value.
so using ISNULL() 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.
IF(ISBLANK(new__c) 1, 0) true if if has a value
IF(ISBLANK(new__c) 1, 0) false if it don't have a valueThanks.
-
Log In to reply.
Popular Salesforce Blogs
Business Days in Salesforce CRM Analytics (Tableau CRM)
It's common for businesses to want to take business days into account when showing data on a dashboard in CRM Analytics (formerly Tableau CRM) to…
How to Integrate HubSpot With Salesforce CRM: Three Options
The goal of every business is to drive sales. However, its success is determined by the synergy of all departments, especially marketing and sales. 52.2%…
How to Customize Salesforce Login Page
Introduction Here we are going to learn about how to customize the domain name and login page. We will also understand how to change our…
Popular Salesforce Videos
Work.com – Release Readiness LIVE, Summer '20 | Salesforce
Work.com is an online set of applications, resources, and content designed to help the entire workplace get back to business after the Covid-19 crisis. This…
Marketing for Nonprofits Customer 360 Demo | Salesforce Video
Growing your nonprofit requires building relationships with lifelong supporters. Marketing Cloud for Nonprofits is a purpose-built marketing solution designed to help smaller nonprofits quickly and…
A day at Dreamforce Event!
Time to share with you all the Algoworks Experience at Dreamforce 2019. The fun at Dreamforce was unparalleled, come relish the Dreamforce week with us!…
