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.



      • 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

        • Recent Topics

        • Introducing Multiple Sandbox Types and Support for Module's Data Population

          Register here for the upcoming Focus Group webinar on Multiple Sandbox | Help documentation to learn more about the new enhancements Hello everyone,  Sandbox in CRM is a testing environment for users to create and test new configurations like workflow

        • Is It Possible to Convert a Custom Module to a Quote?

          I recently created a custom module in our CRM environment for RFQs so that our sales team can submit quote requests directly in Zoho rather than by email/phone. This allows for a cleaner overall process, minimizing potential errors and potentially encouraging

        • Convert invoice from zoho to xml with all details

          How to convert an Invoice to XML format with all details

        • Importing into the 'file upload' field

          Can you import attachments into the file upload field. I would expect it to work the same way as attachments do, But can't seem to get it to work.

        • Sync your Products Module for better context.

          In customer support, context is everything. The integration between Zoho Desk and Zoho CRM helps your sales and support teams function as one, delivering better customer experiences. With the latest update to this integration, you can now sync the Product module in your Zoho CRM with your Zoho Desk portal. This feature enables products from Zoho CRM to reflect in the "product" field in Zoho Desk. This can save your support team valuable time and effort.    Some things to note when syncing the two:

        • CRM verify details pop-up

          Was there a UI change recently that involves the Verify Details pop-up when changing the Stage of a Deal to certain things? I can't for the life of me find a workflow or function, blueprint, validation rule, layout rule ect that would randomly make it

        • Does Zoho Writer have Dropdowns

          I want to add a drop down field in Zoho writer. Is this possible?

        • How can Data Enrichment be automatically triggered when a new Lead is created in Zoho CRM?

          Hi, I have a pipeline where a Lead is created automatically through the Zoho API and I've been trying to look for a way to automatically apply Data Enrichment on this created lead. 1) I did not find any way to do this through the Zoho API; it seems like

        • Transitions do not update fields until the record moves to next stage

          We have a blueprint where a couple of stages have multiple transitions. If only some of the transitions are completed, but not all, Zoho does not update any of the fields impacted by the completed transitions. Is there any way Zoho can udate the fields

        • Blueprint enhancements - Parallel and multiple transitions, and more

          Last modified on Sep 4, 2023: All Zoho CRM users can now access these enhancements. Initially, these features were available only on an early access basis and by request. However, as of August 2, 2023, they have been made available to all users in all

        • Optimum CRM setup for new B2B business

          Can some advise the most common way to setup Zoho CRM to handle sales for a B2B company? Specifically in how to handle inbound/outbound emails. I have spent hours researching online and can't seem to find an accepted approach, or even a tutorial. I have

        • using the Client script on the load of the form if service no is empty means then i want to make issue relate to is Service

          using the Client script on the load of the form if service no is empty means then i want to make issue relate to field is Service if Purchae no is empty means then i want to make issue relate to is Purchase

        • Multiple header in the quote table???

          Hello, Is it possible in Zoho CRM to add multiple headers or sections within the Quote product table, so that when the quote is printed it shows separate sections (for example “Products” and “Services”)? To clarify, I’m asking because: This does not appear

        • using the Client script I want to Hide Show the Fields

          if Related to service means some of the field like service no want to shoe and hide Amc no , purchase no how i achive this let issu = ZDK.Page.getField('Issue_Related_To').getValue(); if (issu == 'Service') { var field_obj = ZDK.Page.getField('Warranty_Cases');

        • openUrl in blueprints

          My customer wants to open a URL at the end of a blueprint transition. Seems this isn't possible right now but it would be very useful. In this thread, https://help.zoho.com/portal/en/community/topic/openurl-not-working the Zoho agent said that it's logically

        • Dropshipping Address - Does Not Show on Invoice Correctly

          When a dropshipping address is used for a customer, the correct ship-to address does not seem to show on the Invoice. It shows correctly on the Sales Order, Shipment Order, and Package, just not the Invoice. This is a problem, because the company being

        • Prepayment of a sales order

          How does everyone handle this common (at least it is common for us!) situation? We require all our orders to be fully prepaid before shipment since we manufacture made to order, custom products. Since ZOHO does not allow a sales order to be prepaid, we are forced to create an invoice at the time an order is placed to allow the customer to pay it. Our sales category is therefore skewed, since the sale was actually booked at the time an order was placed, rather then at the time it is shipped, which

        • Access to Specific Zoho Desk layout for external parties

          Hi, We have a partner who handles for us sales requests from specific markets. He is not a Zoho Desk user. But we want him to b part of a specific Zoho Desk layout to handle inquiries.  How to achieve it in the easiest way possible?

        • Deposit on a Sales Order

          Good day, 100% of my business is preorders, no inventory. I am trying to run away from QB for one of my businesses, but I require two options that I don't seem to find with Zoho Books. 1 - If there is a way to apply a deposit on a sales order, as with

        • How Does Knowledge Base Search and Article Recommendation Work?

          Hello, I would like to understand how the Knowledge Base search engine works. Specifically, does it search based on: The article title only? The full article content? Both, the article and the content? Keywords? Tags? Also, how does the system determine

        • validation rules doesn't work in Blueprint when it is validated using function?

          I have tried to create a validation rule in the deal module. it works if I try to create a deal manually or if I try to update the empty field inside a deal. but when I try to update the field via the blueprint mandatory field, it seems the validation

        • Bulk Delete Attachments

          Is there a way to bulk delete attachments on the form entries? our storage is full and deleting files one by one is pain taking process.

        • How do I sync multiple Google calendars?

          I'm brand new to Zoho and I figured out how to sync my business Google calendar but I would also like to sync my personal Google calendar. How can I do this so that, at the very least, when I have personal engagements like doctor's appointments, I can

        • Zoho CRM || Unable to Bulk Assignment of Territories for Contacts

          Dear Zoho CRM Support Team, I hope this email finds you well. We recently performed a bulk upload of Contacts into Zoho CRM using the official sample Excel template downloaded from the CRM. The upload itself was completed successfully; however, we encountered

        • Cannot get code to work with v2.mergeAndStore!

          Please can someone help me pass subform items into a repeating mail merge table row using v2.mergeAndStore? I have a mail merge template created in Writer and stored in Workdrive. This template is referenced by a custom CRM function which merges all of

        • Ability to CC on a mass email

          Ability to CC someone on a mass email.

        • Ability to Disable System Banner Messages in Chat Flow Control

          Dear Zoho SalesIQ Team, Greetings, We would like to request an enhancement related to the system banner messages in Zoho SalesIQ chat flow control. Current Behavior: SalesIQ allows configuring various automatic banner/system messages such as: Waiting

        • How do you do ticket add ons in Backstage?

          Hi Everyone, If you wanted to have general admin tickets and allow for add ons, like camping, or car or Carbon offset. What would you do? Peace Robin

        • Writing SQL Queries - After Comma Auto Suggesting Column

          When writing SQL Queries, does anyone else get super annoyed that after you type a comma and try to return to a new line it is automatically suggest a new column, so hitting return just inputs this suggested column instead of going to a new line? Anyone

        • Sort Legend & stacked bar chart by value

          I'd love to see an option added to sort the legend of graphs by the value that is being represented. This way the items with the largest value in the graph are displayed top down in the legend. For example, let's say I have a large sales team and I create

        • Idle Chat Reminders for Agent-Handled Conversations

          Dear Zoho SalesIQ Team, Greetings, We would like to request an enhancement to the Idle Chat Handling functionality in Zoho SalesIQ—specifically for chats that are handled by human agents after a bot-to-agent transfer. Current Behavior: In Zobot settings,

        • Layout Adjustment.

          Hello Latha, Hope you are doing well. I wanted to check with you about adjusting the layout columns in the Service Report from the backend, as currently there is no capability for us to customize the layout from our end. Below is the output that I am

        • Snapchat

          Are there any plans to add Snapchat to Zoho Social or is there any API that we can use to integrate into Zoho.

        • Zoho Sign "An unexpected error occured" when clients trying to sign documents

          We are unable to have clients sign our documents. When attempting to complete the process an error appears saying "an unexpected error occured" and in the document history just shows "signing failure." We are at a complete standstill with no response

        • Service Reports.

          Hello Team, I have a requirement to create multiple service reports for a single AP. That means, in one AP I have 5 service line items, and all line items are linked to assets. Once I complete the AP, I want to generate 5 individual service reports, one

        • ¡Vuelven los Workshops Certificados de Zoho a España!

          ¡Hola usuarios de Español Zoho Community! Hace ya unos días que hemos dado la bienvenida al 2026, y promete ser un año de lo más emocionante. Y es que nos gustaría haceros nuestro particular regalo de Reyes, aunque lleguemos un poco tarde. 🎁 ¡Nos gustaría

        • Cancel Subscription

          Hi , Im want to cancel my account but without success please help me to do it

        • Deprecation Notice: OpenAI Assistants API will be shut down on August 26, 2026

          I recieved this email from openAI what does it means for us that are using the integration and what should we do? Earlier this year, we shared our plan to deprecate the Assistants API once the Responses API reached feature parity. With the launch of Conversations,

        • How to list services on quote instead of products

          I need to create a customer facing estimate that displays our services. The default quote layout only allows products to be listed. Is there a way to correct this?

        • Making an email campaign into a Template

          I used a Zoho Campaign Template to create an email. Now I want to use this email and make it a new template, but this seems to be not possible. Am I missing something?

        • Next Page