-
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
Learn All About Standard Controllers in Salesforce | The Developer Guide
The Visualforce controller is used to access visual markers associated with a specific link or button. These controllers can be used to provide access to…
Create Multiple Records of Salesforce Objects from a Single Page
Presently we can create records by click on tabs of their related objects but through the below-given piece of code, we can create records of…
Is Agentforce Commerce Right for Your Business? Benefits, Challenges & Business Fit
Choosing an e-commerce platform is not simply about comparing features. Businesses need to consider how well a platform fits their existing technology, customer journeys, operational…
Popular Salesforce Videos
What is Process Builder in Salesforce? Explained Distinctly
Process Builder Salesforce is an automated Salesforce tool which allow you to control the order of action. Watch this video and learn all about it,…
Salesforce Sales Cloud Implementation
There are many things to take into consideration when developing and deploying a Salesforce Sales Cloud implementation that will take your business to the next…
Apex Programming Tutorial for beginners : Data Types, Variables and Constants in Salesforce
Apex Programming Tutorial for beginners: Data Types, Variables and Constants in Salesforce.
