Check partner Accounts for a billing country
Create a Record Health Check that applies only to channel partner Accounts and passes when the Account has a Billing Country. Other Accounts show Skipped, because the requirement does not apply to them. The example uses the Verify with a formula Evaluation Type with a formula applicability rule.
Why a formula fits
Section titled “Why a formula fits”Account Type decides whether the Check applies, and Billing Country decides whether it passes. Both are fields on the Account, so formulas can handle both decisions. Use a Check rather than a Validation Rule so that a missing country guides partner assignment without blocking other updates.
Before you start
Section titled “Before you start”- Install Record Health Check, and assign yourself Record Health Check Admin and the Salesforce Customize Application permission.
- Open Setup → Object Manager → Account → Fields & Relationships → Type and confirm the value that identifies partners. This example uses Channel Partner / Reseller, a standard Account Type value. Type is a picklist field; it is not the same as Record Type.
- If your org identifies partners another way, such as a Record Type or a custom field, change the Applies When (Formula) value to match.
- If your org uses State and Country/Territory Picklists, decide whether to use
BillingCountryCodeinstead ofBillingCountry. - Confirm that the people who will use the card can read Type and Billing Country.
Step 1: Create or choose the Check Set
Section titled “Step 1: Create or choose the Check Set”You can add the Check to an Account Check Set you already have. To create one, open Setup → Custom Metadata Types, select Manage Records next to Record Health Check Set, select New, enter these values, and save. Leave other fields at their defaults.
| Field | Value |
|---|---|
| Label | Account Data Quality |
| Object | Account |
| Record Health Check Set Name | Account_ |
| Active | Cleared until validation succeeds |
| Card Title | Account Data Quality |
| Card Subtitle | Confirm partner Accounts have a Billing Country. |
| When Checks Run | When the user clicks Run |
| Passed Checks | Show passed count only |
| Skipped Checks | Show each skipped check |
Show passed count only keeps passed Checks out of the list, so users see only what needs attention, while the summary still counts them.
Step 2: Create the Check
Section titled “Step 2: Create the Check”Open Setup → Custom Metadata Types, select Manage Records next to Record Health Check, select New, enter these values, and save.
| Field | Value |
|---|---|
| Label | Partner Has Billing Country |
| Check Set | Account Data Quality |
| Evaluation Type | Verify with a formula |
| Record Health Check Name | Partner_ |
| Evaluation Order | 30 |
| Active | Cleared until validation succeeds |
| Pass Condition | NOT(ISBLANK(BillingCountry)) |
| Check Title | Partner Account has a Billing Country |
| Check Description | Applies to channel partner Accounts. Passes when Billing Country is populated. |
| Message When Failed | Partner Account {!record. |
| Fix Message | Enter the partner's Billing Country, then run the Check again. |
| Message When Unable To Evaluate | Unable to check the partner's billing country. |
| Failure Severity | Critical |
| Action Label | Edit Billing Country |
| Action URL | /lightning/r/Account/{!record. |
| Applies To | When a formula is true |
| Applies When (Formula) | ISPICKVAL(Type, "Channel Partner / Reseller") |
| Message When Not Applicable | {!record. |
ISPICKVAL() compares a picklist field with one value. The value must match the stored picklist
value exactly, including capitalization and spaces.
Step 3: Validate and activate
Section titled “Step 3: Validate and activate”- Run the Validate Record Health Check Configuration Flow action, as described in Validate configuration before activation, and correct every error.
- Activate the Check, then the Check Set.
- Add the Record Health Check component to the Account record page, select Account Data Quality (Account_Data_Quality), and activate the page.
- Assign Record Health Check Card User to the users who test the card.
Step 4: Test the Check
Section titled “Step 4: Test the Check”Use sandbox Accounts that you can edit. Select Run on the card for each case.
| Account Type | Billing Country | Result on the card |
|---|---|---|
| Channel Partner / Reseller | Blank | Failed, with the message and Edit Billing Country |
| Channel Partner / Reseller | Populated | Pass. The row is hidden, and the summary counts it in Passed. |
| Any other value, or blank | Any value | Skipped, with the not-applicable message |
Run one partner case as a user who cannot read Type. The row shows Unable to Check, with the Message When Unable To Evaluate text.
What users see
Section titled “What users see”On a channel partner Account with no Billing Country, the row shows Failed, because Failure Severity is Critical, with the message, the fix message, and the Edit Billing Country link. On other Accounts the row shows Skipped with the not-applicable message. Passed rows are hidden and appear only in the summary count; hovering over the Passed count lists their titles.
Resolve problems
Section titled “Resolve problems”| What you see | What to check |
|---|---|
| Every Account shows Skipped | The picklist value in Applies When (Formula) exactly matches your org’s Account Type value. |
| A partner with a country still fails | Whether your org stores the country in BillingCountryCode. |
| Unable to Check | The user can read Type and Billing Country. |
| A passing Check is missing from the list | Expected with Show passed count only. Change Passed Checks to list every passed Check. |