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

                                  • Tip 14: How to iterate a set of Deluge code a specific number of times.

                                    Hello folks, As you might already know, recursive functions are used to perform a particular action a specific number of times. We had explained this in detail in our Tip #2. Similarly, there is another way in which you can iterate a set of Deluge code 'n' number of times. All you need to do is to create a List and use the For each index task to iterate it for a specific number of times.    Here are a few use cases where this would be useful to you:  To create 'n' number of duplicate records for
                                  • Is it possible to register webhooks in Zoho CRM using API?

                                    Hello, I am trying to register a webhook in Zoho CRM programmatically (using the API). Specifically, I want to register a webhook that is fired when new Contacts are created in the CRM. I was able to setup a webhook using the UI, by creating a rule that
                                  • only lastname as index(?) field in custom module

                                    Hello, I have a small problem. I have created a custom module. The data records are only labeled with the last names. Also in the lookup etc.... It's stupid if you have different first names with the same surname. Then I only ever see the surname. In
                                  • Can't set conditional layout rule on lookup field in Zoho CRM

                                    Namaskaram Zoho CRM team,      Usually any fields of module except mandatory fields can be hide using conditional layout rules.  But that can't be set on lookup fields event that is not a mandatory fields.  Many users are in need of that.   Crafted with
                                  • Restrict Zoho One Account Notifications to Admins

                                    Hi Zoho One Team, I hope you're doing well. We recently noticed that end users are receiving administrative pop-ups in Zoho One, such as the DKIM configuration notice (screenshot attached). This type of notification is only relevant to administrators
                                  • All about Users in Zoho Projects

                                    To form a functional team, businesses should define different types of users in their team. Businesses can be effectively managed by inviting users to various roles. And, the person who has the administration privileges can invite or add users to various roles in the project. Two types of users Before going into the steps to add users to your portal or project, let's understand the different types of users:  Portal Users - Users who work for the projects in your team.                      ~ Portal
                                  • Announcing Kiosk 1.1 - Customize screen titles, configure new fields & actions, use values from your Kiosk to update fields, and more.

                                    Hello all We are back again with more enhancements to Kiosk. So what's new? Enhancements made to the Components Add titles for your Kiosk screens and adjust its width to suit your viewing preferences. Three new fields can be added to your screen: Percentage,
                                  • Cannot associate event with other objects when creating?

                                    I am attempting to associate an Event with one or more other objects when creating it via the API. According to the API docs, the "Related_To" property is a jsonobject even though the description says "Provide the details about the entities the event
                                  • Missing Payload Details

                                    Hi All, Does anyone know how to fix missing webhook payload data in the next step of the flow? Payload comes into the webhook -- All details here When i go to use the webhook data in the next step -- the majority of the payload data is missing
                                  • Zoho Projects API 100 requests/2 min. Limit

                                    Hi Requesting clarification on the API documentation. "You can invoke or call an API for 100 times in a span of two minutes. If you invoke more than 100 times, the particular API request will be locked for the next 30 minutes. " Does this limit apply
                                  • Customer address in Zoho Bookings

                                    Hello,  Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps.  It would also be advantageous for the "list view" to show appointment times instead of just duration and booking
                                  • AutoScan Not Working Since April -Support says it with engineering

                                    Hi there, Autoscan has not been working on my account since April. Without this feature, completing expenses reports is laborious and error-prone. I keep asking for updates seeing as this is a critical feature, but told that it's being looked into and
                                  • Calendar Connection Enhancement

                                    Hello everyone, Greetings from the Bookings team. We're here to announce an important Calendar enhancement that will roll out soon. Let's take a look at what's being changed. Improved and more straightforward UI The Calendars UI is undergoing a complete
                                  • Bookings to CRM - New Events and Contacts

                                    Hello, I have an issue with appointments taken by clients from a Zoho Bookings page. Previously when an appointment was reserved, if there were no client created in Zoho CRM, it would create it in the CRM through the integration between both platform.
                                  • Generating Discount Coupons for Zoho Bookings

                                    Hi, Is there provision to generate Discount Coupons for appointment bookings? I could not see that in the settings and this is very much needed. Please suggest us. Thanks
                                  • Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

                                    Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
                                  • When will Sales Order and Invoice Synchronisation with Zoho CRM be Available?

                                    When will Sales Orders and Invoices, created in Zoho Books or Inventory be made available in Zoho CRM? John Legg Owner: The Debug Store
                                  • In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote

                                    In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote Pls help how i fix this
                                  • Multiple Products on Ticket

                                    Good morning. We will classify all tickets based on the product. Users sometimes send different requests on the same ticket, so we are facing some challenges. Is there a way to add more than one product to the ticket, or is there a way to tie the product
                                  • Desk - CRM Integration: SPAM Contacts (Auto Delete)

                                    SPAM contacts is a useful feature, but when the CRM sync is used, it is very frustrating. When a contact is marked as SPAM on Desk, I wish to do the same on CRM. When a SPAM contact is deleted, I would like it deleted from CRM. The feature looks half-baked.
                                  • Date Import Problems

                                    I'm trying to import products from csv/xls files, but I can't get the Sales Start Date field to import. I know the import is working because all the other information is imported, but the Sales Start Date field is left empty. I think it must be a format problem. The date format I am trying to import is DD/MM/YYYY. This is also how my date preferences are set up in Zoho CRM. Do I need to use a different format to import the date field?
                                  • Surely it's time Inline editing from views

                                    I think the first request I found for in-line editing from grids was approximately 12 years ago - that post was locked because it was suggested Zoho sheetview solved the problem. However, it's now 2024, and in-line editing from grids is just a basic expectation.
                                  • How to work with getFieldNames formdata functions ,Any Examples

                                    I don't find any example showing usage of getFieldNames. Where do i find .is there any Help documents available
                                  • Allowing subqueries in FROM clause

                                    When building a Query table in Zoho Reports, I encountered an error when attempting to put a subquery in the "FROM" clause of my statement.  Why isn't this currently supported?  Is there a plan to implement this functionality in the future?
                                  • New features and improvements in Desk's integration with Zia powered by GPT 

                                    Hi everyone, We’re pleased to announce several new enhancements in Zia Powered by GPT integration. These updates bring more customization options, improved response generation, and additional language support. Below is an overview of the enhancements
                                  • Is Zoho Shifts included in the Zoho One plan?

                                    In case the answer is no: there's any plan to make it available via One? Thank you
                                  • Feature Request: API Access for Managing Deluge Functions (with OAuth & Change Tracking)

                                    Hi everyone, I wanted to share a thoughtful request that came in from one of our Zoho clients this week. I believe many of us as partners and developers might relate to it. “One quick item to flag: we’d love an official way to manage Deluge functions
                                  • No more IMAP/POP/SMTP on free plans even on referrals with NO NOTICE

                                    Outraged. Just referred a colleague to use her domain (not posting it publicly here) to Zoho, just as I have other colleagues, clients, friends. Expected the exact same free plan features as I have and as everyone else I ever referred got. I was helping
                                  • Mac Thunderbird zoho e mail account issues

                                    I have issues with a user account on thunderbird e mail client who suddenly does not receive emails, when you click get messages we get an error "sending of password for user ......did not succeed, mail poppro.zoho.com responded service unavailable" after
                                  • PASSWORD

                                    Hello, I'm Joyce, my client used zoho for password sharing, he did share the canva but once I clicked on it it will not automatically log-in, instead I need to log-in again. My question is my boss log-in first to his gmail and use his gmail to log-in
                                  • Products in time entry

                                    Morning, Is there a way to add the product field to the time entry layout? Giving us the ability to identify a product per time entry. Thanks Rudy
                                  • Kaizen #195: Frequently Asked Questions on Bulk Read API and Bulk Write API

                                    × 🎉 Nearing 200th Kaizen Post – We Want to Hear from You! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights help us improve! Got Ideas? Tell Us! ✨ We are thrilled to be nearing the 200th post
                                  • admin problem

                                    i can't to reach for the panel that i will create another mail to our company account i have admin access but i can't reach the panel our Company name Scale point my mail asmaa@dcalepointhub.com please can you help me Thanks
                                  • 554 5.7.1 : Recipient address rejected: user [username] does not exist

                                    Hi, I mistakenly altered my shopify email settings (where my domain is managed), but immediately reverted them, however now I have a strange email issue. I can send emails just fine, but cannot receive them. I have tried all troubleshooting steps but
                                  • Problema para enviar y recibir correos

                                    Buenos días, mi cuenta de correo secretaria@construccmauro.com presenta problemas y no me permite ni me envía ni recibe correos, me sale este error.No fue posible enviar el mensaje; Motivo: 554 5.1.8 Correo electrónico bloqueado saliente.  Aprende más., Agradezco
                                  • Agent working hours

                                    Hi, I know it is possible to set company business hours but is it possible so that agents can have different ones? I.e. some agents cover later hours on specific weeks - can these be set so those agents that are "working" get notified about tickets etc. 
                                  • Legit email address?

                                    Hello, I received emails from zohoadmin@biznetvigator.com with a password expiry notice. is that a legitimate email?
                                  • SMTP Authentication Fails with App Password – “535 Authentication Failed” Error

                                    Hello, I'm trying to send transactional emails from my WordPress website using the WP Mail SMTP plugin with Zoho Mail (smtp.zoho.com on port 465 with SSL). I've created and used a Zoho Mail app-specific password for SMTP, and verified that: The email
                                  • Deluge script issue : Mismatch of data type expression. Expected BIGINT but found STRING

                                    I'm building a Zoho Creator form to take inputs for Email, Bootcamp Name, and Tag. If a record with the same Email + Bootcamp exists in a custom module (bootcampattendence), I want to update it by adding a new tag. If it doesn’t exist, I want to create
                                  • how to integrate zoho bigin to wordpress website ?

                                    hello , i want to integrate zoho bigin to wordpress webiste , can anyone help me with the tutorial ?
                                  • Next Page