How to sort data in repeat blocks in merge templates
Overview
Prerequisites
-
Merge Template: Create a Zoho Writer document with merge fields.
Field Mapping: Each data source field should be mapped to a corresponding merge field.
-
Connected Data Source: Link your template to a supported data source such as Zoho CRM, Zoho Creator, Zoho Forms, Zoho Sheet, or an external source via API.
Steps:
- In the template, insert a repeat table containing the necessary fields. Note that you can choose between a simple repeat, row repeat, or any other type of repeat region.
- Right-click on the field by which you intend to sort your repeat data. From the drop-down menu, select Sort Repeat Records.
- For Simple Repeat block
- For Repeat table block
- Primary sorting: Next, select the field you wish to sort by. Specify the field type (e.g., text, date, number), and indicate whether you want the data sorted in ascending or descending order.
- Secondary sorting: Specify a secondary merge field(date of joining) in Then by to sort the data within each group created by the primary sorting.
- Click on Sort to initiate the sorting process. Then, preview your merge to ensure that the data is sorted as desired.
Related Articles / Videos:
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Getting started with document merge in Zoho Writer
Overview Template-based document generation in Zoho Writer allows you to automate the creation of personalized documents by connecting pre-designed templates with structured data sources such as spreadsheets, forms, CRMs, or APIs. Each template ...How to merge Writer templates using Zoho Flow
We're working on a Zoho Flow-Writer integration to help you pick template documents from Writer, place merge fields on them and merge it with data from Zoho Services. Find below steps to merge Writer Documents and with Zoho Creator Form fields. Steps ...How to track merge status and handle errors in Zoho Writer
Overview You can track the status of the merge jobs using email notifications and the merge logs. While email notifications help you track the merge initiation and completion status, the merge logs help you track the status of jobs in progress, along ...How to trigger document merge in Zoho Writer
Overview Zoho Writer document merge can be triggered in four ways: manually, on a schedule, on form submission, or via an incoming webhook. This flexibility allows you to choose the most suitable automation method—whether you want to merge documents ...How to merge and send document via email in Zoho Writer
Overview The Merge and Send via Email option in Zoho Writer lets you generate personalized documents for each record in your data source and automatically send them via email. Each recipient gets a customized document as an attachment or inline ...