Skip to content
Suggest a correction

Check partner Accounts for a billing country

Example5 min read

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.

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.

  • 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 BillingCountryCode instead of BillingCountry.
  • Confirm that the people who will use the card can read Type and Billing Country.

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.

FieldValue
LabelAccount Data Quality
ObjectAccount
Record Health Check Set NameAccount_Data_Quality
ActiveCleared until validation succeeds
Card TitleAccount Data Quality
Card SubtitleConfirm partner Accounts have a Billing Country.
When Checks RunWhen the user clicks Run
Passed ChecksShow passed count only
Skipped ChecksShow 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.

Open Setup → Custom Metadata Types, select Manage Records next to Record Health Check, select New, enter these values, and save.

FieldValue
LabelPartner Has Billing Country
Check SetAccount Data Quality
Evaluation TypeVerify with a formula
Record Health Check NamePartner_Has_Billing_Country
Evaluation Order30
ActiveCleared until validation succeeds
Pass ConditionNOT(ISBLANK(BillingCountry))
Check TitlePartner Account has a Billing Country
Check DescriptionApplies to channel partner Accounts. Passes when Billing Country is populated.
Message When FailedPartner Account {!record.Name fallback="this record"} has no Billing Country, so it cannot be assigned to a region.
Fix MessageEnter the partner's Billing Country, then run the Check again.
Message When Unable To EvaluateUnable to check the partner's billing country. Confirm that you can read Type and Billing Country.
Failure SeverityCritical
Action LabelEdit Billing Country
Action URL/lightning/r/Account/{!record.Id}/edit
Applies ToWhen a formula is true
Applies When (Formula)ISPICKVAL(Type, "Channel Partner / Reseller")
Message When Not Applicable{!record.Name fallback="This Account"} is not a channel partner, so partner assignment does not apply.

ISPICKVAL() compares a picklist field with one value. The value must match the stored picklist value exactly, including capitalization and spaces.

  1. Run the Validate Record Health Check Configuration Flow action, as described in Validate configuration before activation, and correct every error.
  2. Activate the Check, then the Check Set.
  3. Add the Record Health Check component to the Account record page, select Account Data Quality (Account_Data_Quality), and activate the page.
  4. Assign Record Health Check Card User to the users who test the card.

Use sandbox Accounts that you can edit. Select Run on the card for each case.

Account TypeBilling CountryResult on the card
Channel Partner / ResellerBlankFailed, with the message and Edit Billing Country
Channel Partner / ResellerPopulatedPass. The row is hidden, and the summary counts it in Passed.
Any other value, or blankAny valueSkipped, 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.

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.

What you seeWhat to check
Every Account shows SkippedThe picklist value in Applies When (Formula) exactly matches your org’s Account Type value.
A partner with a country still failsWhether your org stores the country in BillingCountryCode.
Unable to CheckThe user can read Type and Billing Country.
A passing Check is missing from the listExpected with Show passed count only. Change Passed Checks to list every passed Check.