-
Is there any method through which we can count if a particular field has some value or not?
Hi All,
Is there any method through which we can count if a particular field has some value or not?
For eg. In an account, if a particular field has some value, count the filled records.
Thanks.
-
1 Reply
-
Hi Pranav,
You can do this by Applying Soql query on it
Eg If you want to check how many contact are present on the account. The Soql is : -
SELECT COUNT() FROM Contact where AccountId!=Null.
And if you want to check that particular contact on account contain particular field or not then you can apply this query:-
SELECT COUNT() FROM Contact where AccountId!=null AND FieldName != null
Log In to reply.
Popular Salesforce Blogs
How Salesforce CRM Can Enhance a Business?
Salesforce is among the most trendiest and trustworthy CRM solutions in the present era. We may have had heard about how young entrepreneurs make the…
Sort Picklist Values in Lightning Component | Salesforce Tutorials
In this article, you will learn to sort the values in Picklist in Lightning Component. You just have to add an additional line to your…
What is a Salesforce AppExchange App - Here's All You Need to Know
A marketplace called AppExchange provides products including software, parts, and consulting services. Salesforce AppExchange App is a platform that mainly improves a company's business process.…
Popular Salesforce Videos
What is Salesforce | Salesforce Training Videos For Beginners | Salesforce Tutorial
This Salesforce Training Video will help you an introduction to Salesforce Administrator and Platform App Builder Certification Training course offered by Simplilearn. By end of…
How to Reference Custom Metadata Types to Optimize Salesforce Account Records Using Salesforce Flow
Salesforce Account Region Allocation using Custom Metadata Types and Salesforce Flow This video walks through an example of how you can reference Custom metadata Types…
Salesforce Financial Services Cloud Implementation Guide
You’ve decided to use Salesforce Financial Services Cloud but where do you begin? How can you utilize Salesforce to track all your customer interactions and…
