Tip #26: Filter your records before merging a document

Tip #26: Filter your records before merging a document


Tom is an HR executive who has to send onboarding emails every month to newly joined employees. He has a master spreadsheet with all the employee details, and new employees are added to them as they join.

It's the month of March and Tom has to send onboarding emails to employees who've joined this month. But, how is Tom going to go through a big spreadsheet with multiple new and past information, and send onboarding emails to the set of newly joined employees?
 

 
Simple, by filtering and merging them in batches. 
 
Writer lets you filter records before merging a document, so you can avoid sending emails to previously contacted recipients. Here's how:
 
1. Prepare the template and choose the data source (To learn more about creating templates, click here)
 
 

2. Click on the Filter option, next to the data source. Now Tom can either filter the data by specifying the range or by using the conditions. 



 
Tom can use filters to specify the range of the data to be included.

By filtering using range
 
1. Choose the Between a particular range option and specify the range as 23-38 (as the 23rd record is the first employee who joined in March and the 38th record is the last).



 
2. Now after merging, the merged result will affect only records from 23 to 38.



 
Additionally, Tom can also filter the data by adding a condition that includes only employees who've joined in March.
 
By filtering using conditions
 
1. Choose the Based on Conditions option. Since Tom is filtering based on the month of joining, he would select the condition as Month of joining <contains> March. 


 
2. Now after merging, the merged result will only pull the details of employees who have joined in March.



Tom is now happy that he got the job done right and didn't end up spamming his older employees. Got questions regarding this feature? Let us know in the comments below.

 
 
 Happy writing!




Found this helpful? Subscribe to Writer Community for more tips and tricks.
We're also on Twitter. Follow us for all our latest updates! 

 




    • Sticky Posts

    • 8 Neat Tricks in Writer You Should Know About

      Want to get the most out of Writer and speed up your work? You've come to the right place. We've compiled some productive shortcuts in Writer that can help you get work done more quickly: 1. Look up synonyms No more need for a bulky thesaurus! Use Writer's

    • Tip #26: Filter your records before merging a document

      Tom is an HR executive who has to send onboarding emails every month to newly joined employees. He has a master spreadsheet with all the employee details, and new employees are added to them as they join. It's the month of March and Tom has to send onboarding

    • Tip: #11 Collaboratively fill documents with your colleagues and clients

      Last week we talked about how Fillable Fields can help you create contracts and proposal templates you can repurpose across your processes. This week, we'll talk in detail about how to collaboratively fill those templates with your clients and team. Say

    • Tip #07: Five best defaults in Writer you can change to complement the way you work

      Find yourself adjusting settings to the way you like every time you create a new document? Try tweaking the default settings instead. From font styles to auto correct options and more, here are the five best defaults settings you can control. 1. Default

    • Tip #06: Make the best use of Zia in Writer

      About to share your work with your team? Looking to get a second opinion quickly before that? Let Zia do it. Zia, Zoho's AI-powered intelligent assistant is now part of Writer. She's trained to check and polish your work. She doesn't just read, she understands.

    • Recent Topics

    • Zoho One Backup of entire account

      Hello, When using Zoho one is there a way to backup your entire account of all apps that you are using \ activively using in a single step or do you have to backup each applications data individually? Thanks,

    • Custom invoice template issue

      Hi. I created a custom invoice template, but it isn't working properly. Even though I select my custom template, Zoho still opens the standard one while showing that the custom one is selected. Please advise on how to fix this

    • Can't view nor download attachments

      Me and a number of people I know suddenly stopped being able to either view nor download attachments that arrive in new emails we receive since this morning. Older emails work just fine and we can download/view them. Zoho Mail states the it wasn't able

    • Zoho CRM APIs

      Hello, I think as a developer, it is very important to have the ability to manage, develop, and execute functions directly from my local development environment (for example, VS Code). Zoho CRM should have a way to create, deploy, and manage functions

    • Record Payment - Auto Populate Amount as payments are selected

      When recording payments you have the option of clicking on "Pay in Full" next to the bill which automatically adds the total at the bottom of the page next to "Amount used for payments" but this should also auto populate / update the total at the top

    • Zoho Projects - Add Event Change as Trigger

      I am currently trying to create an automation in Zoho Flow that sends a notification when an Event is updated in Zoho Projects. At present, Zoho Projects only provides a trigger for Event creation. There is no trigger available when an existing Event

    • Tips & Tricks #4: Zoho People - Mejoras y Novedades durante el Q2 de 2026

      ¡Hola, Comunidad de Zoho en Español! Os traemos una selección de las novedades y mejoras más interesantes que llegaron a Zoho People durante el segundo trimestre de 2026. En este artículo te hablamos de: Zia, el asistente de IA para RR. HH. OKR llega

    • You do not have sufficient permissions to perform this operation. Contact your administrator.

      When I attempt to log a call I initiate the +New Call and Start Calling and I click Answered Call in the popup dialog box that follows. Any attempt to save or close this dialog box results in "You do not have sufficient permissions to perform this operation. Contact your administrator." The only way I can get the popup to disappear is to refresh the page and it will go away. I have found others reporting this issue when they attempt to run reports.  Any suggestions? Thank you in advance for taking

    • More flexibility on Hosted Pages ?

      I like more flexibility on Hosted Pages, this is due to the fact I am not a programmer I wold like to have more customization on Hosted Pages like: - add Addons and coupon to a plan already suscribed in the past - cutomize the look an feel (as a form

    • Marketer's Space: Write CTAs your audience can't ignore

      Hello Marketers! Welcome back to Marketer's Space! Today we're zeroing in on a small concept that decides whether your whole campaign was worth sending: the call-to-action (CTA). You could write the sharpest subject line and design the most polished template

    • Button to renew offline subscription.

      If i have a customer who pays offline, and wants to renew the subscription, you have to wait till the end of the subscription and reactivate it. or else it affects metrics. There is a way to upgrade or downgrade a subscription, immedeatly or at the end

    • multiple Brands separate topic landing pages

      hii, i cant seem to figure out how to separate brands from the select topics marketing landingpage. i can only add topics for other brands, but i want to keep them complete separate

    • Public Forms for an all-inclusive feedback system

      The more we seek information from the customers, the more we solve their needs and gain their trust. However, reaching out to every customer to seek requirements, solve their issues, and gather feedback can be tasking. Circulating a public form helps

    • How to embed event list page from Backstage onto my site

      I'd like to embed the events list page from Zoho Backstage ( https://biz2bizlinksevents.zohobackstage.com/events) into my site, but when I use an iframe it says the page refused to connect. My other iframes with microsites from Zoho recruit and forms

    • Function #40: Notify users when invoices exceed the credit limit

      Hello everyone, and welcome back to our series! Businesses tend to offer goods or services on credit to customers, which can, in overtime, lead to the accumulation of significant overdue balances. To address this, Zoho Books allows you to define a Credit

    • Zoho CRM - Kiosk Studio: Build Once, Execute Multiple Times with Loops

      Hello Everyone, Introducing Loop Functionality in Kiosk Studio. If you've ever built a Kiosk that needed to perform the same action multiple times like updating a list of contacts, scheduling calls for a batch of leads, or processing multiple products

    • The 3.1 biggest problems with Kiosk right now

      I can see a lot of promise in Kiosk, but it currently has limited functionality that makes it a bit of an ugly duckling. It's great at some things, but woeful at others, meaning people must rely on multiple tools within CRM for their business processes.

    • Manual Journal not affecting the YE Trial Balance

      I have done a manual journal moving an expense from prior year to current year. However, it is not affecting the prior year figures at all, when I go to the expense the journal isn't even reflecting at all. I have made sure dates are correct and both

    • Tip #82 – Let Zia Answer Bot Handle the Questions So You Can Focus on the Fix – 'Insider Insights'

      Tip #82 – Let Zia Answer Bot Handle the Questions So You Can Focus on the Fix – 'Insider Insights' Hello Zoho Assist Community! Imagine you're in the middle of a critical remote session. The customer, a project manager at a mid-sized firm, has been locked

    • Caso de Éxito: Namencis Education crece un 117% con Zoho One

      "Hemos estado creciendo en torno a un 117% al año, que es una barbaridad. Tuvimos una rentabilidad del 33%, que antes no teníamos ni por asomo. Escalamos en tres años lo que no habíamos escalado en los anteriores siete." Borja Domínguez, CTO de Namencis

    • Introducing Workqueue: your all-in-one view to manage daily work

      Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? Sales

    • [IDEA] Bring Layout - Conditional Rules and Client Scripts to Zoho Books

      The problem We run Zoho Books with two e-invoicing integrations: myData (Greek tax authority, AADE) and PEPPOL (EU e-invoicing). Between the two, our Invoice form carries a large number of custom fields — document type codes, VAT exemption categories,

    • Introducing the Revamped Zoho Projects Chrome Extension

      Zoho Projects Chrome Extension brings your project management capabilities directly to your browser. Users can access all their portals, create tasks, file issues, log time, and stay updated on project activities without navigating to the main application.

    • Bigin Android app update: Alerts while creating tasks outside of working days, conflicting events and calls.

      Hello everyone! In the most recent version of the Bigin Android app, we have brought in support to display an alert if task is being scheduled outside of the working days. Also, when scheduling an event or call in the Activities module, a conflict alert

    • Create modules using natural language prompts

      Hello all, We’ve introduced a new enhancement to Zia that allows you to create custom and team modules in Zoho CRM using plain language prompts. Why this enhancement? Creating a custom module traditionally involves multiple steps—choosing field types,

    • Assign account to a ticket created with WebToCase

      We use Zoho Desk. Our large client uses WebToCase form to submit tickets. I have two workflow rules: When a contact is created and its email ends with example.com, it runs a custom function, which assigns the new contact the right account Example with

    • Collapsible Sections & Section Navigation Needed

      The flexibility of Zoho CRM has expanded greatly in the last few years, to the point that a leads module is now permissible to contain up to 350 fields. We don't use that many, but we are using 168 fields which are broken apart into 18 different sections.

    • Can the SEO Keyword field be increased from 100 characters to the industry standard 160 characters

      Hello, Currently Commerce restricts the SEO meta-keywords to 100 characters, which I'd always found to be a bit constraining, often times not enough space to suit my needs. I recently discovered however that search engines will accept up to 160 characters

    • Cookies Consent Management in Webforms

      Hello Everyone! We are excited to introduce Cookie Consent Management for webforms. Read on to learn more. Webforms are online forms embedded on websites that allow users to submit data and create records in Zoho CRM. These forms utilize cookies to track

    • Trigger workflows from SLA escalations in Zoho Desk?

      Hey everyone, I’m currently working with SLA escalation rules in Zoho Desk and ran into a limitation that I’m hoping someone here has solved more elegantly. As far as I can tell, SLA escalations only support fairly limited actions (like changing the ticket

    • Como exportar la base a excel sin perder datos

      Estimados quisiera saber como exportar o descargar la base de tickets para hacer estadisticas sin perder datos al copiar

    • Show my cost or profit while creating estimate

      Hi, While creating estimate it becomes very important to know exact profit or purchased price of the products at one side just for our reference so we can decide whether we can offer better disc or not .

    • Mise à jour de Zoho Books – France

      Chers clients, Merci pour votre patience et votre soutien continu. Avec les évolutions réglementaires à venir en France nous introduisons de nouvelles fonctionnalités dans Zoho Books pour les clients français. Ces mises à jour ont été conçues pour répondre

    • Is there any way to have Dataprep ingest RSS?

      As stated by the title. Does the Zoho environment offer tools that I can use to, directly or using workarounds, have Dataprep ingest an RSS feed? Thanks

    • Connect ZOHO social with Google Data Studio and download data from ZOHO social

      Dear ZOHO team, I am writing this message to enquire about how to connect ZOHO social with Google data studio since our company would like to use Google data studio to generate reports. Is it a way to download data from ZOHO social? Best regards, Chris

    • Zoho People Whats New - Q2 2026

      Hello Users! We're excited to share the latest updates introduced in Zoho People during Q2 2026. This release brings a range of new features and enhancements designed to simplify HR operations, automate routine processes, and deliver a smarter, more connected

    • Manage booking pages from your Android phone

      Hello everyone! We are happy to announce that users can now add and manage booking pages from their Bigin Android app. It is a multi-step form that users can create for purposes like booking appointments, scheduling calls or meetings, conducting webinars,

    • Zoho Team Inbox - roadmap

      Hi, would be good to understand the Teaminbox roadmap, in particular: 1. API / Zoho Deluge connections. We have a process where the each email needs to be either tagged or assigned daily. It would be great if we could automate a 5pm alert for any exemptions

    • Zoho CRM Community Digest - July 2026 | Part 1

      Hello everyone, July is here! The first two weeks brought six CRM updates ranging from privacy-ready webforms to a significantly more powerful Layout Rules engine, two community wins worth a look (a dashboard workaround for spotting leads with no activities,

    • How do I migrate from Office 365 to Zoho Mail?

      Check out Advik Email Migration Wizard, this software is specially developed to move mailboxes from Office 365 to Zoho Webmail. In addition you can migrate from Gmail, Yahoo, Rediffmail and 80+ webmail servers to ZOHO MAIL. Isn't it amazing? This is an all in one email migration solution. Steps to export emails from Office 365 to Zoho Webmail are as follows; Run Advik Email Migration Tool in your system. Select Office 365 as source and enter its login credentials. Select mailbox folders and choose

    • Next Page