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

      Zoho Desk Resources

      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


        • Sticky Posts

        • 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 #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 #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

                                • BIN Locations

                                  Hi, I’m new to Zoho inventory and unless Im missing something, I cannot find BIN locations anywhere in ‘items’? please tell me it’s there somewhere?!? Thanks
                                • Bigin & Booking. Associate the appointment with existing customers in bigin.

                                  I tried to change the stage of the pipeline associated to a existing contact after he book a appointment in Booking. I use flow to create a event in booking when a appointment is done. But.... How can I relate the appointment with the existing contact
                                • Zoho Finance Limitations 2.0 #12: Can't sync Books System Fields (Item Category or Preferred Vendor) to CRM Products. Double entry required

                                  We add products to Books and sync them to CRM whenever updates are done. However I still have to do double entry because the Books "Item Category" and "Preferred Vendor" fields are not available as options to sync. Scenario Workflow I add a new product
                                • Storage Space Issue

                                  I made a few Header templates in the CRM email that adds some fields ( 2 fields to be exact ) to the subject line, however I ran out of "storage Space" when I need to add it to 3 more members of my team. How do I solve this ? If I need to upgrade , which
                                • Colour Coded Flags in Tasks Module List View

                                  I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due
                                • Implement Meeting Polls in Zoho Bookings

                                  Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement related to appointment scheduling within Zoho Bookings. Current Functionality: Zoho Bookings excels at streamlining individual appointment scheduling. Users can set availability
                                • Two way sync between Bookings and Zoho Mail Calendar

                                  Is there a way to enable a two-way sync between Bookings and the Zoho Mail Calendar? As far as I know, it is only possible to check conflicts from Bookings and push meetings from Bookings to the Calendar. However, when I press the sync button, appointments
                                • How to link Custom Fields in Ticket view

                                  Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making
                                • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

                                  Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files
                                • A consultant with different working hours for each workspace

                                  As of now, it doesn't seem to be possible to set different working hours for a single consultant in two (or more) different workspaces. For example: A  consultant is going to work 2 weeks/month at workspace A and 2 weeks/month at workspace B. Yet, right
                                • Rollup summary for custom module

                                  Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature
                                • Is it possible to set a value to a field based on certain conditions

                                  Greetings Say i have a field that i want to set its value based on the value of another field.. for example if "number" field has value greater than 10, i want to set my field's value to X. Or if radio group had option 1 selected, then i want to set my
                                • What is the Desk API?

                                  I'm trying to fetch a lookup field data from desk to our creator application and it doesn't work. I'm guessing that my search parameter is wrong? On my trial function fetch if I use these: tickets = invokeurl [ url :"https://desk.zoho.com/api/v1/tickets/351081000145244764"
                                • How to Parse XML Data Returned by API?

                                  I have several APIs integrated with my CRM and they work great. I am having some trouble though parsing data out of a large string/array in Funtions? I need to be able to pull the DeviceId and the WebSiteDeviceName from each PanelDevice. I would appreciate
                                • Can the meeting location be specified by the customer?

                                  I own a painting company. I offer free estimates to customers, and I'd like them to be able to enter the meeting address in the booking form... so, the place they want me to give a painting estimate for. I need the customer to be able to tell me where
                                • Zoho Bookings - Reserve with Google

                                  Does Zoho Bookings plan to to integrate with Reserve with Google?
                                • Single use booking

                                  Hello everyone! It would be very interesting to be able to generate unique booking links. Once a booking is made through that link, it will no longer work. Calendly has something similar: https://help.calendly.com/hc/en-us/articles/1500001292022-How
                                • Features Req: Service-Specific Calendar And Limit number of bookings per guest

                                  By The Grace of G-d. Hi, I Came across 2 features i believe more users would love to see added to the amazing bookings app: 1. Service-Specific Calendar I dont want to open my whole calendar to all of my services. For Example, Lets say i have a free consultation
                                • Generating Discount Coupons for Zoho Bookings

                                  Hi, Is there provision to generate Discount Coupons for appointment bookings? I could not see that in the settings and this is very much needed. Please suggest us. Thanks
                                • Quais são os maiores desafios que você enfrenta ao implementar o Zoho CRM?

                                  Olá, pessoal da comunidade Zoho Brasil! Sou parceiro autorizado da Zoho e, ao longo do tempo, tenho notado que cada implementação de CRM traz desafios únicos, dependendo do segmento de negócio, das metas da empresa e até da familiaridade da equipe com
                                • Featured Blog Image Size

                                  What is the ideal size for the cover/featured image of a Zoho Sites blog? Because all our cover images are getting these black stripes horizontally or on the sides (look images)
                                • Zoho CRM v2.1 deprecation or sunset plans ?

                                  Hi Team Wanted to know if there is any plan to deprecate v2.1 CRM apis https://www.zoho.com/crm/developer/docs/api/v2.1/ and if yes by when
                                • Do I need to migrate to API v7?

                                  Current workload forces me to ask this question. Even though I know API v7 has better features, I have many previous API calls written in v2 that still function well. Is there any compelling reason (that I may be missing) for me to make time to migrate
                                • Has anyone implemented OCR functionality as a text input method for the CRM?

                                  The users in my organisation are used to writing meeting notes using the pen and paper notebook. Asking them to enter those notes into the CRM is a chore and I suspect is a major hurdle for the digitalisation initiative to take off in this organisation.
                                • way to change the interface language (e.g. to English) in the whole Zoho One ecosystem at once

                                  Hi everyone. I had a need to create a new Zoho One account for a new company. However, since I did it from Germany, I have defaulted to German language in Zoho One interface (in all apps). Can you please tell me if there is a way to change the interface
                                • How Can I delete accounts or change type of account?

                                  My accountant has wrongly categorized many accounts as Other Assets instead of Accounts receivable while putting in opening balances. How can I delete an account or recategorize it?
                                • How to have sub heads in Salary account

                                  Hi How can i have sub heads under salary account, we tried but it is not allowing us to create sub heads Thanks Alka
                                • Can I give access of my Zoho Spreadsheet?

                                  Hello Everbody! I work with a travel and tourism company, and my job is to record the data of clients of the company. And I use zoho for my work. So my question is can I give access of my sheet to the clients and my company. Kindly guide me. Thankyo
                                • Is it possible to display formulas in cells instead of calculated results?

                                  I want to export my Zoho sheet as tab separated text without losing the formulas. In excel, I would use the settings Options - Advanced - show formulas in cells instead of their calculated results then save as tab separated values. How do I do this in
                                • Unsuscribe, suscribe and tell a friend links not working

                                  Hello, I'm new to Zoho campaigns. I created and sent a test campaign to myself but on clicking the subscribe, unsubscribe, view in browser ans tell a friend links, i realize none of them leads anywhere. Instead i get the following error:
                                • Tip #5: Setting access rights at the subfolder level

                                  Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.
                                • Cross-Data Center Collaboration and / Or allowing users to choose DC

                                  Dear Zoho Cliq Support Team, We are writing to request a significant enhancement to Zoho Cliq that would greatly benefit our geographically dispersed development team. Current Challenge: Currently, Zoho Cliq automatically routes users to specific data
                                • Creating stunning templates for appointment notification emails

                                  Good day folks! Can you guess what we are going to check out today? We have designed a few samples to showcase the power of customizable email notification templates. Template 1 Template 2 Template 3 Template 4 Template 5 Template 6 Template 7 Template
                                • integrating Zoho CRM vendors with Zoho projects

                                  In most of our projects we collaborate with our Vendors. Being able to integrate only Accounts and not Vendors from CRM, is a huge limitation for our perspective and needs. We would really love to see this feature in the CRM-Projects integration.
                                • Allocate emails to user in a shared mailbox

                                  Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
                                • Multiple Vendor SKUs

                                  One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                • Include SalesIQ activity when sending Forms data to CRM as a new Lead

                                  Is there a way that when I get a new lead via a zoho form on my website to include the activity in CRM? I have Sales IQ integrated with the form however, most of my leads do not talk to us through the chat fuction but they do fill out a zoho form. Id
                                • Attendance Bulk Import Not working.

                                  It was working for me from last one year the same format. but now its giving bad request(400). Please help me. resolved this problem.
                                • ZOho Booking and CRM integration.

                                  We are using Zoho Booking wiht Zoho CRM in a custom module. Inside our module we use the option to book a meeting with the customer. This part works great we feed the field to the URL and everything work 100%. Now my issue is that I was not able to find
                                • Chrome browser issues. Anyone else?

                                  I am suddenly having multiple issues with Chrome browser interpreting the Zoho Mail interface.  Anyone else?  Any known problems? Thanks, Todd
                                • Next Page