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 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
    • Recent Topics

    • Optimize your Knowledge Base for better visibility by allowing search engine crawling and indexing

      All you need to know about no-follow and no-index in KB. What are article crawlability and indexability? Crawlability and indexability are vital for making an article visible and accessible to search engines. When a search engine crawls an article, it
    • Create Dashboard with information pulled from multiple modules?

      I am looking to create an overview dashboard for each account we have within the CRM. This will need to include information from Books, Bookings, Analytics (want to see the graphs). I am new to using Zoho but am trying to help streamline our processes
    • CPQ - Price Rules applying to a prodcuts group

      Hi Zoho Team, In Product configurator is possible to make a rule where you can select "Any product" and set an "aditional condition", thanks to this we can apply a rule to group of products. In case of Price Rules, when I make a Rule for Any product is
    • Zoho Creator Upcoming Updates - December 2024

      Hi all, We're excited to be back with the latest updates and developments on the Creator platform. Here's what we're going over this month: Deluge AI assistance Rapid error messages in Deluge editor QR code & barcode generator Expandable RTF and multi
    • Waterfall Chart

      Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?
    • Add "Merge by Ticket ID" Option on Ticket Screen

      Dear Zoho Team, We would like to request a new feature for the ticket interface in Zoho Desk. Specifically, we propose adding a button to the ticket screen that allows users to merge the current ticket with another ticket by directly providing the second
    • Problem when condition with lookup field in Zoho Creator

      this is my code: if input.promotions1 != null { info input.promotions1; } And this my result: when i info input.promotion1 (which is a lookup field), it turn back nothing, so what type of this field is? normally i use the condition: if lookup_field ==
    • Dialing Microsoft Teams Phone Service via Zoho CRM

      I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone
    • What's New - January 2025 | Zoho Backstage

      Hi there! As we step into a brand-new year, we’re thrilled to bring you some exciting updates to make event management more enjoyable and efficient. Here’s what we rolled out in January to kick off 2025: Backstage 2.0 now enforced for all users We've
    • Hide/Remove Zia search bar in Mobile app

      How do i hide the Zia Search button " Search across Zoho apps " in the app?
    • Importing Attendees- Excel

      I would like the ability to import attendees using an excel file. Sometimes groups, such as schools have to sign up attendees through there system and then send my organization an excel spreadsheet. Right now there doesn't seem to be a way to import those attendees. If Backstage can export to an excel file it seems like a no-brainer that one would be able to populate that template and import attendees into Backstage.
    • Issue with Attachments in "Email a Thank You Note"

      Greetings, from a few days ago, when registering a new payment and clicking on 'email a thank you not for this payment', Zoho Books does not send anymore my attachments on this email, as before. It is very important to us, once here, we have to send another
    • Zoho CRM Kiosk Upload Files

      Hello all, We are trying out Kiosks at the moment to see where it can fit best in our business. We are still a bit off in the application but lets say we will sort this out. My question is the following - when I create a Kiosk I can add "File Upload"
    • How to add new row in a custom SubForm using Deluge Code in Deal Module

      Hi, Can someone help me with Deluge code to add a new row with data in a custom Subform in a Deal Module. Thanks, Shatakshi Misra
    • CASE Module - email function

      HI there, I dont know if this has been asked or answered before as i couldnt find it on the forums. Issue: when a new case is raised, it goes under case tab and everything is captured. Then how do i send emails to the client who raised case with the details
    • Effortlessly advance through your CRM blueprints by including optional fields in transitions

      Editions: Professional edition and above DCs: All Release plan: This enhancement is being released in a phased manner to customers. It will soon be available to all users. [Updated on 5 Sep 2024] This enhancement has been released to all users in all
    • Zoho CRM - Conditional Assessment for Blueprint Automatic Transition

      Hi, Currently, in Zoho CRM’s Blueprint process, the Automatic Transition feature does not allow for conditional assessments before execution. This limitation significantly impacts workflows where a transition should only occur when certain predefined
    • How can you re-push non failed submission through the integrations again?

      Hi, I can see there is an option the 'Re-push' failed integration submissions from Zoho Forms. Is there a way to do this for all submissions? We've just re-built an integration so things go into different fields and we would like to re-push everything
    • Request for Assistance: Firewall Configuration for ManageEngine Cloud Access

      Dear ManageEngine Support Team, I hope this email finds you well. We have encountered a technical case and would appreciate your assistance. Below are the details of the current configuration and the issue we are facing: 1. Current Configuration: • We
    • List of API for report

      Can I have list of API for Reporting ? Like this API : https://www.zohoapis.com/books/v3/reports/customerbalances?organization_id={{Organization.Organization_ID}}&accept=pdf
    • How to add row numbers to Subform?

      How to I auto row number rows of a subform in CRM?
    • Zoho Books | Product Updates | January 2025

      Hello users, Now that January is over, here are some exciting updates to make this new year even better. We’re back with new features and enhancements in Zoho Books, including comparing fields as criteria in workflow rules and a custom SMTP integration.
    • Python Code: Calling "Deals" API results in 404 Error.

      Good evening, I wrote a small python code to scrape the data from a selected record and then copy the information I need into another website. We have renamed the "Deals" module to "Opportunities", however the API name remains as "Deals" which is fine.
    • How to change contact record owner to its creator?

      When I convert a lead record into a contact and a deal then a the contact record will have User AAAA as record owner, and the contact record will have User XXXX as the record creator. I don't have any workflow rules in Contact module. I use the blueprint
    • How to merge duplicate products?

      merge duplicate products
    • Function to update field in CRM Meetings from Bookings Appointment Status

      Hello, We're creating some reporting in Zoho Analytics using data from CRM and Bookings. Unfortunately it looks like when Bookings Appointments are carried over to CRM Meetings, the Bookings Appointment Status is not recorded in CRM Meetings. We would
    • Unresponsiveness in Zoho Cliq

      Time of post: 6:56 am PDT, 19 July 2023 Dear Cliq users, We have encountered an unprecedented issue in our messaging servers. The details of the issue are as follows: Impacted users : 1/4th of users in US DC (users who access cliq services through cliq.zoho.com)
    • Importing Tasks : Where is the flexible work hours field ?

      I need to be able to import a years worth of flexible hours for our part time workers, but I can't find what field to import to. When I do an export, there is nothing that signifies Standard/Flexible and whenever I import it automatically sets it to Standard...
    • Zoho CRM Calendar View

      Hello Zoho team, We need desperately a calendar view next to list, kandan and other views. I think it should be easy to implement as you already have the logic from Projects and also from Kanban View in CRM. In calendar view when we set it up - we choose
    • Attendance Over-writing of Leave

      Hello Zoho, Currently if an employee comes to work while they have applied for leave, the system considers them as "on leave". Shouldn't the employee be marked as "present". Give it a thought
    • Inadequate Customer Support

      Hello & Greetings! I have been a pro Zoho user since the last 2 years and I would admit that the apps that are being offered are good, however the support we receive has a lot more to achieve. This being a design issue rather than a staff issue. Being
    • Enhancements to the formula field in Zoho CRM: Auto-refresh formulas with the "Now" function, stop formula executions based on criteria, and include formulas within formulas

      Dear Customers, We hope you're well! By their nature, modern businesses rely every day on computations, whether it's to calculate the price of a product, assess ROI, evaluate the lifetime value of a customer, or even determine the age of a record. With
    • Zoho Analytics - Values gets Duplicated

      In Zoho Analytics, I have two tables: one for Country-wise Sales and another for Country-wise Budget with Region. I am attempting to create a stacked bar chart to compare the Region-wise Budget and Sales Revenue. I have set up a lookup between the two
    • Does Zoho US Payroll now support employees in multiple states?

      Does Zoho US now support having employees in multiple US states? I looked at the site and can't find and of the restrictions on multiple states anywhere.
    • Zoho Mail not fit for business

      How are businesses using Zoho Mail? In Zoho Mail: You cannot create subfolders in a shared mailbox You cannot add a second email account eg. a non-Zoho account that could then provide the function of providing a shared mailbox with subfolders In the Trident
    • Client Script | Update - Introducing Subform Events and Actions

      Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce
    • Linking module does not allow Subforms

      The title says it all: I don't know why this is the case, but I start to hate the system and regret my decision of implementing it across our whole organization because of all the limitations we are facing. What should we do now?
    • Additional step for Deleting an app

      Have an additional step for deleting an app. When the popup occurs, the user needs to write "DELETE" into a text field. This is what Google does. At the moment, it is too easy to Delete, which increases risk, and this should be easy to implement.
    • Enhancement - P&L Statement and Balance Sheet

      Hi there!   Providing an option to compare financial statements from different quarters was one of the most requested features in  the recent times . We're more than excited to have come up with a solution - a  Comparison  feature for P & L Statement and Balance Sheet.   Profit and Loss Statement and Balance Sheet provide you with  a clear picture of   the 'hows'  your company can generate more revenue or cut down on costs and what you own and owe. But, then having this year's statement compared
    • restrict access to user to create invoice

      hi team we need to restrict particular users from accounts dept to create invoice directly from invoice module in zoho books . Rather , they can only able to create invoice is by using "convert to invoice" from "Sales Order" module . pls help us to solve
    • Next Page