-
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
Where to Learn Salesforce Admin Training Online?
To start anything, maybe from scratch or to attain an advanced level of knowledge, it is important to know various resources that can help you…
Integrate Salesforce with AI to Increase Efficiency and Improving Customer Experience
Transform sales and customer services with AI: Salesforce Integrates Generative AI Improves Automation, Personalization & Predictive Analytics to Boost Enterprise Success In the increasingly competitive…
Salesforce Ecosystem, A Successful Philosophy
Since its inception, Salesforce has built its own success on the success of its customers. To ensure this, over the years, it has developed a…
Popular Salesforce Videos
Salesforce Apex Class | Salesforce Development | SFDC Development
This video covers how to create an Apex Class in Salesforce and Execute the Apex Class. Do let us know in the comment section if…
What are lookup filters in Salesforce?
In this video, we will leaarn about Lookup Filters in Salesforce by dividing this topic into 4 basic points, which are: 1. What is a…
Salesforce Tutorial - Creating Custom Object
Many times, New Salesforce Developers don’t understand from where to start it. In this video, I have shown the way exactly to create a Custom…
