Related data
Resolve prefixed field names
Merge the hierarchical data and see fields inside a repeating block retrieve values from related parent and child objects.
Understand the current template
Explore its merge fields, repeating blocks, and nested structure in an interactive template map.
Ready to tryUse the controls above to interact with this demo.
What this demonstrates
Address fields beyond the current object
Inside nested reporting structures, a simple field name resolves against the current data row. Prefixes and dot notation make the relationship explicit when a field must address a related object.
For example, a product field can be represented as Product.Name while the surrounding block iterates order-item objects.
API used
MailMerge.MergeJsonData
How it works
MergeJsonData preserves the JSON hierarchy. MailMerge interprets the prefix path stored in the field name and resolves each segment relative to the current block record.
