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




                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day


                                      • Ask the Experts



                                          Zoho Marketing Automation
                                                  • 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 DataPrep 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

                                                                                                  • 【Zoho CRM】数式項目に関するアップデート

                                                                                                    ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 今回は「Zoho CRM アップデート情報」の中から、数式項目のアップデート(3つの機能強化)をご紹介します。 【目次】 1、時間ベースの数式を自動更新とリアルタイムの値を表示 2、条件に基づいて数式の実行停止 3、既存の数式を使用して新しい数式を作成 1. 時間ベースの数式を自動更新とリアルタイムの値を表示 数式項目のプロパティに関数「Now()」を含む数式項目の値をリアルタイムで自動更新するというチェックボックスを導入しました。 Before:データが手動で編集されるか、自動化によって更新されたときにのみ、数式項目は最新の結果を計算し、値を表示していた。
                                                                                                  • Issue with syncing zoho campaigns with zoho crm

                                                                                                    Hi there, I want to sync both zoho campaigns with zoho crm however i have encountered some issues with this. when clicking manage in zoho i receive this message even though im using the same account and its an admin account. however when i go to zoho
                                                                                                  • Changing Color Theme of Guided Conversations

                                                                                                    Hello, We have recently added Guided Conversations to one of our websites, but I am wondering if there is a way to customize the color scheme so it matches the appearance of the website? Thank you in advance!
                                                                                                  • The ability to show fields from subforms when viewing from related list

                                                                                                    Hi there, Currently im only able to display default columns , however when im unable to add the columns/fields from the subform Ive created. below is a field called quantity from the subform. Im not able to search up this field from the manage column
                                                                                                  • HTML Email in Zoho Books

                                                                                                    Is it possible to create custom html email template in zoho books. 
                                                                                                  • Recording overpayment?

                                                                                                    So a customer just overpaid me and how do I record this? I can't enter an amount that is higher than the invoice amount. Eg. Invoice is $195 and he sent $200. He's a reccuring customer so is there a way to record so that he has a $5 advance for future invoice?
                                                                                                  • How can I add Material cost to a project?

                                                                                                    Hello, We use Zoho project to manage scheduled work. This consists in labour tasks and matrials cost. How can I add the material budget, then teh cost to the project? Thanks Barbara
                                                                                                  • Bigin-Zoho Projects Integration

                                                                                                    We're pleased to announce the Bigin-Zoho Projects integration, which enables you to manage client relationships and project tasks simultaneously in one system. With this integration, once you close a deal in Bigin, you can create a project in Zoho Projects
                                                                                                  • Managing independent contractors

                                                                                                    We use Independent contractors as our field techs. I'm looking for a solution to be able to manage there timesheets, payments, and etc
                                                                                                  • License Issue

                                                                                                    Hello Campaigns Team, we have 17 ZOHO One licenses but in campaigns I get the message that we have a free plan. How can we use ZOHO campaigns? As far as I understood campaigns is a part of ZOHO One. THX Niels
                                                                                                  • Dynamic Date Filtering for KPI Widgets – Need Help with Query Table

                                                                                                    Hello, I'm seeking help with setting up dynamic date filtering for my KPI widgets in Zoho Analytics. Below is an overview of my setup and the issues I'm facing: Why: I need my KPI widgets to update dynamically based on a date range selected via a dashboard
                                                                                                  • Count Function in Zoho Table

                                                                                                    Hi Zoho Team, Hope you're doing well. We would like to request the addition of a Count function in Zoho Table, similar to what exists in Excel, Google Sheets, and Airtable. Currently, there is no built-in way to count the occurrences of unique values
                                                                                                  • Leads, Prospects, Contacts, Clients and Me

                                                                                                    I'm trying to adapt my process to Zoho and am getting confused. Here's how I did it before. Maybe it's just terminology...? Leads - anyone from any source that I might want as a client. Leads include people that I am sending emails or tapping in social
                                                                                                  • Contacts, Leads, Prospects, Opportunities, Deals, Oh my!

                                                                                                    I've implemented three CRM's in previous companies, and led the effort for two of those.  I'm pretty familiar with sales pipeline management. For my current company, I chose Zoho One because of the broad range it includes for other business processes, and am generally quite happy.  So now it's time to dig into Zoho CRM And I find myself a bit befuddled. In other implementations, a "Contact" was just that- a name and some contact information.  Could be anybody whether interested in doing business
                                                                                                  • Visual Sync Status Indicator

                                                                                                    I think I've see in documentation that WorkDrive had the industry standard of indicating a sync status for individual files and folders. I'm just starting with WD and synced my first test folder, but there was no way to tell what's happening by just looking
                                                                                                  • Is there a way to make the new tab button open a new cloud document?

                                                                                                    I'm coming from Google Docs. Plus, is there any way to have a set a default font? I'm using the desktop app and I prefer the options I can get through the cloud documents. I want the convenience of just opening a new cloud document rather than doc that's
                                                                                                  • Tip 26: How to hide the "Submit" button from a form

                                                                                                    Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in.  Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and then
                                                                                                  • Trying to export a report to Excel via a deluge script

                                                                                                    I have this code from other posts but it gives me an error of improper statement, due to missing ; at end of line or incomplete expression. Tried lots of variations to no avail. openUrl(https://creatorapp.zoho.com/<username>/<app name>/XLSX/#Report:<reportname>,"same
                                                                                                  • Bigin_Email Notification not being sent when a new lead is created

                                                                                                    I have a workflow in BIGIN set to send an email notification when a new lead is created via a webform (integrated with ZohoForm) The trigger is whenever a contact is "Create or Edit". Conditioning was applied for contacts which source is "Website" If
                                                                                                  • ZOHO CRM API Python SDK Convert Quote to Sales Order

                                                                                                    I can see footprints that this may be possible through Inventory Conversion. But I am unable to locate any specific details or samples on how to do this. I am using the most current Python SDK. Any support or even sample code would be much appreciated
                                                                                                  • Displaying Notes/Description Columns in "All Expense" showing Tabs

                                                                                                    It's surprising to see there is no option to view description columns in tab showing all expenses. There are provisions for Reference# and Status, but why not the description/notes. Please Add. Thank You.
                                                                                                  • Zoho Books - uploading company logo squashed

                                                                                                    I am trying to upload my company logo with the following dimensions - 240 x 240 pixels and a file size of 106Kb. When I look at the logo in my invoices, it is squashed and not the right size. Any idea what is going on? I've tried uploading jpeg and png
                                                                                                  • Petty cash discrepancy

                                                                                                    How do I record a petty cash discrepancy? We had money go missing and need to document that in the books, but I'm not sure how to put that in. It's not an expense, just a loss of cash.
                                                                                                  • Missing Custom Fields in ZOHO Reports

                                                                                                    Hi, I am currently attempting to generate some reports using the programme. However, I have met some obstacles in the form of missing custom fields from the field selection panel when creating charts etc. Please advise. There are plenty of custom fields which is rather important to creating these reports. Thank you.
                                                                                                  • Zoho Workdrive file versions

                                                                                                    Hello. I have Workdrive setup to sync files offline to an external hard drive. The off line sync folder currently shows at 1.42 TB. I have a 5 TB storage limit in Workdrive. The cloud version of Workdrive says that I have used all 5 TB! I have 27, 285
                                                                                                  • Integration with Zoho CRM?

                                                                                                    Will it be possible to integrate WorkDrive with CRM similar do Zoho Docs?
                                                                                                  • How to control the # of version of files to keep?

                                                                                                    Currently most of the WorkDrive Storage comprise of the many versions of files saved. How do I save some space and reduce the number of version of date or files saved in WorkDrive? Thanks
                                                                                                  • Should I Use Zoho Mail Calendar, or Zoho CRM Calendar, or Zoho Calendar?

                                                                                                    After a couple of dozens Zoho solopreneur products that I transitioned to after becoming a Zoho One enthusiast 5 years ago, I am finally preparing to conquer the remaining two bastions: Mail and WorkDrive (using Google Workspace at the moment). A NYC
                                                                                                  • Add comments to a form

                                                                                                    Hello, I'm trying to add comments to a form using a subform with one field named comment, but I don't want prior comments to be editable or deleteable by anyone (except the admin).  Is there a way to only display prior comments (with a datetime, user and comment field preferably) but still be able to add new ones when editing the main form?  I'm not tied to subforms if there is an easier was to do this?
                                                                                                  • Zoho Books | Product updates | March 2025

                                                                                                    Hello users, We have rolled out new updates in Zoho Books to enhance your accounting experience. These include the ability to create workflow rules for manual journals and Multi-Factor Authentication (MFA) for customer and vendor portals. Explore these
                                                                                                  • Work Drive Tray Icon Missing

                                                                                                    How can I get the tray icon back? The app froze, had to restart PC and then it's been gone since...  I've re-installed the windows program and restarted my machine twice now.
                                                                                                  • cant receive emails

                                                                                                    I have checked the Dns and everything seems to be fine pls check the print screens attached below help me cause i need to solve this fast
                                                                                                  • Retainer invoice in Zoho Finance modlue

                                                                                                    Hello, Is there a way of creating retainer invoices in the Zoho Finance module? If not can I request this is considered for future updates please.
                                                                                                  • iOS Widget Not Working

                                                                                                    It appears that the iOS widget is not working, displaying a blank white screen instead of a selected note. I’m using app version 6.5.12 and iOS 18.3.1.
                                                                                                  • Two Problems With Data Imported to Notes

                                                                                                    Occasionally I want to create a note by copying and pasting a few paragraphs from an article on line. When I create a new note and paste in the section the newly created note winds up with each paragraph in white text on a dark background rather than
                                                                                                  • Workdrive on Android - Gallery Photo Backups

                                                                                                    Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma
                                                                                                  • Generate a link for Zoho Sign we can copy and use in a separate email

                                                                                                    Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to
                                                                                                  • How to associate a document sent in Zoho Sign with an deal in the CRM?

                                                                                                    Hi, often documents are loaded in Zoho sign and sent for signature. These sometimes are linked to a deal in the Zoho CRM and would be nice to see the status of the document within the CRM. I am aware of the integration, but that assumes that the document
                                                                                                  • Preventing auto-redirect to Parent Record on Save...

                                                                                                    Our users often create records from the related list on th left side of the screen. They click the blue "plus" button to create the record. This is handy, but for some modules, or situations, they would like to remain on the record AFTER clicking "Save",
                                                                                                  • CRM Portal Help

                                                                                                    Hello, I am trying to set up a portal to connect with our referring doctors to keep patient cases organized. I set up the accounts module as office, the contacts as doctors, the leads as patients, and the deals as treatments. Everything seems to work
                                                                                                  • Next Page