Summary

When using the “Link to open record” variable in an automation that includes a Merge Records action, the generated link in downstream steps (e.g., Send Email) points to the original triggering record—even if that record is deleted during the merge. This results in a broken link and creates an unusable output for end users.

Current Behavior

The automation trigger generates the “Link to open record” variable based on the initiating record.

The Merge Records action retains the oldest record and deletes the duplicate (triggering) record.

The Send Email step still uses the original variable, which now references a deleted record.

As a result, the email contains a link that resolves to a non-existent record.

Impact

Produces broken links in automation-generated emails.

Reduces user confidence in automated notifications.

Limits the practical usability of automations involving deduplication.

Forces users to manually locate the surviving record, reducing efficiency.

Expected / Desired Behavior

One of the following improvements would resolve the issue:

The “Link to open record” variable dynamically updates to reference the surviving (merged) record.

A new system variable becomes available, such as:

“Link to merged/surviving record”

“Final record after merge”

The automation provides a post-merge record reference that can be reliably used in downstream steps.

Proposed Enhancement

Enhance automation variable handling so that workflows involving record merges can reliably reference the final record state after all actions are completed.

Business Value

Ensures accurate and actionable notifications

Improves end-user experience and trust in automations

Supports data quality workflows (e.g., deduplication) without breaking downstream actions

Reduces need for manual intervention or workaround logic

Use Case Example

A deduplication automation merges duplicate records and sends a notification email. The recipient expects a working link to review the updated record, but instead receives a dead link because the original record was deleted during the merge.