-
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
Understanding Workflow Rules in Salesforce | The Developer Guide
Work process in Salesforce is essentially a holder or business rationale motor that computerized certain activities dependent on specific rules. On the off chance that…
What is Salesforce Net Zero Cloud?
Barely a day goes by without there being something in the news about climate change, sustainability or carbon footprints. It is a major focus for…
Top 5 Feature Updates in Salesforce Spring ‘20 Release
Hello everyone and welcome to 2020! We hope you all enjoyed the holidays and had a nice new year! With a new year brings a…
Popular Salesforce Videos
Record Triggered Flows with Real Time Scenarios | Salesforce Tutorial
In this video, you will understand 1. What is Record triggered flow? 2. How and when to use Record triggered flows? 3. Real-time scenarios 4.…
How to Reference Custom Metadata Types to Optimize Salesforce Account Records Using Salesforce Flow
Salesforce Account Region Allocation using Custom Metadata Types and Salesforce Flow This video walks through an example of how you can reference Custom metadata Types…
Explain Standard Business Features of Salesforce?
Standard business features of Salesforce are Contact Management, Opportunity Management, Lead Management, Quote Management, Sales Management and Sales Forecasting. Watch the video to learn all…
