Normalize email domains and phone numbers without changing source data
Run a deterministic record transform when Email and Phone are created or updated. Write the lowercase domain and digits-only phone into separate fields on the same record.
Best for
Small CRM owners, sales operations, lead-routing workflows, and data teams preparing contact records for matching or export.
Input
A Contacts table with Email, Phone, Email Domain, and Normalized Phone fields.
Output
A lowercase domain and digits-only phone on the same record, with original Email and Phone preserved.
The operational gap
Why this work breaks across separate tools
Mixed-case domains and formatted phone values are readable to people but inconsistent for grouping, lookup, routing, and duplicate checks. Editing the source value destroys what the user entered.
What Kition changes
Keep the source, the Agent, and the result together
Kition writes normalized results into dedicated fields. The transform is repeatable, source values remain untouched, and missing input can be surfaced instead of silently erasing an existing result.
A complete, reviewable workflow.
The goal is not a clever prompt. It is a visible chain from source material to an approved artifact that can be reused.
Keep source and target fields separate
Do not reuse Email or Phone as the write-back destination.
Bind a representative contact
Choose mixed case, spaces, punctuation, and an international prefix for the controlled test.
Run the deterministic transform
Extract the email domain and remove non-digit phone formatting.
Test the negative branch
Confirm missing or malformed input is visible and does not erase a prior normalized value.
Human review
Check this before the work moves forward
- Repeating the transform must produce the same output.
- Original Email and Phone values must remain unchanged.
- Digits-only output is not treated as full phone validation.
Outcome
What remains after the Agent finishes
- Matching fields become stable
- Human-entered source values remain intact
- The transform is idempotent
- Later workflows can use consistent values
Use the product guides, then adapt the workflow.
Start from the documented Kition objects and keep only the fields, review points, and automation your process actually needs.
Ready when you are.
Kition is a desktop AI workspace for connected documents, structured tables, editable designs, whiteboards, visual workflows, and reviewable AI agents.