Tip #01: Using conditions to tailor-fit your document content for a wider audience

Tip #01: Using conditions to tailor-fit your document content for a wider audience

Why create multiple documents with similar content when you could do that with just one? By inserting conditions to documents, you can easily control how your document content is shown to multiple recipients.



Let's consider the below scenario.

Tom, an HR has just finished interviewing 200 candidates, out of which 50 were selected for the next round. It's his duty now to send all 200 candidates personalized mails informing them if they were selected or not.

How would he prepare 200 personal mails at once?

Answer: By setting conditions.

Using conditions, you can easily tailor-make multiple personalized documents at once—by using both fixed and dynamic content.


Here's how you can do it as well:

1. Open the template document.






2. Go to More Options > Automate tab > Merge using existing data > Select data source.

3. Choose the data source from where you'd like to import the candidate information from. In Tom's case, he chose the Candidate Selection List from Zoho Sheet (this contains the candidate details and their respective selection status).





4. Place the merge fields from the spreadsheet across your document.


Now that the fields have been merged, Tom has to set conditions.


5. In the Merge Existing Data panel, click on the Conditions link under the Insert Fields header.





6. The Insert Condition pop up will open. Since he's applying the condition based on candidate selection, choose the Selection Status field from the drop down and specify the Contains option as "Yes"

7. Click Insert to apply the conditional field in the template.

      
                       




The condition when inserted to the document will look like this:





8. Add your "if" condition text. In this case, it'll be informing the candidate that they've been selected for the next round. This will  be shown to all the candidates who've been marked as selected in the spreadsheet. Similarly, you can also set an "else" condition text, probably letting the candidate know he/she has not been selected. 




9. Now click on Preview Merge to see how the document would look like after merging.


    

Tom now has 200 personalized copies for each candidate and all he had to do was prepare one common template. 

Click here  to learn more about conditions in documents.


Happy writing!





Found this helpful? Subscribe to  Writer Community  for more tips and tricks.









      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

                                  • Option to select location?

                                    As a business coach, I meet with clients at various public locations. I have two or three pre-determined locations that I meet at. I would like the client to choose the location when booking an appointment. Is there a way to do that with a single service, or is the best way to accomplish this by creating one service for each location offered?
                                  • Time entry preview for custom time entry templates.

                                    Our company needed time entries in a specific format to document our client interactions. Since we are using a custom time entry layout, we have lost the "preview" on the time entry tab. Using the default time entry layout, you get a small preview of
                                  • Retainer invoice in Zoho Finance modlue

                                    Hello, Is there a way of creating retainer invoices in the Zoho Finance module? If not can I request this is considered for future updates please.
                                  • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

                                    Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers
                                  • Provide a standard structure to your content using article templates

                                    Hello everyone, When multiple writers work on different documents, maintaining a standard structure can be challenging as each of the writer follows a different writing style. However, when the structure, tone, and format of every document is different,
                                  • How to update custom multi-user field in Zoho Projects?

                                    I'm trying to update custom multi-user fields in Zoho Projects via a Deluge function in CRM. The code I have so far is below. It works for updating standard project fields and single-line custom fields, but it does not work to update multi-user fields.
                                  • Accessibility Spotlight Series - 1

                                    Every user interacts with products differently, what feels intuitive to one may be challenging for another. Addressing this, accessibility is built into Zoho Project's design philosophy. This helps users navigate and perform actions with ease irrespective
                                  • Projects Tasks Not Showing Dependencies

                                    I'm clicking on tasks and the popup to add dependencies isn't showing. I can't disconnect the nodes either. For some reason when I slide a task backwards it says it cannot go before a predecessor, even though there is not predecessor. Double clicking
                                  • ENTER key triggering Submit

                                    Is it possible to stopped the ENTER key from the mandatory triggering of the Submit button on Creator form? I want forms submitted "ONLY" when the Submit button is pressed. 
                                  • Deprecation of C4 endpoint URLs

                                    Note: This post is only for users who are still using the C4 endpoints. Hello everyone, At Zoho Creator, we're committed to continuously enhancing the security, performance, and capabilities of our platform. As part of this ongoing effort, we'll be deprecating
                                  • Introducing AWS authentication for connections in Deluge

                                    Hello everyone, We're incredibly excited to announce the all-new AWS authentication for connections in Deluge! This highly anticipated feature simplifies connecting to Amazon Web Services, opening up a world of possibilities and allowing you to seamlessly
                                  • Timeline Tracking Support for records updates via module import and bulk write api

                                    Note: This update is currently available in Early Access and will soon be rolled out across all data centers (DCs) and for all editions of Zoho CRM. The update will be available to all users within your organization, regardless of their profiles or roles.
                                  • Paste issues in ZOHO crm notes

                                    Hi, since a week or so I have issues with the paste function in ZOHO CRM. I use "notes" to copy paste texts from Outlook emails and since a week or so, the pasting doesnt function as it should: some text just disappears and it gives a lot of empty lines/enters.....
                                  • Bug Report and Suggestions for Improvement in Zoho Applications

                                    Hi Zoho Team, I’d like to report a few bugs and improvement suggestions I’ve noticed while using Zoho products: Zoho Cliq Video Call: The camera sometimes turns off automatically during video calls. This seems to be a bug — please check and fix it. Zoho
                                  • Customize User Invites with Invitation Templates

                                    Invitation Templates help streamline the invitation process by allowing users to create customized email formats instead of sending a one-size-fits-all email. Different invitation templates can be created for portal users and client users to align with
                                  • Zoho CRM Workflow and Function Backup Options

                                    Hi everyone! I have been able to make several backups of my CRM data and noticed that the Workflows and Functions are not included in these backups. To my knowledge, there is no backup feature for workflows and functions, which is problematic in of itself.
                                  • ListObjects is recognized by VBA

                                    Sub addNewRow() Dim ws As Worksheet ' Set your worksheet name Set ws = ThisWorkbook.Sheets("Invoice") ' Set your table name (change "Table1" to your actual table name) ws.ListObjects("InvItems").ListRows.Add End Sub I am getting Unknown function: Li
                                  • KPI Widget dashboard select periods

                                    I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects
                                  • Need a way to secure Prefill URLs in Zoho Forms (hide or encrypt prefilled values)

                                    Hi everyone, I often use Zoho Forms with prefilled URLs to simplify the user experience — for example: https://forms.zohopublic.com/.../form?Name=David&Amount=300 However, the problem is that all prefilled values are visible and editable in the link.
                                  • Can’t send emails from Zoho CRM after adding a new user — verification codes not received

                                    Hi everyone, We recently added a new user to our Zoho CRM account and purchased an additional license. Since then, we haven’t been able to send any emails from Zoho CRM. Our Zoho Mail accounts are working perfectly, we can send and receive emails directly
                                  • Can I add Conditional merge tags on my Templates?

                                    Hi I was wondering if I can use Conditional Mail Merge tags inside my Email templates/Quotes etc within the CRM? In spanish and in our business we use gender and academic degree salutations , ie: Dr., Dra., Sr., Srta., so the beginning of an email / letter
                                  • CRM for email in Outlook: how to ignore addresses?

                                    We’re using the "Zoho CRM for email" add-in for Outlook. When opening an email, the add-in displays all email addresses from the message and allows me to add them to the CRM or shows if they’re already contacts. However, sometimes people listed in To
                                  • Scheduling Calls in CommandCenter / Blueprints

                                    I would love it if you could add a function to schedule a call in the lead's record for a future date. I know you can add a Task by going to Instant Actions > Task and completing the form: These tasks go into the lead's record under Open Actions. But
                                  • Workflow Creation with Zia gets stuck

                                    It gets stuck here:
                                  • Quickly send emails and sync conversations with custom email addresses in CRM

                                    Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all
                                  • Zoho製品と生成AIツールの活用について

                                    いつもありがとうございます。 弊社では、Zoho Oneを契約し、CRMを軸として、見込み客の管理から商談、その後の受注や請求の管理、サポート業務(Desk)、業務データのレポーティング(Analytics)などを行っております。 Zohoサービス自体には、Ziaというツールが搭載されているかと存じますが、それ以外の外部の生成AIツールと連携した活用などもできるのでしょうか?具体的には、CopilotなどがZohoに登録されているデータや情報を見て、対話型で必要なデータを提示してくれたり、商談や蓄積されたメモなどを分析してユーザが知見を得られるような活用ができないか、と考えております。
                                  • File Field Validation

                                    Hello all, We are tracking our customer NDA agreements in our CRM and have created 2 fields to do so, an execution date field and a file upload field. I want to create a validation rule to ensure that when the execution date field is populated that the
                                  • Work with Contacts who use multiple Emails / Manage obsolete Email addresses without loosing Emails in Context

                                    Hello List Work with Contacts who use multiple Emails Only after 1 week in using Zoho CRM productively we have contacts which randomly use 2 different email addresses. From the concept I've understood that Zoho CRM offers two email fields which are recognized
                                  • Categorise Attachments

                                    We take ID, proof of address, right to work documentation and more.  I can upload a single file in to field, but we often receive multiple files for each category e.g. someone may send a separate file for the front and back of their national ID card.  My team don't have time to manipulate the files in order to upload them as a single file. The options, as far as I can tell, would be to create additional fields on attachments in order to categorise what the file is, or to be able to upload single
                                  • Subforms in Stateless Forms

                                    Stateless Forms are very useful, but we can't build complex data entry pages without Subforms. Can this be implemented? This would make Stateless Forms truly powerful.
                                  • New Field in CRM Product Module Not Visible in Zoho Creator for Mapping

                                    I created a new single-line field in the Products module in Zoho CRM. Zoho CRM and Zoho Creator are integrated, but the newly created field in CRM is not visible in Zoho Creator when I try to map fields.
                                  • Send WhatsApp voice messages from Bigin

                                    Greetings, I hope all of you are doing well. We're happy to announce this enhancement we've made to Bigin. Bigin's WhatsApp integration now supports audio messages, so you can record and send voice messages. This makes it easier to handle customer questions
                                  • Microsoft Teams now available as an online meeting provider

                                    Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings
                                  • I want to subscribe 1 professional user but the email only 250 per day?

                                    When I subscribe 1 professional user, I am only able to send 250 email per day? So less? Or is it typo, 2500 rather than 250? Any sale agent or friends can clear my doubt? Thank You
                                  • Cliq does not sync messages after Sleep on Mac

                                    I'm using the mac app of Cliq. When I open my mac after it was in sleep mode, Cliq does not sync the messages that I received. I always have to reload using cmd + R, which is not what I want when using a chat application.
                                  • How to add a % Growth column for year-over-year comparison (2024 vs 2025)

                                    Hello, I am trying to build a monthly revenue comparison between 2024 and 2025 in Zoho CRM Analytics. My current setup is: Module: Deals (Affaires) Filter: Stage = Closed Won Date field: Closing Date Grouping: By Month Metrics: Sum of Amount for 2024,
                                  • How do you map a user picklist field to another user picklist field.

                                    In Zoho Projects, I'm trying to map a custom field (user picklist) in Task Details to a field (user picklist) in the Project Details. How do you get the two to map to each other? This is what I currently have that works for my other fields but doesn't
                                  • Explore Competitive 3D Scanner Prices at Protomont Technologies

                                    The genesis of Protomont Technologies emerged from the collaborative efforts of the founders in 2019, both the founders shoulder an enormous experience in the world of 3D Printing. Protomont Technology aims to craft your vision with creativity, empowering
                                  • Send Whatsapp message from Whatsapp template with custom variables

                                    Hi, I'm trying to do some basic integration for sending WhatsApp messages from Zoho CRM using Zoho Desk whatsapp templates. When creating new whatsapp template in Zoho Desk we can choose ticket related fields as variables but it's not clear how to use
                                  • New and improved API resources for Zoho Sign Developers

                                    Hello, Developers community! We know that for you, an API's real value depends on how quickly, easily, and reliably you can integrate the it with your application. That's why we're excited to talk about the recent improvements to our developer resources,
                                  • Next Page