Library / Data quality / data-quality-003

Phone number formatting to a standard international format

Data quality Operations Hub Professional Contact Simple ~20 min to build

Outcome. Every contact's phone number lands in one consistent international format, so dialers, texting tools, and country-based segmentation all read the same value.

Workflow mapEnrollment, branches and actions at a glance
flowchart TD
    A[Phone or mobile known, not yet formatted] --> B[Format a phone number: Phone number]
    B --> C{Mobile phone also known?}
    C -->|yes| D[Format a phone number: Mobile phone number]
    C -->|no| E[Skip mobile format]
    D --> F[Set Phone format status = Formatted]
    E --> F
    F --> G{Parse failed?}
    G -->|yes| H[Set Needs review + add to review list]
    G -->|no| I[Done]

When to use it / when not to

What the full spec adds

  • Prerequisites: 3 items, every property with its internal name, type and options
  • Enrollment: trigger, criteria as ticked in the UI, re-enrollment rule, suppression
  • Steps: 4 numbered actions with their parameters, branches and delays
  • Known pitfalls: 4 traps seen in production
  • Test plan, Variants and the YAML build spec
  • Files: PDF, Markdown, properties JSON to create the fields in one API call, and the custom coded action as a ready-to-paste .js file

One-time payment. Includes every spec added to the pack later, up to the full 500. Consultants: Everything, forever adds the agency licence for unlimited client portals.

Everything add-on Install this workflow in my portal Two clicks: authorise your portal, confirm. Properties created, workflow delivered switched off, ready to review. Coming to Everything and Pro buyers first.