-
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
How To Process Large Records in Salesforce Without Hitting the Governor Limits
Batch Classes: - Batch Apex is exposed as an interface that must be implemented by the Salesforce developer. Batch jobs can be programmatically invoked at…
How To Optimize Automated Tests and Securely Log in to Salesforce Without Verification Code or MFA?
Like in any software testing, automation testing of Salesforce solutions is a reliable approach to verify the functionality and integrity of the platform. Automated tests…
Formula Fields and Roll-up Summary Fields Usage in Salesforce
Here We are going to discuss “Formula Fields and Roll-Up Summary in Salesforce”. Let's talk beforehand about my blog. Formula field: We use Formula Fields…
Popular Salesforce Videos
Salesforce Training Videos - Discussion on Admin Concepts
A Salesforce Admin is a business leader, deeply knowledgeable about how their company operates, intertwined in making all departments successful through process automations, and thus,…
Develop a Basic Slack App For Salesforce
Build Slack Apps integrated with Salesforce. Use Heroku to host Slack apps built using Slack Bolt Framework and get connected to Salesforce using Node.js library…
Tableau CRM for Emergency Response Management | Salesforce
When disaster strikes, public and private health organizations, as well as government agencies, need to respond quickly and efficiently. Tableau CRM for Emergency Response Management…
