-
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
Things to Consider Before Choosing CDP Implementation Partner
Are you looking for a Salesforce CDP integration and implementation services provider and don’t know how to choose the right CDP for your business, then…
The Salesforce Economy - What Does It mean for Your Business?
❛ What’s happening at Salesforce isn’t just about Salesforce ❜ Twistellar has been working with Salesforce technologies for more than 5 years. We've seen businesses…
How to Update the Values of a Custom Picklist Field using Metadata API?
The user can easily add, delete, or update the values of a custom picklist field manually. But there are times when you have to update and…
Popular Salesforce Videos
Google Chrome Extensions for Salesforce
In this video we are going to learn about the various Google chrome extensions which can be useful while we are working inside the Salesforce…
Build an Experience with Salesforce Community Cloud: 4 Steps
Follow 4 fast steps to building a digital experience. Watch to learn how you can make CRM part of the way you deliver sites, forums,…
Discover Lightning Web Components | Salesforce Tutorial
Watch this Salesforce tutorial. After completing this unit, you’ll be able to: Explain the Lightning Web Components programming model. List the benefits of using Lightning…
