-
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
Which Steps To Follow to Level up your Salesforce DevOps Maturity?
It is high-time that tech companies transform themselves digitally. This can be done only when companies adopt leading cloud platforms that are present in the…
AI, Sustainability, and Innovation: Highlights from Dreamforce 2023
Dreamforce 2023 Key Takeaways Dreamforce 2023 was the largest and most successful Dreamforce yet, with over 180,000 attendees from all over the world. The conference…
Customer Loyalty Is Crucial For Businesses Implementing CRM Solutions - Can your Customers Serve Them?
In the highly connected digital age today, customers are constantly on the lookout for instant solutions for their basic problems. These are spur-of-the-moment attempts of…
Popular Salesforce Videos
Salesforce Lightning Process Builder: Lightning Process Builder Basics
The Salesforce Lightning Process Builder is a new workflow tool that helps anyone in your company quickly and easily automate business processes such as employee…
Data Loader In Salesforce | Import or Export Data From Salesforce
How to import or export data using Data Loader in Salesforce. This video will cover the following points - 1. Introduction to Data Loader (0:16)…
4 Key Highlights From the Dreamforce Keynote Event
Let's straightaway take a jump on the announcements – from Hyperforce, Einstein Automate, Service Cloud Workforce, and huge acquisitions – presenting you a summary of…