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.










      • 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