Tip #2: Prefill forms automatically with existing Zoho CRM data

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 account to prefill the form.

This field accesses the CRM record using a unique key to identify which record you are searching for. The records can be identified by their last name, company, or any other unique field.

Setting up the integration

First you need to add the Zoho CRM field to your form. In the setup configuration, determine the following:
  1. Which field to use to identify the CRM record. For example, the Last Name of the record.
  2. Which details should be prefilled in the form. In the example below, the record's First Name , Email, and Phone are set to be prefilled. 



Notes on using Zoho CRM fields  
  • The Zoho CRM field will not work for embedded forms, or if forms are shared via public link(URL). It can only be used when the form is shared privately (within the organization). 
  • The person updating the data must be a user of both Zoho Form and Zoho CRM and have View/Edit access to records in CRM. 
Send out prefilled forms to your leads/contacts

If you need to share forms with people outside the organization and want the forms to be prefilled with the data from your CRM records, you can send the link to the form as an email in Zoho CRM. This allows a prefilled form to reach the end respondent, with a disabled Zoho CRM field. This keeps the data secure, because the disabled field will not reveal any information from other records.

How prefilling works?

The fields in the form are not populated when the form reaches the respondent. They will need search for a particular CRM record using a unique key, in this example, it is Last Name (as configured above). When the record is found, the mapped values in the Zoho CRM field setup will be autofilled into the form fields.

As shown in the example below, the First Name, Phone and the Email fields are automatically populated with data from the CRM record. The user can further modify the autofilled values, and also fill out the remaining form fields.



Now that you know how to prefill forms, we will discuss how this can be used to update or add data in the upcoming series.



Stay tuned!
Prasana.



If you have any questions or feedback to share, feel free to comment below or drop us an email at   support@zohoforms.com



      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • 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

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

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

                              Zoho CRM コンテンツ








                                ご検討中の方

                                  • Recent Topics

                                  • Kom er met me verstand niet helemaal bij.....

                                    Beste Zoho One, Wij hebben mega veel producten van zoho maar dit begrijp ik werkelijk niet. Wij gebruiken voornamerlijk ZOHO FSM met ZOHO INVENTORY omdat wij in service en onderhoud zitten voor elketrische laadstations voor auto's Alle medewerkers van
                                  • Zoho Creator Upcoming Updates - March 2025

                                    Hello everyone, We hope you’ve had the chance to explore Release Projection 1 for 2025! This month, we’re keeping up the momentum by bringing even more powerful features and enhancements to Zoho Creator. Here's what you can expect in March: App menu builder
                                  • Success message - Warning message

                                    We already have the "success message". The alert does not work in the report action; a "warning message" (with red color) would be ideal. Additionally, we should be able to set the duration which the message stays before it fades out, as it is currently
                                  • MA 2.0 Email Footer

                                    Good day, I recently went through the nightmare of upgrading from MA 1.0 to MA 2.0 and continue to experience more problems or missing features and settings. In this particular case, I am trying to find where and how to edit the Email Footer in MA 2.0.
                                  • books+POS+ tap to pay+ stripe

                                    So in the UK we now have tap to pay with stripe. So we can use the stripe app as a POS terminal. Brilliant news. Can we hope that the Books App might add this feature ASAP. It would be great to have one system rather than using the not very good Square
                                  • Instantly refine your CRM dashboard using Filters and download underlying data – all in a few clicks!

                                    Hello everyone, Imagine you’re a sales manager overseeing multiple product lines across different regions. You're viewing your sales dashboard in Zoho CRM, which gives a powerful overview, but you often need to drill down to see how a specific product
                                  • Custom Related List anchor tag with tel protocol

                                    The following code worked great for about a year to create clickable tel and mailto links in a related list in the Deals module. Just this morning, it started displaying the HTML as text. For example: <a href='tel:8882490100'>8882490100</a> Zoho support
                                  • How to create a contract using Zoho Contracts API and have the systemStatus directly assigned as "Active"?

                                    Hi Team, How do I create a contract using Zoho Contracts API and have the systemStatus directly assigned as "Active" instead of "Draft"? Currently, I'm able to create a contract but the systemStatus is "draft". Kindly help.
                                  • Python - code studio

                                    Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already
                                  • Syncing with Google calendar, Tasks and Events

                                    Is it possible to sync Zoho CRM calendar, task and events with Google Calendar's tasks and events. With the increasing adoption by many major tool suppliers to sync seamlessly with Google's offerings (for instance I use the excellent Any.do task planning
                                  • Filtert products by multi select custom field

                                    Hello, this is seems like a must addition, why it can not be done now?
                                  • CRM quotes and sub forms.

                                    Recently upgraded to Enterprise CRM - now some added hopes/questions * In a subform in quotes, if I add a "Percent" field, called Overage for instance. I would expect it to allow me to enter a percent like "10%" and carry the percent forward to formulas
                                  • Is there a notification API when a new note is addeding

                                    Trying to push to Cliq, or email notification when there's a new note added in module. How to implement this?
                                  • Problem with WorkDrive and Vivo X200 Pro

                                    Hey there, after a long odyssey of searching for a new phone, several issues and defects with a phone from another brand and many reinstallations and transfers I stuck to the Vivo X200 Pro. So far, so great. Only thing not working is the Zoho WorkDrive,
                                  • Cambiar nombre de usuario

                                    Hola. Tengo una cuenta en zoho, por ejemplo Minombre @ midominio.es Y quiero cambiarlo a Miotronombre @ midominio.es Se puede cambiar??? Con la cuenta gratuita de zoho, cuantos nombres puedo tener en un dominio??? Gracias y buen dia
                                  • Can't add company logo and favicon as a superadmin

                                    I am logged in as the superadmin but can't add company logo and favicon - the fields are greyed out. Any idea as to what the problem could be?
                                  • Inquiry regarding B2B website through Zoho Commerce

                                    We are looking to build an online B2B customer portal for Consumer Goods primarily for order placement, with an e-commerce-style layout. Additionally, we would like to offer our customers features such as: 1.Viewing past orders and order updates 2.Accessing
                                  • ASAP Chrome Extension not loading

                                    We have ASAP enabled in Zoho Desk. I installed the ASAP Chrome Extension (Windows 10), but when I click the extension button while on our site, it never fully loads. I just get what's shown below.
                                  • Why is the Zoho portal not mobile friendly?

                                    I just got started with the portal and im sort of shocked how it looks. I already filled a hint/complaint about this. On the website you see a wonderful site with a modern design. Yet in real life its a mid 2000 look and feel. One major issue i see thats
                                  • New Asap Widget How to update my code

                                    I know you're still working on updating the documentation for calling the Asap Widget, the existing documentation is no longer valid. In the old 1.0 version I was able to do many things programmatically in javascript. I could open an article directly
                                  • Condition in templates

                                    Is it possible for me to add merge field conditionally in my templates. For example Dear ${Leads.Gender == "Male" ? "Sir" : "Ma"},
                                  • How to Dynamicaly display image in the Detailed View Report ?

                                    I have an "Add Employee" form that includes an image field for uploading an employee's profile picture from their local computer. In the "Apply Leave" form, I also have an image field where I want the employee's profile picture to be auto-populated based
                                  • Zoho Flow Custom Function to Register Sale in Zoho Thrive

                                    Hi Thrive team, I want to create a custom function which sends purchase information back into Thrive for Affiliate commission. I'm stuck on how to setup the connection, specifically creating an OAuth connection through https://api-console.zoho.eu/ Please
                                  • Sending User-centric reports to all users

                                    I would like to automate an e-mail report to all users that sends them a weekly e-mail listing their open Potentials.  I've created a Report that uses the ${CURRENTUSER} criterion and scheduled the report to send to several users, but they all receive
                                  • How do I add new line and format text in zoho desk ticket?

                                    I am generating a ticket via API and looking to update "description" field of ticket whenever I need. Is there a document where I can find supported formatting for description field on a ticket.  I need to find: Adding a new line and adding bold text,
                                  • Automation #6 - Prevent Re-opening of Closed Tickets

                                    This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits
                                  • Feature Request - Insert URL Links in Folders

                                    I would love to see the ability to create simple URL links with titles in WorkDrive. or perhaps a WorkDrive extension to allow it. Example use case: A team is working on a project and there is project folder in WordDrive. The team uses LucidChart to create a drawing/s for the project. The team member could create a link to the LucidChart drawing/s and allow WordDrive to truly be a repository for ALL the project documents, even those outside of WorkDrive. A folder is dedicated to a CRM account. A
                                  • ZOHO DESK ヘルプセンターの言語選択メニューの表示方法

                                    ZOHO DESK のヘルプセンターを構築し、多言語化設定をしました。 顧客のヘルプセンター画面右上に言語選択メニューが表示されないため、弊社の契約先会社に問い合わせましたが、「通常は多言語化をオンにすると表示するためCSS を触り過ぎではないか」 という指摘のみでした。 試行中ですが表示できません。 何か要因となる情報をお持ちの方がいましたらご教授いただけますと幸いです。 ↓の赤枠を表示したいのですが、表示できません。
                                  • How to reply to thread via API

                                    We have built a webapp for our customers that uses the Zoho Desk API to enable each customer to view their full list of tickets, view individual tickets and raise new tickets. The Zoho Desk API doesn't have the ability to reply to a ticket/thread. Replies
                                  • Email Builder Editor is not functioning or loading correctly

                                    Email editor function is not working or loading correctly in any template, new or old. Cleared my cache, restarted browser, problem unchanged.
                                  • Create Tasklist with Tasklist Template using API v3

                                    In the old API, we could mention the parameter 'task_template_id' when creating a tasklist via API to apply a tasklist template: https://www.zoho.com/projects/help/rest-api/tasklists-api.html#create-tasklist In API v3 there does not seem to be a way to
                                  • Issue in downloading the sent logs

                                    Hi Team, I'm unable to export the sent file for any email campaign. When selecting all fields, the system indicates that the document will be sent via email, but I haven't received it. At times, it shows a download option, but the file doesn’t get downloaded.
                                  • Integrate Google Chat with Zoho CRM for seamless collaboration

                                    Hello everyone, Sales is a team sport and sales reps have to be in constant communication with people inside and outside their organization. While email remains the most effective channel for important conversations, sales reps often collaborate via chat.
                                  • customers enter orders?

                                    Anyway we can let a customer into CRM and enter their own orders , no access to anything else except history reports, no access to any other contacts. Greg Aanes 2109 Queen Street Bellingha WA USA
                                  • Zoho Learn - URL Parameters for Externally Shared Articles?

                                    Hey Folks, Are there any parameters one can append to URLs for externally-shared articles? Specifically, can I add a parameter that hides the Manual name (use case being I want to embed the article in another webpage)? Also, can one password-protect an
                                  • Why Sharing Rules do Not support relative date comparison???

                                    I am creating a Sharing Rule and simply want to share where "Last Day of Coverage" (Date field) is Greater than TODAY (Starting Tomorrow). However, sharing rules don't have the option to compare a date field to a relative date (like today), only to Static
                                  • Post message to a channel using a simple one-line command!

                                    Hi Everybody! This post is all about posting a message in a Channel using cURL, Wget and PowerShell. cURL is a light-weight, command interface used to transfer data to a server. The steps are pretty easy!  The three most important points here are  Generating an Auth token Get your Channel Unique Name Form your message as a JSON structure Generating an Auth token To use the 'Messaging API' you'll need Cliq's authentication token from Zoho Accounts. Generate an auth token by hitting the below-given
                                  • Activity or History Log User Login

                                    Hi Everyone, I have Zoho Customer Portal, which has pages and reports. Is it possible to create 1 field such as true/false to find out users who have opened the customer portal? Like a kind of user activity log. Thank you so much.
                                  • 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
                                  • Invalid Emails in CRM

                                    Is there a way to get a report or create a view that shows all email addresses that are invalid for any reason? I keep coming across them and want to ensure that they are flagged with users to update. This is on a custom module.
                                  • Next Page