-
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
Bric API - Business card scanner API
Pass card images and get accurate results in JSON. Most CRM / ERP software requires inputting customer/vendor details into the software and a major source…
Salesforce Implementation Strategy in 2022 - An A to Z Guide
A go-to-market plan is critical for a company's growth amid difficult times. With Salesforce being such an important part of the strategy, it's critical to…
Salesforce Sales Cloud: Implementation and Adjusting, Customization
What to do if you implement a costly CRM, and find out it cannot cover all your business processes? If you are a business owner…
Popular Salesforce Videos
Salesforce Stock CRM Huge News!
Why is Salesforce Stock CRM Stock going UP? Is Salesforce stock a buy? Should I buy CRM Stock? Is Salesforce stock a good investment? In…
Salesforce CPQ from Scratch
CPQ Salesforce, or Configure, Price, Quote Software by Salesforce is a sales tool for companies to provide accurate pricing with any given product configuration scenario.…
Increase ROI by Investing in People | Make Earth Your Business
The video discusses the benefits of businesses that invest in and believe in their employees, customers, and communities. Investing in employee training and upskilling programs…
