Tip of the fortnight 3 - Create merged documents with form responses

Tip of the fortnight 3 - Create merged documents with form responses

Hello fellow form builders,

It's another fortnight, and I am back with an exciting new tip. In the previous post, we discussed how to deliver the PDFs of the submitted form  to your customers. To continue with this process, let's take a look at how to create dynamic documents with the responses that fall in your form.

Sending Order Receipts upon successful purchases, Interview Call Letters to chosen candidates, Invoices for your customers, Certificates on course completion, etc, is crucial for your business. Instead of the default process of manually entering in form data into an external document and dealing with the chaos of paper documents, I'll share a useful solution!



Using this tip, you can quickly integrate your document template with the form you create, and automate them as customized documents by merging the form responses. This ensures that there is no room for manual errors during the pre-filling process. Let's take a deep dive to understand how it's done!


Leave your mark 

Whether it's an Order Invoice or a Sales Contract, the scenarios require customized solutions. To satisfy this, create custom documents using Zoho Writer or WebMerge by adding your company logo, tables, etc. and design them to reflect your business. 

Here's a preview of how a document will look inside Zoho Writer (I've illustrated an Order Invoice and an Interview Invitation here). Include your form responses inside the document by clicking the field labels under INSERT FIELDS header.  






We've learned how to construct various documents as per business needs, and now let's explore the different ways it can be sent to your customers. 

Deliver to every submitter

If you want all of your customers to receive the document (say, an Order Receipt), try setting up an automated email by configuring the customer's email as the To address and include the merged document as an attachment. This configuration delivers custom documents right away when the customers make a form submission.

Deliver to specific submitters

If you want to analyze all your received form entries and send the documents to a few of the customers (say, a Course Completion Certificate), you can follow our manual workflow. For a Zoho Writer document, configure the email set up in the Merge and Send Email tab that appears. You can check the status of the document (if it is successfully merged or sent) by routing to the Mail Merge Status column under the All Entries/ Report section. You will receive a success message like this. 




That's all there is to it! Try this out and get started with the document merge for your forms by learning the set up from our help documentation. And, it's a wrap! What are the different documents you create for your business? Comment below - we'd love to hear from you!  

Until next fortnight, 
Prasana.

    Access your files securely from anywhere







                            Zoho Developer Community





                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner




                                                            • Sticky Posts

                                                            • Tip #10: Automatically add tags to Zoho CRM records using form responses

                                                              You may be using tags to filter records, create reports based on specific tags, or let your sales team to know which clients to give priority to. Don't skip tagging for the crm records added via forms. The tags can be set to be automatically captured during the form submission. How it works When you set up a configuration to push form entries into CRM, you can add a tag to them automatically. The tag value can vary based on the respondent's input (captured using form fields), or you can include a
                                                            • Tip #2: Prefill forms automatically with existing Zoho CRM data

                                                              How to automatically prefill a form with existing Zoho CRM data? Prefilled forms can be useful when you want your prospects to view and confirm their data, and in a wide range of other situations. In Zoho Forms, we prefill the fields with the values from Zoho CRM using the Zoho CRM field. What is a Zoho CRM field? A Zoho CRM field acts as a two-way communication channel, by sending data to Zoho CRM from forms and fetching information from CRM into Forms. The field will look up data from your CRM
                                                            • Tip #8: Pass Adwords data (GCLID) and UTM parameters to Zoho CRM using forms

                                                              When you are using forms to capture leads, you may wonder: " How did they find me? Which marketing campaign worked best?"  You can answer this question by capturing the Google Adwords data (GCLID) or the UTM parameter details in your CRM using forms. This can be a great way to gauge the effectiveness of your campaigns and identify the most effective ways to capture leads.  Capturing GCLID parameters How it works If a person finds your form by clicking an ad, a GCLID gets created. When they fill out
                                                            • ZUG (Zoho User Group) In-person Meetups - Maximize Data Efficiency with Zoho Forms & Beyond

                                                              Hello Zoho Community, Join us for our upcoming meetups in ANZ, where we'll dive into seamless data handling and maximizing efficiency through Zoho Forms and beyond. Explore the potential of Zoho Forms customization and integration, from mastering the
                                                            • Tip #9: Modify deal properties in Zoho CRM using form responses

                                                              How to modify deal properties of Zoho CRM records using form responses? Deal properties in Zoho CRM records are constantly modified based on the status of the deal. You can automatically modify deal properties (like the deal closing date, or deal name) and even update the deal stage, using form inputs. This can drastically reduce the work your team would otherwise do to search and change individual record details manually. How it works This works by integrating the form with the Deals module of Zoho


                                                            Manage your brands on social media



                                                                  Zoho TeamInbox Resources



                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner







                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources


                                                                                              Zoho Writer Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ








                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • The way that Users can view the ticket

                                                                                                              I have created users. What I would like to achieve is the following: All users under the same company account should be able to view each other’s tickets.
                                                                                                            • Zoho UAE SMS/WHATSAPP

                                                                                                              Hello everyone, so I have a question as regards DC and their impact on automation, integration and app usage. For example I am working with a UAE clientniw but each time I tried to connect their WhatsApp and sms then automate their process I tend to receive
                                                                                                            • Looking to Flag or Tag contacts/ accounts on Zoho Desk?

                                                                                                              I am looking for a way to flag certain accounts and make it obvious on the views pages. So for example if a has a certain package or needs extra attention it is clear before even clicking on the ticket. This could be via adding a tag or flag onto an account,
                                                                                                            • setting date-time field from string

                                                                                                              hello everyone, i hope someone could help me. i have a date-time field in a form that i want to fill in from two separate fields of date, and time. i need to combine the two fields to a one date-time field but can make it work. i tried to convert the
                                                                                                            • Calendars and CRM Contacts

                                                                                                              I'm finding having multiple calendars in Zoho One so confusing. I have a few questions so I can get this straight. We have a meeting room that we have set up as a resource in Calendar. Can this be set up in Bookings and the CRM Calendar? Using Zoho Calendar,
                                                                                                            • Announcing new features in Trident for Mac (v1.23.0)

                                                                                                              Hello everyone! Trident for macOS (v.1.23.0) is here with interesting features and thoughtful enhancements to elevate your workplace communication and productivity. Here's a quick look at what's new. Record your meetings. You can now record audio and
                                                                                                            • Applying a record template

                                                                                                              Hi all, I can't figure this out. I hope you can help. The scenario: We have learners who have to complete a 'digital' journal with tasks in order to qualify. Those tasks, once completed, need a final signature from their 'Mentor', which will trigger their
                                                                                                            • Quickbooks invoice with Zoho Creator

                                                                                                              Is it possible to push data from Zoho Creator directly to an invoice on QuickBooks? If so, where can I find information on how to do this?
                                                                                                            • Help: Capture full page URL in hidden field when same Zoho Form is embedded on multiple pages (iframe)

                                                                                                              Hi all, Goal Use one Zoho Form across multiple pages and record the exact page URL (incl. subdomain + path + hash) where the user submitted it. Example pages: https://www.example.com/cargo/ https://www.example.com/cargo/containers/#contact https://cargo.example.com/auto/
                                                                                                            • Automatically Populate fields - HELP!

                                                                                                              There have been many discussions on this but I still can't seem to get it to work for me. I am trying to create a lookup field and have other fields automatically populate. Based on the instructions in the Help Center, I should be using the "on user input". It's just not working, here is the layout...   Both forms are in the same application. Current form is called Add Note, form to fetch records from is called Add Client. Lookup field is called Select_Client_ID related field in fetch form is called
                                                                                                            • Push notifications to portal users

                                                                                                              Hi all, it is possible to send push notifications to portal users?
                                                                                                            • Rename the attachment from record template pdf in the sendmail deluge script

                                                                                                              Hello Zoho, I urgently need a feature to rename record templates that I send via the sendmail feature. The program I created sends emails to clients with an invoices that have been created in the invoice database. If the user selects 3 invoice numbers,
                                                                                                            • Alt Text On Multiple Images

                                                                                                              I'm using Zoho Social to post to a charity website. Often the posts have multiple images, but it seems there is only one field for Alt Text. Does that mean I can only include it for the first image? Or is there a way to add alt text for all the imag
                                                                                                            • [SOLVED] Getting 401 when trying to download ticket attachment via API

                                                                                                              I'm able to use the API just fine to access ticket content. But I cannot download ticket attachment, keep getting 401 Client Error. Example: https://desk.zoho.com.au/api/v1/tickets/{ticket_id}/attachments/{attachment_id}/content?orgId={org_id} For headers,
                                                                                                            • Zoho project – Workdrive integration.

                                                                                                              Hello everyone, I was wondering something, we did the Zoho projects integration with Zoho Workdrive but nowhere during this integration we could set the location of the folders that would be automatically created in Workdrive. As I understand it, it creates
                                                                                                            • Scriptを埋め込みたくてOn User Inputを探しているのですが・・・

                                                                                                              編集モードで、Scriptを埋め込みたい項目を選択し、「項目のプロパティ」パネルで、その下のほうに「フィールドアクション(Field Actions)」という見出しがあると聞いたのですが、そもそも、それが見つかりません。そのために、On User Inputなどのイベントが選べません。 画面の英語を日本語に訳しているためにわけわからん状態になっているのかも知れませんが、わかる方、いらっしゃいますか?
                                                                                                            • Problem with cloud query exceeded

                                                                                                              When making a call I get this error, It is associated with a function in node that calls external APIs This is the code //tokenConsultar = thisapp.ObtenerToken(); //input.token = tokenConsultar.get("output").toMap().get("token");
                                                                                                            • Showing Total of Funnel Chart Legend (With Values) Items

                                                                                                              Hi, We are using the funnel type chart for displaying our zCRM sales pipeline stages and associated sum of deals in each stage.  We have configured the legend to show the associated value (Deal Amount (Sum)) for each stage adjacent to the legend items (Stages). Is there a way to display the total of the values in the same chart?  For example, at the bottom of the legend or maybe as a #merge placeholder in the legend title?
                                                                                                            • How to Convert VCF Contacts to CSV using Excel

                                                                                                              Many users switch from traditional address books to digital formats like vCard and CSV. These formats allow users to easily manage their contacts. However, a difficulty comes when you need to transfer your contact information to another application or
                                                                                                            • Field authorization for Linking module in Zoho CRM portal

                                                                                                              Hi guys! Currently building a customer portal for one of my clients, and I ran into a bit of a roadblock while using a multi-select lookup field. The issue is that there is no way to hide or define access in the linking module created by this multi-select
                                                                                                            • Kaizen #63 - Layout Rules in Zoho CRM

                                                                                                              Hello and welcome to another week of Kaizen! This week, we will be discussing Layout Rules in Zoho CRM. If you need to modify the layout of a module based on user inputs, or to show or hide sections based on the value of a specific field, we have got
                                                                                                            • Zoho CRM Portals - allow access per account

                                                                                                              Hello all, I am trying to set up a portal for our customer but I seem to be hitting an obstacle and I am not sure if it is my problem or a limitation in the software. So basically the way I understand the portal Contact Email > Each Record or Related
                                                                                                            • Android - Writer não acentua em Português com teclado bluetooth

                                                                                                              Gosto muito do Zoho, tanto o Note quando o Writer. Infelizmente, o Writer sofre de um problema sério: ao usar um teclado bluetooth, forma mais cômoda de lidar com um processador de texto, os acentos (todos!) da Língua Portuguesa não são aceitos. Todos
                                                                                                            • Set File Upload fields as mandatory

                                                                                                              Currently the CRM for some reason lacks the ability to set a file upload field as mandatory So we have an issue We have a requirement that before a Deal stage is set as Deal is Won the member needs to upload a file Now for some weird reason in Zoho I
                                                                                                            • Editing HTML in Zoho CRM Email Template

                                                                                                              I am trying to create a template within the CRM email option, but need to be able to use custom HTML. There does not seem to be a way to do so.
                                                                                                            • Ability to CC on a mass email

                                                                                                              Ability to CC someone on a mass email.
                                                                                                            • How to make attachments mandatory

                                                                                                              I want the user to be unable to mark an opportunity as Closed – Won if it doesn’t have any attachments. I’ve already tried client scripts and functions, but nothing worked.
                                                                                                            • SLA Ticket Report

                                                                                                              From data to decisions: A deep dive into ticketing system reports Service level agreement (SLA) ticket reports in a help desk system are crucial for ensuring that services are delivered according to established commitments. They help maintain accountability
                                                                                                            • Zoho Backstage - PCI Compliance / Web Security

                                                                                                              I have a couple of questions related to Backstage and payment processing.... 1. my purchasing division is not giving approval to use Backstage yet because of some security issues. In order for us to take payments via a payment gateway like Authorize.net
                                                                                                            • Zoho Tables August 2025 Update: Faster and Smoother

                                                                                                              We’ve been working behind the scenes to make Zoho Tables faster, lighter, and more reliable. Here are the highlights: Faster Response Times Optimised the way responses are generated. Reduced memory consumption by 20–25%, leading to smoother performance
                                                                                                            • Video Upload from app says "unsupported aspect ratio" but is verified to be correct.

                                                                                                              I and my social media person are experiencing a problem where Social will not accept video uploads to Instagram. The error we receive is "unsupported aspect ratio" but looking directly at the file in question we see that the width and ratio both match
                                                                                                            • Disposable Email Addresses

                                                                                                              Dear zMail Team, Can you also bring out a few disposable email addresses for each accounts? That way occasional registrations and imminent spam from them can be largely solved right? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
                                                                                                            • Zoho sheet - Zoho expense

                                                                                                              I want to schedule to create an expense using Zoho Sheet and flow. That is the EMI that I pay on a particular date to the bank and should be itemised, like principal and interest on the loan. Can someone help me in this regard??
                                                                                                            • Ability to configure a schedule/shift for each user and/or crew in Zoho FSM

                                                                                                              Hello, In our team of Field Agents, we have different shifts. Some field agent always work from 7:00 AM to 4:00 PM while others work the evening shift like 4:00 PM to 11:00 PM. Sometime shift are on weekdays only or on weekend. It would be great to be
                                                                                                            • Free webinar: Streamlining customer service paperwork with the Zoho Sign extension for Zoho Desk

                                                                                                              Hello Everyone! Have you been wondering about bridging the gap between digitised customer service and business paperwork? Join our free webinar to learn how you can do this by connecting Zoho Sign, our digital signature app, with Zoho Desk, our online
                                                                                                            • Zoho Books | Product updates | July 2025

                                                                                                              Hello users, We’ve rolled out new features and enhancements in Zoho Books. From plan-based trials to the option to mark PDF templates as inactive, explore the updates designed to enhance your bookkeeping experience. Introducing Plan Based Trials in Zoho
                                                                                                            • Mail Search should allow grouping by conversation like Gmail.

                                                                                                              Having switched from gmail I have found the search function hard to use. Mostly because mail is not grouped by conversation in search. If I search for a word when looking for a conversation had with someone then sometimes 10 emails will come up from the
                                                                                                            • Improve Zoho Learn updated article notifications

                                                                                                              I noticed today while updating an article, that the notification users get says "[User Name] has published article [Article Name]..." My feedback to the product team is that it would be really helpful for an end user, if the system notification differentiated
                                                                                                            • Safari Support

                                                                                                              Safari, the world's second largest browser, zoho desk does not officially or fully support. That needs to change.
                                                                                                            • Can I get images from an "Image Upload" field in a webhook?

                                                                                                              I want to send images from 2 "image upload" fields via a webhook. Is this possible?
                                                                                                            • Next Page