Skip to content
All case studies
B2B servicesWorkflow Automation3 min read

Same person. New inquiry. Not a duplicate.

Repeat submissions could carry a genuine new need. The Zoho workflow had to protect contact history while recording each distinct request.

Zoho Forms · Zoho Flow · Zoho CRM · Validation Rules

-85% manual record entry

71% → 95% Complete First-Pass Records · Duplicate Creation 8% → <1% · 6-Week Automation Rollout

The record logic I designed

A returning contact could still have a new enquiry. Identity matching and enquiry creation were separated so Zoho could preserve contact history without dropping the new request or overwriting earlier context.

One contact could make several genuine inquiries.

The services business used Zoho Forms for inquiries but still recreated or updated CRM records manually. Repeat submissions could represent the same person with a new need, yet the process either created another contact or overwrote context on an existing record.

Protecting records during updates and retries

A low duplicate count is not sufficient evidence of correct matching. Aggressive merges can make that metric look excellent by combining different people, so ambiguous cases needed review rather than silent consolidation.

Repeated webhook delivery also had to be distinguished from a genuine new inquiry. Processing that can be retried without duplicate actions prevented replays from creating another record or repeated action, while update rules preserved reliable existing values and made exceptions visible.

Separate the person from the inquiry.

An existing contact could submit a genuinely new request. The workflow distinguished that request from a repeated delivery and updated only the fields it was allowed to change.

Separate the person from the inquiry.
Incoming situationCRM treatmentProtection
New person, new inquiryCreate the appropriate contact and linked requestValidate required information before downstream action
Known person, new inquiryPreserve the contact and record the new business eventApply field ownership rather than overwriting everything
Repeated delivery of one submissionRecognize that the event has already been processedAvoid repeated creation or follow-up
Uncertain identity matchHold the ambiguity for reviewDo not merge different people on weak similarity
Failed record or assignmentRetain context in the exception pathGive recovery an owner and a clear record

Deduplication protected the contact record without erasing valid demand. Recovery also needed to preserve the customer’s existing history.

Keep the contact and the inquiry distinct

Required and optional information were defined separately, then incoming formats and picklist values were normalized. Matching used reliable identifiers such as an exact email or known CRM relationship; ambiguous similarities were sent for review instead of automatically merging contacts.

A new person could receive a new contact and inquiry, while an existing person received a linked new inquiry with appropriate contact updates. This protected the history of distinct requests without duplicating the person each time.

Update safely when a submission arrives again

Field ownership determined which submission values could replace existing data. Submission identifiers supported processing that can be retried without duplicate actions, so a repeated delivery could be recognized without treating every new inquiry from the same person as a duplicate.

The Zoho flow assigned the next action after the record was usable. Validation failures, uncertain identity, API errors and assignment problems entered a visible exception path with investigation context. The automation therefore included recovery and review, not only the successful transfer from form to CRM.

Protect existing customer information

A repeat submission could add valid information without being allowed to overwrite every existing field. The update rules needed to preserve trusted values and maintain the separate inquiry record, so a convenient overwrite would not erase useful history.

Sample review considered false merges as well as duplicates, along with completeness, ownership and retained requests. This supplied a more balanced quality check than duplicate count alone, protecting the operational value of the CRM while reducing manual entry.

Six weeks of record quality

Within six weeks, manual record entry fell 85%. Information complete on the first attempt rose from 71% to 95%, while duplicate creation fell from 8% to below 1%.

Sample checks for false merges and preserved inquiry history remain essential, because the apparent efficiency gain would be misleading if the CRM lost the distinction between a person and their requests.

A contact, a new inquiry and a replayed submission were treated as different events. That distinction protected customer history while making failed deliveries recoverable without duplicating the work.

Zoho form-to-CRM automation

I can help you connect forms to your CRM without creating duplicates or erasing history.