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! 

 





      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • 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 synonym suggestions to explore different word choices, and find the one that fits your style and tone the best. All you have to do is right-click on a word, and select Synonyms from the dropdown list.  2. Insert images, tables and more   Typing
          • 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
          • 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 you've entered into a contract with multiple clients but the final contract amount is still under negotiation. Using fillable fields, partners can quote their contract fee directly in the template document without affecting other areas of the document. You
          • 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 font style   Use your favorite typography across all your documents. You can customize a font style by adding a color, adjusting its size and more, and then set it as default.    To do this, go to More Options > Format > Font. Choose a font style
          • 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. So apart from grammar and spelling checks, she'll let you know when you've used a wrong adjective, or have missed out words based on the context of your piece.   Every time you write, Zia makes a scorecard after carefully assessing your

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • How to create auto populate field based on custom module in Zoho CRM?

                                    Hello, i'm still new to Zoho CRM and work as administrator in my company. Currently, I'm configuring layout for Quotes Module. So, the idea is, I've created a read-only field in Quotes called "Spec". I want this field automatically filled with Specification
                                  • Rich Text For Notes in Zoho CRM

                                    Hello everyone, As you know, notes are essential for recording information and ensuring smooth communication across your records. With our latest update, you can now use Rich Text formatting to organize and structure your notes more efficiently. By using
                                  • Change Last Name to not required in Leads

                                    I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions for
                                  • Elevate your CX delivery using CommandCenter 2.0: Simplified builder; seamless orchestration

                                    Most businesses want to create memorable customer experiences—but they often find it hard to keep them smooth, especially as they grow. To achieve a state of flow across their processes, teams often stitch together a series of automations using Workflow
                                  • Office 365 and CRM mail integration: permission required

                                    Has anyone run into this weird problem? My email server is Office 365. When I try to configure Zoho CRM to use this server, a Microsoft popup window opens requesting user and password. After entering that, I get a message in the Microsoft window saying
                                  • Adding a developer for editing the client application with a single user license

                                    Hi, I want to know that I as a developer I developed one application and handed over to the customer who is using the application on a single user license. Now after6 months customer came back to me and needs some changes in the application. Can a customer
                                  • Confirmation prompt before a custom button action is triggered

                                    Have you ever created a custom button and just hoped that you/your users are prompted first to confirm the action? Well, Zoho knows this concept. For example, in blueprint, whenever we want to advance to the next state by clicking the transition, it is
                                  • Attention API Users: Upcoming Support for Renaming System Fields

                                    Hello all! We are excited to announce an upcoming enhancement in Zoho CRM: support for renaming system-defined fields! Current Behavior Currently, system-defined fields returned by the GET - Fields Metadata API have display_label and field_label properties
                                  • Deluge - Can't get phone number SalesIQ

                                    Hey folks, I’m building a custom plug for SalesIQ that’s supposed to register leads into Zoho CRM. The SalesIQ chat is being implemented on WhatsApp, and in my plug I’m using this line: mobile_clean = session.get("phone").get("value"); From what I understand,
                                  • Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed

                                    Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted
                                  • Deals by Stages Funnel not showing in correct order

                                    Using the Stage-Probability Mapping for the Deals module we have created a steps our deals will pass through, RFQ, Closed/Lost, Declined/No-Go, Pricing, Submitted, Negotiations, Won. However when I view the Deal By Stages Funnel it does not show in the
                                  • Zoho CRM button to download images from image upload field

                                    Hello, I am trying to create a button in Zoho CRM that I can place in my record details view for each record and use it to download all images in the image upload fields. I tried deluge, client scripts and even with a widget, but feel lost, could not
                                  • how to differentiate if whatsapp comes from certain landing page?

                                    I create a Zobot in SalesIQ to create a Whatsapp bot to capture the lead. I have 2 landing pages, one is SEO optimized and the other want is optimized for leads comes from Google Ads. I want to know from which landing page this lead came through WhatsApp
                                  • Zoho Desk - Community

                                    As a regular user of Zoho Cares Community I would really love to see the publish date of articles. For example, when I look at Announcements, it would be very beneficial to see which ones were posted recently, over those which have just and a recent comment.
                                  • access to quartz for my customers

                                    Hi how can I have access to the application quartz you use for us to send you screen rocording, this feature would be immensely useful for our customers support https://quartz.zoho.com/
                                  • Issue with Inline Images in Email Reply via Zoho Desk API

                                    Hi, I am attempting to send inline images in an email reply using the Zoho Desk API, but the images are not being displayed inline for the recipient. I have followed this documentation: https://desk.zoho.com/DeskAPIDocument#Uploads https://desk.zoho.com/DeskAPIDocument#Threads#Threads_SendEmailReply
                                  • Turning off the new UI

                                    Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?
                                  • How to search a value stored in a subform?

                                    Hello, We store serial numbers in subforms but now we would like to be able to search the values to be able to easily find the record with the serial number. I saw that it's not possible to search such values through global search but is it possible to do it an other way? Thank you,
                                  • Field Dependency Not Working on Detail Page in Zoho Desk

                                    Hi Support Team, I’ve created field dependencies between two fields in Zoho Desk, and they are working correctly on the Create and Edit layouts. However, on the Detail page, the fields are not displaying according to the dependencies I’ve set — they appear
                                  • How do the keyword critera work?

                                    Hi, I'm working on automated assignment of tickets based on keywords. How does this feature work? Where does this criteria look for keywords - email address, subject, email body? Can you please clarify this as I want to avoid overlapping with criteria
                                  • Error: Unsupported content type: text/html;charset=UTF-8 after tryeing to get the token for n8n automation

                                    I am working on ZOHO Desk automation and need to get the ZOHO auth token for n8n I have created the app in ZOHO Desk API, got client id and client secret. Added all data required to get a token in n8n. After I sign in with my ZOHO credentials in ZOHO
                                  • Improving Collaboration Features in Zoho Portal

                                    Hello Zoho Community, I’ve recently started exploring Zoho services and I’m really impressed with the wide range of features. However, I feel there is still room for improvement in the collaboration area. For example, it would be really helpful if we
                                  • Clear Tag & Linking Between Quotes and Sales Orders

                                    Hi Zoho Team, In Zoho Books, when a quote is converted into a sales order, it would be extremely useful to have: A clear tag/indicator on the quote showing that it has been converted into a sales order. A direct link in the sales order back to the originating
                                  • New in Cadences: Option to Resume or Restart follow-ups when re-enrolling records into a Cadence, and specify custom un-enrollment criteria

                                    Managing follow-ups effectively involves understanding the appropriate timing for reaching out, as well as knowing when to take a break and resume later, or deciding if it's necessary to start the follow-up process anew. With two significant enhancements
                                  • Send a campaign to one recipient.

                                    Very often I speak to a customer and they say they didn't see my email (maybe it went in Junk, maybe they deleted it). Anyway, I just want to go into the Campaign and send it to one person. You already have a feature very close to this - when sending a Test. While developing a campaign, I can send tests to anyone. Why can't we have this AFTER  the campaign has been sent? I know, there's a caveat, and that's in the use of merge tags. Most of the time I only use FNAME, but maybe you could check if
                                  • Feature Request - Insert URL Links in Folders

                                    I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create
                                  • Try FSM again for our business

                                    We already have our customers individual equipment in CRM with serial numbers, install dates, warranty length and importantly next service which is generally 2 years. a month before the service date is due we get get a report and send out service reminders.
                                  • GST Slabs Redefined: Stay Compliant Using Zoho Books!

                                    Hello Everyone! The Government of India is rolling out new GST rates, a major reform aimed at simplifying the current tax structure starting 22 September 2025. GST will move from four slabs (5%, 12%, 18%, 28%) to two main slabs (5% and 18%), plus a special
                                  • Get Cliq Meetings in my O365 calendar

                                    Hi, we are currently evaluating to replace the Teams Messaging and Meetings with Cliq. We currently still have all our email and calendars in O365. What i want to achieve is, to create a (ZOHO) meeting from Cliq and have this meeting added to my Outlook/O365
                                  • Issue with Zoho Help Portal – Tickets Missing or Not Answered

                                    Hi, How are you? I think there may be an issue with the Zoho Help Portal. I opened a few tickets directly in the help portal a some time ago but never received any response I also opened ticket 148356451 by email. I did receive a reply to it, but the
                                  • Changing the Default Search Criteria for Finding Duplicates

                                    Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.
                                  • Zoho Creator as LMS and Membership Solution

                                    My client is interested in using Zoho One apps to deploy their membership academy offer. Zoho Creator was an option that came up in my research: Here are the components of the program/offer: 1. Membership portal - individual login credentials for each
                                  • DUNS & Bradstreet and Credit risk monitoring integration with Zoho books

                                    Small businesses not being paid by bigger clients and clients of all sizes is a huge problem. It will be nice if Zoho develops integration with DUNS & Bradstreet(D&B) and Credit risk monitoring integration with Zoho books. That have small businesses can
                                  • Filtering Tickets based on Email headers

                                    We're starting to get a lot more junk coming into our Zoho Desk, which is then triggering unnecessary email alerts to agents. Once thing we could do to cut this junk in half, is to filter tickets based on email headers. Any email containing the `List-Unsubscribe`
                                  • Zoho Forms - Form Rules based on attachment fields

                                    Many businesses use forms to collect documents and images from customers. In many cases, you may want to trigger a notification or other automation based on whether or not an attachment was added. I've noticed that attachment fields do not appear in Rules
                                  • Add QUOTE OWNER profile image to a Quote Template

                                    I can add their email address.. phone number, DOB. I need to add a users profile picture so when they assign a template to a quote they own it adds their picture to the cover page. I've tried hacking a solution together but there has to be an easier way.
                                  • No Response from Zoho Support in 8 Days - Typical?

                                    I have a couple of issues I'm trying to work through. Initially, I was getting support from support@zohofsm.com, but I have not received a response in 8 days (11 on another question). Is this typical? Can I pay for support? For context, I am not spamming
                                  • Age Calculation

                                    I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
                                  • Open filtered deals from campaign

                                    Do you think a feature like this would be feasible? Say you are seeing campaign "XYZ" in CRM. The campaign has a related list of deals. If you want to see the related deals in a deal view, you should navigate to the Deals module, open the campaign filter,
                                  • Change scheduling emails time

                                    When sending an individual email there is a great feature to schedule them to send later. I could only use the one time that is suggested. Is there a way to select another time? Regards, Glenn
                                  • Next Page