-
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
7 Qualities to Look for in a Salesforce Consulting Partner
Over the past few years, there has been a notable expansion in the Salesforce consulting partner network, which now encompasses individuals and global consulting agencies.…
Apex Replay Debugger - Salesforce Developer Guide
In this blog, we are going to discuss the apex replay debugger. Before starting the discussion about apex replay debugger let’s learn some basic knowledge…
Top Salesforce Consulting Company for Smart CPQ Growth Guide
In an era where customer expectations, pricing complexity, and sales velocity are constantly increasing, businesses need more than standard CRM support. They need expert guidance,…
Popular Salesforce Videos
Send WhatsApp and Save Chat using Lightning Component Salesforce | Salesforce Tutorials
In this video you will learn to send #WhatsApp using Lightning Component Salesforce. Also we will create a custom object to store the chat. Features…
Process Builder or Apex Triggers - Choosing Between Salesforce Automation Tools
The Salesforce Platform offers several means to operate in the background: Process Builder, Triggers, Flow, Workflows, and more. With so many robust options, it can…
Geocoding and Reverse Geocoding in Salesforce | Google Maps APIs
In this video, you will learn to use Geocoding and Reverse Geocoding service in your Salesforce Org. Geocoding is the process of taking input text,…