Introducing group by, aggregation, and repeating regions in mail merge templates

Introducing group by, aggregation, and repeating regions in mail merge templates

Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates.

We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now fetch data from any data source, including Zoho CRM, Bigin, and Creator, and present them in an easily understandable form in just a few clicks.

Here's how you can enhance data presentation using group by, aggregation, repeating regions, and data transformation.

Let's understand these new capabilities and how to use them in detail. To make this easier, let's take a look at how Zylker Automobiles, an imaginary car manufacturer, uses the new group and loop options to easily present their data in different ways.

1. Visualize data with group by for easy and quick understanding.

Business case: Generate a master pricelist with the state-wise price of all car models.



Zylker Automobiles' sales admin uses group by and repeating regions to display the price list for all car models separately for each state whenever the prices of their cars are changed.

Group by helps you to group data based on a specific field or value. With repeating regions, you can configure the layout/table/row only once and dynamically expand it based on the volume of data, instead of manually expanding it. Click here for the detailed steps to use the group by function.

Watch this video to learn how to use the group by, aggregation, and data transformation capabilities in your mail merge templates.

2. Summarize data to highlight key aspects and insights.

Business case: Generate the monthly revenue report with country-wide and region-specific revenue summaries and breakdowns.


You can use the aggregation functions to summarize a large chunk of data to glean important insights like maximum, minimum, count, average, and sum.

Zylker Automobiles' sales admin combines the power of the built-in group by, aggregation, and repeating regions to highlight the:

  • Total revenue generated in a month.
  • State-wise total revenue with a breakdown of revenue from each category.
  • Granular, item-wise breakdown of revenue for each category for every state.

Click here to learn how to use the aggregation functions.

3. Transform data to create and populate sub-forms.

Business case: Generate and save the detailed revenue report of each state as a separate file in a specific folder.



Zylker Automobiles uses data transformation to map the desired fields in the data source as main and sub-form fields. This allows them to extract and process the raw, unordered transactional data to generate the revenue report for each state separately. Click here to know how to use the Transform Data Source option.

4. Format data with the new number-formatting options.

Business case: Send an email to each SDR at the beginning of every month with their total revenue from the previous month in words, along with a summary of their performance.

​

Zoho Writer has added new formatting options exclusively for numbers. With these, you can now convert a number to text, ordinal number, ordinal text, and ordinal year.

The Zylker Automobiles sales admin uses the new Number to Text formatting option to convert and display numbers as texts in email that they send to their SDR every month.

Try the group by and aggregation functions in Writer's mail merge templates, and let us know your feedback. You can also watch this video to understand how to use these features to elevate your documents.

If you need any assistance or have any questions in configuring the group by, aggregation, or data transformation operations, please write to us at support@zohowriter.com or add a comment below.

Happy merging and data visualizing!


      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

          • Easily perform calculations using dates with the new DATEDIF function

            Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

          • Date-based conditions and filters

            Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the

          • Introducing group by, aggregation, and repeating regions in mail merge templates

            Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now

          • Say hello to an improved way to merge documents!

            Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.   If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers

          • Introducing Org Fonts in Zoho Writer

            Hey Zoho Writer users! We're excited to share that you can now add custom fonts (from web fonts with publicly accessible URLs) using Zoho Writer's Org Fonts. This option allows all users across your organization to use the custom font without the hassle

          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

                                  • Why am I getting event Pop-up Notification for events that have been cancelled?

                                    Why is Calendar Notification still popping up for events that have been cancelled or changed? Each time events are cancelled or changed, I have observed that I am still getting notifications for them. Below is a sample pop-up notification for one of the

                                  • Whatsapp Limitation Questions

                                    Good day, I would like to find out about the functionality or possibility of all the below points within the Zoho/WhatsApp integration. Will WhatsApp buttons ever be possible in the future? Will WhatsApp Re-directs to different users be possible based

                                  • Create a draft in reply to an email via Emails API

                                    Hi, I’d like to use the outgoing webhook to automatically create a draft reply to incoming mail. How can I use the Emails API to create a draft reply that is linked to an existing email thread? I couldn’t find the relevant method in the documentation.

                                  • India Tech Support

                                    Is there no phone tech support number for India? And no chat facility either?

                                  • Billing Management: #1 Billing an Universal Business Routine

                                    Hello, As the saying goes, "Do the hardest job first", we started with the complex subject in finance, revenue management, which is considered to be the backbone for any business. Now, let's shift our focus and take a deep dive into this Billing Management

                                  • Show/ hide specific field based on user

                                    Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just

                                  • What is a a valid JavaScript Domain URI when creating a client-based application using the Zoho API console?

                                    No idea what this is. Can't see what it is explained anywhere.

                                  • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

                                    ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 ▷▷参加登録はこちら：https://us02web.zoom.us/meeting/register/6OSF2Bh6TumsMIlDwaY_PQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho

                                  • Zoho Calendar not syncing correctly with personal Google Calendar

                                    Coming to this forum as Zoho Calendar support team is not responding, any more. For the past 8 weeks, I have been having an issue with Zoho Calendar not syncing with my personal Google Calendar correctly. I subscribed to Zoho Calendar iCal in my personal

                                  • Introducing Assemblies and Kits in Zoho Inventory

                                    Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the

                                  • Customer Parent Account or Sub-Customer Account

                                    Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, they

                                  • need a packing list feature

                                    In our business, goods listed on an invoice are packed in separate boxes and shipped off. for e.g. an invoice may have 10 items. each item could then be packed in different boxes depending on qty of each item. this packing list is as important as the invoice for purposes of shipping documents.  Request you to add this feature asap.

                                  • Prevent stripping of custom CSS when creating an email template?

                                    Anyone have a workaround for this? Zoho really needs to hire new designers - templates are terrible. A custom template has been created, but every time we try to use it, it strips out all the CSS from the head.  IE, we'll define the styles right in the <head> (simple example below) and everything gets stripped (initially, it saves fine, but when you browse away and come back to the template, all the custom css is removed). <style type="text/css"> .footerContent a{display:block !important;} </style>

                                  • Workdrive 5.0 / API Documentation Workflows

                                    Hi Zoho, When will the API documentation of the workflows be published? We are interested in using it to trigger manual workflows from an external application. Greetings, Justin

                                  • How to keep track of bags, cans, drums of inventory?

                                    We buy and sell products that are packaged in bags 🛍️, cans🥫, drums🛢️, etc. with batch numbers. When we get a shipment of one of the products, how do we track we received (say) 10 cans each of 5L of a product and maybe we received 10 cans of another

                                  • Zoho Error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details

                                    Hello There, l tried to verify my domain (florindagoreti.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details. Screenshot Given Below -  please check what went wrong. Thanks

                                  • How many ZOHO-Sites does the ZOHO-One Suite allow for?

                                    The free version of ZOHO-Sites allows for two sites, but it seems that the professional version (which is included in the ZOHO-One Suite) only allows for two websites. Is that correct? How many sites can I have within one ZOHO-One account?

                                  • Replace Lookup fields ID value with their actual name and adding inormation from subforms

                                    Hi everyone,  I wanted to see if someone smarter than me has managed to find any solutions to two problems we have. I will explain both below.  To start we are syncing data from Zoho CRM to Zoho Analytics and I will use the Sales Order module when giving

                                  • Having Trouble Opening The Candidate Portal

                                    Recently am having trouble opening the Candidate Portal. It keeps loading but cannot display any widgets. Tried Safari, Chrome and Edge. Non of them work. Please solve the problem ASAP.

                                  • Webhook from Zobot to Zoho Flow fails

                                    I'm trying to connect from zobot to zoho flow. When testing in zflow, I am receiving all entered data from the connector correctly. The SalesIQ connector's "outputreaction" is {} (is this normal or is there a problem?). But as soon as I try my chat bot

                                  • Transition from Sole Proprietorship to GmbH (Limited Liability Company) – Best Approach in Zoho Books / Zoho One

                                    Hello everyone, I am currently operating under a Zoho One plan with a sole proprietorship in Switzerland. As of January 1st, 2026, I will be incorporating a new legal entity – a GmbH (Swiss equivalent of a Limited Liability Company). While the business

                                  • Best way to display complex Bookings Consultation Descriptions on Zoho Site?

                                    I am a new user so apologies if this has been asked before. I couldn't find any answers in the forum. We offer 18 complex Consultations to our subscribers. Our current platform lets me put detail on these Consultations thoroughly (200-300 words) during

                                  • DKIM cannot be enabled for the domain as no verified default selector present

                                    Hi Support Team, For Domain DKIM record trying to enable status. but showing error "DKIM cannot be enabled for the domain as no verified default selector present" So, please resolve the issue. Thank you.

                                  • Issue Connecting My Domain to Zoho Sites Despite Purchasing It from Zoho

                                    Hello, I am facing an issue connecting my domain to my website on Zoho Sites. Details of the issue: I purchased the domain directly from Zoho. I am already using the same domain successfully with Zoho Mail. However, when I try to assign this domain to

                                  • Insert auto number from main form into subform rows

                                    Hello. I'm trying to take from my main form "order number" which i have setup as an auto generated number into every line created in my subform. So when a row is created in my subform i want the "order number " from the main form to be inserted automatically.

                                  • Dark Mode - Font Colors Don't Work

                                    When editing a document in Dark Mode and selecting font colors, they don't show up on screen.  Viewing/editing the same document in Light Mode shows them just fine.

                                  • Integrate Bunq with ZOHO Bookes

                                    We are new users of ZOHO Books, and our bank (BUNQ, in the Netherlands) isn't listed on the bank integrations. Is there a way to handle this?

                                  • Cliq iOS can't see shared screen

                                    Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards

                                  • Access Denied

                                    I am iOS Developer and updating our clients project and shifted ZohoDeskPortalCore SDKs from cocoapods to SPM and changed few lines of code but now i am get access denied, the help center app is unavailable. please contact administrator.

                                  • Using Zoho Desk to support ISMS process

                                    Hi, I am evaluating using Zoho Desk for security incident management. This seems to be aligned with Zoho Desk purpose as its just another type of incident. However in security incident management, ideally I can link incidents (tickets) with a risk from

                                  • Bin Locations

                                    Dear all, I am wondering if someone has the ability to develop the bin locations option for zoho inventory (integrated with zoho books) Regards, Ryan

                                  • TaxJar vs Avalara

                                    Hi, I'm evaluating adoption of a sales-tax service for US based business. Anyone else have experience with TaxJar and Zoho Books? I am a Zoho One subscriber so anticipate needing to use Flow to make this work. It seems like Avalara are simply too expensive

                                  • How to check Leads with no Task (open activity)

                                    Hi everyone, I was wondering if there’s a way to view leads that don’t have any tasks assigned or open activities linked to them.

                                  • What can we do on our end to improve the Answer bot answers?

                                    Hi, I'm using the Answer bot card in the Codeless bot builder. I've input several questions and their answers in the FAQ section to feed the Answer bot. The text is all in French, as this is the language our customers communicate in. I've tried testing

                                  • Zoho Books Sandbox environment

                                    Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a

                                  • Taxes for EU B2B Transactions

                                    Currently, ZC doesn't seem to have a procedure for validating VAT numbers of businesses purchasing in another EU state, and removing local VAT is valid.  This is essential for all inter EU B2B trade.

                                  • How to upload file to Connect using API?

                                    Hi there. I looked at the API documentation and nowhere did it mention how to use the API method to upload a file even though it is mentioned that it is possible to be done so. Please help.

                                  • Items Landed Cost and Profit?

                                    Hello, we recently went live with Zoho Inventory, and I have a question about the Landed Cost feature. The FAQ reads: "Tracking the landed cost helps determine the overall cost incurred in procuring the product. This, in turn, helps you to decide the

                                  • Group Tax in Service Line Items

                                    Hi FSM Team! I noticed that when you update a tax in the service line item the group tax is not showing up as an option. Let me know what can be done thank you!

                                  • Zoho Campaigns - Why do contacts have owners?

                                    When searching for contacts in Zoho Campaigns I am sometimes caught out when I don't select the filter option "Inactive users". So it appears that I have some contacts missing, until I realise that I need to select that option. Campaigns Support have

                                  • Next Page