Skip to content

Check whether an Account is ready for research

Create a Formula Check that passes when an Account has either a Phone or a Website. When both are blank, the card asks the user to add a reliable starting point before outreach.

Phone and Website are fields on the Account that is already open. Verify with a formula can review both fields without SOQL or Apex. This is guidance rather than a Validation Rule because a missing research starting point should not block an unrelated Account update.

  • Confirm Phone and Website under Setup → Object Manager → Account → Fields & Relationships.
  • Decide whether either field is enough. This example uses either; use AND instead of OR if your requirement needs both.
  • Confirm that the people using the card can read Account, Phone, and Website.
  • Save new configuration inactive and validate it before activation.

You can add this Check to an existing Account Check Set. To create a new one, open Setup → Custom Metadata Types → Record Health Check Set → Manage Records, select New, and enter:

Salesforce fieldValue
LabelAccount Data Quality
Record Health Check Set NameAccount_Data_Quality
ObjectAccount
Card TitleAccount Data Quality
Card SubtitleConfirm Phone or Website is available before seller research.
When Checks RunWhen the user clicks Run
Summary DisplayShow below checks
Found/Expected DisplayShow on demand
ActiveUnchecked until validation succeeds

Open Setup → Custom Metadata Types → Record Health Check → Manage Records, select New, and enter:

Salesforce fieldValue
LabelAccount Is Ready for Seller Research
Record Health Check NameAccount_Ready_For_Seller_Research
Check SetAccount Data Quality, or your existing Account Check Set
Check TitleReady for seller research
Evaluation TypeVerify with a formula
Pass ConditionOR(NOT(ISBLANK(Phone)), NOT(ISBLANK(Website)))
Failure SeverityWarning
Message When Failed{!record.Name fallback="This Account"} needs a Phone or Website before seller research.
Fix MessageAdd a verified business phone number or website, then run the Check again.
Action LabelEdit account
Action URL/lightning/r/Account/{!record.Id}/edit
Evaluation Order10
ActiveUnchecked until validation succeeds

The formula checks only whether a value is present. A placeholder website still passes, so use a different pattern when validity matters more than presence.

  1. Run the configuration-validation Flow.
  2. Correct every error and review every warning.
  3. Set the Check and Check Set to Active only after validation succeeds.
  4. Add Record Health Check to the Account Lightning record page and select the Check Set.
  5. Assign Record Health Check Card User to the people testing the card.

Use sandbox Accounts that are safe to edit.

PhoneWebsiteExpected result
BlankBlankWarning with the research-readiness guidance
PopulatedBlankPass
BlankPopulatedPass
PopulatedPopulatedPass

Run the same tests with the field access used by the people who will use the card. If Phone or Website is not readable, the Check must not guess a result.

The card evaluates the formula and compares its result with the configured expected value.

Result detailMeaning
PASSThe formula result satisfies the configured comparison.
FAILThe formula result does not satisfy the comparison, and the card shows the configured guidance.
SKIPPEDThe Check does not apply or a configured prerequisite did not pass.
FoundThe evaluated formula result for the current record.
ExpectedThe configured fixed value or evaluated expected formula.
What you seeCheck this first
The Check Set is missing in Lightning App BuilderConfirm Object is Account and the Check Set is active
The card has no Check rowConfirm the Check is active and belongs to the selected Check Set
Unable to CheckConfirm Read access to Account, Phone, and Website
A placeholder website passesPresence is all this formula tests; use Query or reviewed Apex for stronger validation
Edit account does not open the same recordCopy the Action URL exactly and keep {!record.Id} in the path