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

                                • Can I print a set of record templates as a single pdf?

                                  I have a record template formatted as a gift certificate. I can email a single gift certificate to each recipient, but I also need to print the whole batch for the organiser, and they won't want 40 separate files. The layout needs to be identical, so
                                • Which WhatsApp API works seamlessly with Zoho CRM?

                                  I’m exploring WhatsApp API solutions that integrate seamlessly with Zoho CRM for customer communication, lead nurturing, and automation. I would love to hear insights from those who have successfully implemented WhatsApp within Zoho CRM. My Requirements:
                                • Zoho Books | Product Updates | January 2025

                                  Hello users, Now that January is over, here are some exciting updates to make this new year even better. We’re back with new features and enhancements in Zoho Books, including comparing fields as criteria in workflow rules and a custom SMTP integration.
                                • Zoho Creator's 2025 Release Projection 1

                                  Hello everyone, This is Prakash, senior product manager at Zoho Creator. Today, I'm absolutely thrilled to pull back the curtain and give you a sneak peek at our first release projection of 2025, with an exciting lineup of features set to roll out in
                                • is it possible to adjust the date field to show Monday as a first day

                                  Hi, Is it possible to adjust somewhere the date field, so the first day of the week is Monday (instead of Sunday)? Thank you! Ferenc
                                • Zoho Assist no longer works using VPN

                                  I have been using Zoho assist for a bit longer than a year. I have been using the VPN Private Internet Access for even longer.  For the first year of using Zoho assist I could remote into a pc, turn on a vpn, it would disconnect but then reconnect my
                                • Kiosk GetRecords can't compare formulas

                                  (submitted as a help request by accident - should have been a topic) Scenario: I have an "email domain" formula whose value is "@xyz.com" if the e-mail address is brent@xyz.com . I have the same field in Leads and Contacts. So, theoretically, I should
                                • Capture GPS location field

                                  When using a mobile phone to complete the form, I need to capture the GPS location. When this field going to be available? Same question for taking pictures with mobile phone and capturing that picture automatically. Thanks
                                • In what case it's better to use Developer Console? Only for marketplace?

                                  As I can see from the documentation, the limitations are challenging. No Custom API No Page Variables No Custom Connections.
                                • Zoho Sheets working offline

                                  Hi, I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this. Does someone have any ideas or steps I might have missed? Also does Zoho Sheets have the "Format as Tables" function as is currently
                                • Anyone Can help me converting Excel VBA to Zoho Macro?

                                  The Macro in general is pretty simple, It just opens a Workbook and copys some of data from that Workbook to the one that was initially open. But when I try to use it on Zoho I get this error "Unknown function: GetOpenFilename". If there is any other
                                • Creator Simplified #13: Identify the user's device type using system variable

                                  Hey Creators, Welcome back to this week's post in the Creator Simplified series. For today's post, we will learn how to determine the user's device type using a simple system variable. Identify whether the users are accessing your application via web,
                                • Is there any limit on creating stages in pipelines in Bigin

                                  Thankyou.
                                • Office 365 or Outlook?

                                  Hello I'm just setting up IMAP integration with our CRM for the first time since we changed to using Outlook via a Microsoft 365 account. I have the choice of 'Office 365' or 'Outlook'. Which should I choose? Thanks
                                • Can I send Whatsapp template using Deluge function?

                                  Hi, Can I send Whatsapp template in Business Messaging using Deluge function? I have tried to search the documentation but I can't find it
                                • Notebook for watch no longer in Play store.

                                  I had to reinstall Notebook on my Galaxy Watch 7. Alas: the app is no longer available in the Play store. What now?
                                • Workdrive Oauth2 Token Isn't Refreshing

                                  I have set up oauth for a bunch of zoho apis and have never had a problem with oauth. With workdrive i am using the exact same template i usually use for the other zoho apps and it is not working. All requests will work for the first hour then stops so
                                • Resetting auto-number on new year

                                  Hi everyone! We have an auto-number with prefix "D{YYYY}-", it generates numbers like D2025-1, D2025-2, etc... How can we have it auto-reset at the beginning of the next year, so that it goes to D2026-1? Thanks!
                                • Can I trigger workflow rules only on weekend and certain hour?

                                  I want to trigger a workflow rules on the leads created between saturday 5 pm to sunday 5 pm. can I do that? i have tried to search but I cant find option something like that. is there any workaround to solve this?
                                • Client Can't View Ticket

                                  Hi, I created a ticket for my Client since he had an issue. I added him as a Contact as well. My client got a notification in his email that the ticket has been created. When he went to view the ticket on his desktop, the screen was blank. He then viewed
                                • Headers in Subfrom - Zoho CRM

                                  Currently we cannot add any headers to CRM Subform If we have very large subforms and we want to logically group the rows it becomes really hard to do it Please add a header feature so we can add headers to a subform to logically and visually group different
                                • Notification when document hasn't been signed

                                  Hi there. When a document hasn't been signed within the given time, the status changes to "Expired" - is there a way to be automatically notified by email when this happens?
                                • Re-create auth token

                                  I need to re-create a self-client auth token, with the same scopes (and additional ones) as the current token. Is there a way to view the scopes assigned to the current token to ensure that no scopes are missing when creating the new one?
                                • Cant BCC comments

                                  Whats the reason why we cant bcc to add to comments? We are getting this error:  We are unable to process this email. WHY DID THIS HAPPEN? We suspect the below reasons to be the cause of failure : 1. You might have mis-spelt the email address. 2. You might have added the email address in BCC I used the copy option within the comments to copy the email address. It works fine if I cc, just not bcc.
                                • How to disable clone record for a user?

                                  Hi, I'd like to disable clone records for some of my users in zoho crm. How can I go about doing that? Regards, CRM
                                • Tip of the week #43- Collaborate internally with your team without leaving your inbox.

                                  Discussions give your team a dedicated space, where they can discuss and collaborate on internal matters. Whether it’s brainstorming ideas for a new announcement, managing approvals, sharing creative ideas, or even planning a team outing, discussions
                                • Fixed Assets Register

                                  Thank you Zoho Books for adding fixed assets register. BUT there are certian tweeks that needs to be implemented. I found the following issues and seek improvements. 1) Fixed Asset Register Report in the Report Section has columns which are so much confusing.
                                • A way to view the sales of leads conversion that were successful

                                  Hi there, I have a question about this analytic component that can be selected in the dashboard. Currently it shows the conversion rate of leads plus how many leads went to deals and how many won deals. I want to be able to view how much sales the lead
                                • Introducing Booking Pages—a topping for your Calendar Scheduling needs!

                                  Greetings, We're here with a new topping for Bigin! Let's dive into the details. What does this topping do? Scheduling appointments with customers is one of the most common challenges small businesses face on a daily basis, as it often involves frequent
                                • Request for Information on Zoho Desk Webhooks Availability and Security

                                  Hi Team, We need some information regarding Zoho Desk webhooks. Could you please provide details on the following: Event Order Guarantee: Does Zoho guarantee that Desk events will always be processed in the exact order they occur? For example, if two
                                • Is Zoho Marketing Plus part of Zoho One?

                                  Hi, Is the new fancy Zoho Marketing Plus part of the Zoho One package? Is there any benefit in using this rather than the standalone products? Many thanks Jon
                                • Dashboard Auto-refresh

                                  Why is there no Auto-refresh on the Dashboard? People have been asking for the last 6 years for this function from what I can see in my reasearch, it seems like a very simple intergration for Zoho to achieve. on Sept. 2, 2014, this was added: Support
                                • Why wont Zoho Support Grammarly!! --- PLEASE VOTE FOR THIS to show Zoho we need this

                                  The spell check and grammar in ZOHO are so buggy and a waste of time. Please support Grammarly! I'm sure I'm not the only one — there are other CRMs that support this. If you're not planning to add this feature, Please let others know before accepting
                                • Create Quote does not show the "Product Description" entered as part of the Product setup.

                                  The product description created as part of the product setup page, does not show in the Create Quote module; The module allows for an additional description to be added but without access to the original stored description. By selecting the product from the "Product Name Lookup" pop-up, the "Product Description" part should be populated from the product record where the user is allowed to further modify it.
                                • Tailoring the Share info on an IFrame link

                                  I want to adjust my form size. It's customised on a theme and normally you would be able to edit the parameters in the attached image. Now all I can do is click on it to copy it. I want to stop it having to be scrolled when people access the form. The
                                • Sync Zoho CRM Contacts to Microsoft 365

                                  I have just enabled the Microsoft Office integration from Marketplace ("Contacts - Take your Zoho CRM Contacts to Office 365 and manage Zoho CRM Contacts from Office 365.") I have just created a Lead in the CRM but it has not gone across to M365. I did
                                • 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!
                                • How do I change the wording of the tile of SignForm?

                                  When my user opens a SignForm url, the title that is presented is always "SignForm signer Information" and a form is displayed asking for the username and email address. This can be confusing to the end user. How can I change the title at least (Or at
                                • Canva Integration

                                  Hello! As many marketing departments are streamlining their teams, many have begun utilizing Canva for all design mockups and approvals prior to its integration into Marketing automation software. While Zoho Social has this integration already accomplished,
                                • 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
                                • Next Page