How to filter records by condition, range, or date in merge templates
Overview
Before running a merge in Zoho Writer, you can filter and select specific records from your data source to ensure only relevant information is included in your merged documents.
Ways to Filter Records:
- Based on Conditions
Apply one or more conditions to pull only the records that match specific criteria—like names starting with “A”, amounts greater than 1000, or a specific status. - Based on a Range
Select records from a particular range, such as rows 1–50, if you want to control the number of records being merged without setting conditions
Steps to Filter Records
1. Under 'Select Data Source', click Filter icon
2. Select Based on conditions if you want to set up condition(s) for the records. Alternatively, choose Between a particular range to choose records using range.
A. Filter Based on Record Range
Select records from a particular range, such as rows 1–50, if you want to control the number of records being merged without setting conditions.
B. Filter based on Conditions
Use conditions to filter and extract specific records from your data source that meet defined criteria. Apply one or more conditional operators to narrow down the records each time you run a merge. You can filter based on text, numbers, images, and other data types using the available list of conditions.
C. Filter based Date Conditions
To filter records using a date-based condition, ensure that the merge field you select is of the date type. Choose the appropriate date field from your data source and apply a condition from the available list. Make sure that the date or time format in your condition matches the format used in the selected field to ensure accurate filtering.
D. Filter Subform Data in Merge
- Place the cursor inside the Subform Repeating Regions.
Configure required conditions based on subform fields values or range to filter subform records to merge and hit filter
:
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:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
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, ...How to customize date field format in merge template
Overview Zoho Writer allows you to customize the format of date fields in merge templates, so the final document displays dates in the preferred style—whether that's 25 July 2025, 07/25/2025, 25-07-2025, or even localized formats like 25 जुलाई 2025. ...How to merge subform fields and image field via Zoho Writer's Merge APIs?
Overview Zoho Writer's Merge API enables the dynamic population of documents using data from Zoho CRM. This includes merging not only standard fields but also related list (subform) fields and image fields. This guide outlines the steps required to ...How to sort data in repeat blocks in merge templates
Overview You can organize your repeat table data by sorting it using specific merge fields. For example, to list employees by department, and then by their date of joining within each department, use the 'Sort Repeat Records' feature in Zoho Writer. ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources