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
- 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:
All-in-one knowledge management and training platform for your employees and customers.
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 Zoho Writer’s template-based document generation lets you automatically create personalized documents by merging pre-designed templates with data from spreadsheets, forms, CRMs, or APIs. Merge fields pull in real data to generate contracts, ...Configure workflow in Zoho Books with Writer's mail merge
Overview Use Zoho Writer with Zoho Books to create branded PDFs and automate document generation from your Books data. You can either use the Zoho Writer Templates extension in Zoho Books for one‑click document generation, or configure ...How to generate a document for every subform record
Overview Generate a unique document for every subform record using its data and main form data together, using Zoho Writer. There are many business scenarios and transactions which include multiple entries/records which <have a common or parent ...How to generate labels with Zoho CRM data using mail merge
Navigate to Settings from CRM Home. Under customization, click Templates > Mail Merge > New Template. Select a module. Assign a name to the template and pick a folder for the template to be saved and click Create, and select Blank. Insert a table and ...How to add a Zoho Checkout payment link to mail merge emails in Zoho Writer
Overview Zoho Writer allows you to insert Pay Now links or buttons powered by Zoho Checkout into mail merge emails. Recipients can click the payment link or button in the email and complete the payment through the configured Zoho Checkout payment ...