-
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
User Agent Flow in Salesforce | The Developer Guide
User Agent Flow (Mobile App Integration) A simple flow for clients that don't need to include global secrets (such as distributed apps) but can be…
Instantly Deploy Free COVID-19 Care Response Solution with Global Salesforce Implementation Partner
World leaders and global health care providers are overwhelmed with inbound calls and an amplified number of cases they are receiving each day affected by…
QRCode with LWC in Salesforce
Hello Geeks, I was working on the generation of QRCode in LWC which is the new feature of Salesforce from the Spring '19 release. We…
Popular Salesforce Videos
How can Salesforce Field Service Help in Providing a Better Customer Experience?
Salesforce Field Service Management automates and optimizes the work of field service workers (agents, dispatchers, mobile technicians). It is part of the Service Cloud and…
Methods in Salesforce - All You Need to Know
Learn All About Methods in Salesforce. Watch this video and do let us know if you have any doubts or concerns. What is a Method…
Salesforce Security Review | Tutorial Video
If you ever wanted to publish an app, you probably know of the Salesforce security review. While dreaded by many developers, it is far from…
