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!

• Topic Participants

• Varadarajan AR

  

• Marcus Longone

• 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:

• Zoho Writer's WordPress extensions

  Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window

• 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

• Recent Topics

• Is there a way to show contact emails in the Account?

  I know I can see the emails I have sent and received on a Contact detail view, but I want to be able to see all the emails that have been sent and received between all an Accounts Contacts on the Account Detail view. That way when I see the Account detail

• The Social Wall: July 2026

  Hello everyone! We're halfway through the year, and we bring to you three new updates designed to help you experiment with your content, discover your top-performing posts, and automate your engagement workflow. Instagram Trial Reels Instagram trial reels

• Mail Id’s backup

  Dear Zoho Team, Kindly share the backup of my all mail id’s associated with Zoho account. Thanks, Saurabh Sharma +91 8851066915

• Recurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps

  We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurring

• Stock Based Sort-by option in Category Pages

  In a category page product with In-Stock should come in the top of the categories product list rather than out-of-stock products. No having this option is extremely disappointing, I made the initial request about 7 months ago but still not even an update

• Stock based sort-by option

  I have more than 300 products in a category with out of stock items count of 150. The out of stock items are coming on top of the category product page list, is there a way to show the in-stock items on top of the list & move the out -of stock items in

• Out of Stock items showing in Commerce

  I have over 6000 items and most are not in stock, but all items are showing up in Commerce whether they are inventory or not. What option or feature can you use to hide items in Commerce at zero or negative quantities? I currently am using Commerce for

• Creating Email template that attaches file uploaded in specific field.

  If there's a way to do this using Zoho CRM's built-in features, then this has eluded me! I'm looking to create a workflow that automatically sends an email upon execution, and that email includes an attachment uploaded in a specific field. Email templates

• What's New in Zoho Billing | July 2026

  July brings a new set of updates to Zoho Billing to make your billing operations more efficient. These include a redesigned checkout experience, expanded Hosted Payment Page capabilities, compliance improvements, enhanced reporting, and more. Enhancements

• Zoho CRM Community Digest - July 2026 | Part 1

  Hello everyone, July is here! The first two weeks brought six CRM updates ranging from privacy-ready webforms to a significantly more powerful Layout Rules engine, two community wins worth a look (a dashboard workaround for spotting leads with no activities,

• What is a realistic turnaround time for account review for ZeptoMail?

  On signing up it said 2-3 business days. I am on business-day 6 and have had zero contact of any kind. No follow-up questions, no approval or decline. Attempts to "leave a message" or use the "Contact Us" form have just vanished without a trace. It still

• Zoho CRM - Email/Message icon for Deal List View

  Hi Team, My idea is to include a message icon at the start of the row of Deals when an unread message has been received. This would really help highlight the Deals where urgent action is required. Thanks for considering this request. Regards, Ashley

• Email notification for followers

  Is there a way to enable email notification for followers of a support ticket? ie: Ticket #123 is owned by Agent#1, Agent#2 adds themselves as a follower. Whenever ticket #123 receives an email from the customer, Agent#1 receives an email. Agent#2 would

• Introducing parent-child ticketing in Zoho Desk [Early access]

  Hello Zoho Desk users! We have introduced the parent-child ticketing system to help customer service teams ensure efficient resolution of issues involving multiple, related tickets. You can now combine repetitive and interconnected tickets into parent-child

• Desk Contact Name > split to First and Last name

  I am new to Zoho and while setting up the Desk and Help Center, I saw that new tickets created or submitted from the Help Center used the Contact Name field. This would create a new Contact but put the person's name in the Last Name field only. The First

• Vendor payment unexpectedly routed through Prepaid Expenses instead of Accounts Payable

  Hello, We are investigating an unexpected accounting behavior in Zoho Books. We created vendor bills and vendor payments for two suppliers using what appears to be the same workflow, but the journal entries are different. Vendor 1 – UZ Store (works correctly)

• Line Spacing

  I am new to zoho writer - when I create a new document or either open an existing document - everything is double spaced. I tried changing the line spacing to single but still nothing happens do you know what I can do to change this double spacing format?  

• LinkedIn RSC is now live in Zoho Recruit

  LinkedIn Recruiter System Connect (RSC) is here. Your Zoho Recruit data (candidates, jobs, notes, stage updates, resume attachments, and more) now syncs with LinkedIn in real time. Note: LinkedIn RSC is included with your LinkedIn Recruiter Corporate

• Managing Shopify Payout Balances in Zoho Books

  I am recording my Shopify orders as Invoices and once Shopify credits my bank account I reconcile the payout to the specific invoices and create a new transaction to account for the Shopify Merchant Fee. That is fairly straightforward to me. How should

• Charging for WhatsApp replies starting in October 2026

  Meta has announced that it will charge for reply messages on WhatsApp starting October 1, 2026, and the free 24-hour window will no longer exist. How will Zoho SalesIQ handle this billing? https://developers.facebook.com/documentation/business-messa

• Upcoming Change: Increased character limits for module and field labels

  To provide greater flexibility in customizing your CRM, we are increasing the maximum character limits for module labels and field labels in Zoho CRM. What's changing? Label Current Limit New Limit Module Label 25 characters 50 characters Subform Module

• Change of Blog Author

  Hi, I am creating the blog post on behalf of my colleague. When I publish the post, it is showing my name as author of the post which is not intended and needs to be changed to my colleague's name. How can I change the name of the author in the blogs?? Thanks, Ramanan

• SPAM (and some other) folders missing on three of my Zoho Mail accounts

  I have four email accounts with Zoho Mail. Three days ago, the Spam folder on three of these accounts vanished. It is gone on the Windows and Linux desktops as well as the web-based and Android versions, and I have tried it on multiple machines. The only

• Using data from multiple sheets

  I am looking for a way to automate the process of taking multiple Zoho sheets and collating the data into one combined sheet (such that no duplicates occur). Currently I can only think of importing all the sheets into Excel and then running a macro to perform the task. Is there a simpler way offered by Zoho?

• 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

• Conflict with Google Sheets

  While I was working on a google sheet in Firefox, I suddenly started getting an error dialog in Google sheets: "Loading issue. Troubleshoot this issue by clearing application resources". It then says to clear cookes etc. etc. which didn't help. Disabling

• Error 1011 saving website personalisation — blocking all changes (corrupted "home_page.content" field)

  When trying to save changes under Settings → Brands → MY COMPANY → Website → Personalisation → Messenger, I receive the following error: "Either the request parameters are invalid or absent" upon checking on the developer console of the browser I get

• All new Address Field in Zoho CRM: maintain structured and accurate address inputs

  Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. 24

• CRM x WorkDrive: We're rolling out the WorkDrive-powered file storage experience for existing users

  Release plan: Gradual rollout to customers without file storage add-ons, in this order: 1. Standalone CRM 2. CRM Plus and Zoho One DCs: All | Editions: All Available now for: - Standalone CRM accounts in Free and Standard editions without file storage

• HR Helpdesk Cases

  We have Zoho One Enterprise. I'm trying to find HR Helpdesk Cases, but my UI does not match the documentation. I'm not sure how to move forward.

• Tip #7 - Siri shortcuts in Zoho CRM

  Hello Everyone, Here is a tip about the 'Siri Shortcuts' feature and how it works in the iOS version of the Zoho CRM mobile app. What are Siri shortcuts? Siri Shortcuts are quick actions across your apps on iOS. They can perform an action automatically

• Automatic Department and Employee Sync Between Zoho One and Zoho People

  Dear Zoho Support, I'm writing to propose a valuable feature request that would streamline data management and improve user experience within the Zoho ecosystem: automatic synchronization between departments and employees in Zoho One and Zoho People.

• Nothing triggers a Journey

  I have been on the phone with Zoho support and they claim their development team needs to investigate more. However, I've found this is a pretty standard answer after a call takes any amount of time. After that, it's days and even weeks before it actually

• Manually Backorder Sales Order and/or Change Sales Order Status

  Is there an option to manually 'backorder' a sales order, or otherwise change it's status?  In some cases, we receive orders for products that are out of stock, but we already have issued POs to our suppliers for replenishment.   Ex- we created a PO on

• Backorder process review - Automating Removal of Sales Order from "On Hold" When PO is Received

  Hello Zoho Inventory Team, Currently, sales orders in On Hold status are released only when the bill for the purchase order is created. In our workflow, it would be much more efficient if the sales order could automatically move out of On Hold as soon

• Kaizen #254 - Building a Temporal Lead Score Decay System in Zoho CRM

  Hello, CRM Wizards! Welcome to a fresh week of Kaizen. In this post, we will build a temporal lead score decay system that works alongside your existing scoring rules by introducing percentage-based score decay driven solely by customer inactivity. By

• Metadata API Access to Functions

  I think it would be incredibly helpful to have api access to every function's code. Our team primarily uses deluge functions to update fields across modules according to business logic. I would like to create a visual dependancy model for our CRM, but

• API actions/approvals endpoint returns UNAPPROVABLE despite user having full permissions and being the assigned approver

  Hi Team, We are trying to programmatically approve a record via the CRM API but consistently receive an UNAPPROVABLE error, even though the same user can approve the record without issue from the UI. Endpoint called: POST https://www.zohoapis.com/crm/v6/{module}/{record_id}/actions/approvals

• Get a realistic picture of your revenue with Forecast Adjustments in Zoho CRM

  #crm25q1 Dear Customers, We hope you're doing well! Today, we're here with an important enhancement for business decision makers: forecast adjustments. Let's get straight to it! With technology on the rise and CX at its core, businesses are constantly

• I am not able to check in and checkout in zoho people even location access allowed

  This issue i am facing in mackbook air m1, I allowed location in chrome browser and i also tried in safari but getting similar issue. Please have a look ASAP.

• Next Page