Zoho CRM Integration | Update a record in Zoho CRM - Zoho Forms

Updating Existing Record

Overview  

There are 2 ways you can use to update existing records in Zoho CRM:
  1. Using the Upsert Record action while adding a new record - if a record with identical value exists in Zoho CRM, it will be updated with the new values. If not, a new record will be created in Zoho CRM. 
  2. Using the Update Record integration setup - While you can use the Upsert Record action to update existing records in Zoho CRM with new values, but, if you want to let your respondents view and modify certain records in Zoho CRM using your form, you can use the Update Record option in Zoho Forms. To use the Update Record option, you must add the Zoho CRM field to your form which looks up records from the Zoho CRM modules and prefills the fetched data in the form. The respondents can edit the prefilled data in the form and submit their entry. The Update Record option replaces the existing records in Zoho CRM with the modified values. You can also send a pre-filled form to a list of contacts in your Zoho CRM and update their responses in Zoho CRM.

Update Record Setup

Using the Upsert Record action

To Upsert a record in Zoho CRM, you will have to integrate your form with Zoho CRM to add new records.
  1. In your form builder, navigate to the Integrations tab and click Zoho CRM from the left menu. Click Integrate.
  2. Select the required Zoho CRM Module and Layout to which you want to push your form data and map all the mandatory Zoho CRM fields to the corresponding Zoho Forms fields.
  3. If you have Subform in your Zoho CRM, then map the Zoho CRM Subform fields with the corresponding Subform fields in Zoho Forms.
  4. Once all the fields are mapped, you can select the Upsert Record option under Actions and save the integration. Learn more about the Upsert Record action.
Upsert Preference
If you have a Subform in Zoho CRM, you can choose to either Append or Overwrite the Subform field values into your Zoho CRM while upserting a record.
Append: Choosing Append will let you add new Subform rows to the existing rows in Zoho CRM.
Overwrite: Choosing Overwrite will replace the existing Subform rows in Zoho CRM with the data submitted through Zoho Forms Subform.

Using the Update Record option

To update a record in Zoho CRM using Zoho Forms,
  1. Add and configure the Zoho CRM field in your form.

  2. Navigate to the Integrations tab and click Zoho CRM.

  3. Click Update Record.
    You will see Update Record only after you have added the Zoho CRM field to your form.
    The Module, Layout, and Lookup Selection selected while configuring the Zoho CRM Field in your form will be auto populated.

  4. Map the Zoho CRM fields that you wish to update with the corresponding Zoho Forms fields.

    Update Existing Record in Zoho CRM

  5. If you have a Subform in Zoho CRM, map the Subform fields that you wish to update with the corresponding Subform fields in Zoho Forms.

    subform mapping

  6. While integrating your form with a module, you can configure a Lookup filter to look for existing fields in Zoho CRM that match the response of a form field under Lookup Mapping.

    Note: Lookup Mapping section is available only when you have added the Lookup Field in Zoho CRM.
  7. You can select the Actions to be triggered in Zoho CRM each time an entry is updated in Zoho CRM via Update Record option.

  8. Click Integrate to save your settings.

Update Preference

If you have a Subform in Zoho CRM, you can update it by using either Append or Overwrite option. The following action will take place when a Subform is prefilled using Zoho CRM field.

Prefilled Subform data from Zoho CRM to Zoho Forms



Overwrite
Using Overwrite to update your prefilled Subform data has the following consequences in Zoho CRM 

Updating existing row
Editing a prefilled row in Zoho Forms will result in updating the corresponding row in Zoho CRM.

Adding a new row
Adding a new row in Zoho Form Subform will create and append a new row to Zoho CRM Subform.

Deleting a row
Deleting a prefilled row in Zoho Form will remove the corresponding row from Zoho CRM.



Append

Using Append to update your prefilled Subform data has the following consequences in Zoho CRM.

Updating existing row
Editing a prefilled row in Zoho Forms will result in updating the corresponding row in Zoho CRM.

Adding a new row
Adding a new row in Zoho Form Subform will create and append a new row to Zoho CRM Subform.

Deleting a row
Deleting a prefilled row in Zoho Form will not remove the corresponding row from Zoho CRM.


Updating Subform data in CRM without prefill
If you wish to update subform data in CRM without pre-populating it to your form (i.e, without configuring Subform mapping in the form builder), you can choose between two Update Preferences: Append or Overwrite.

Append: Choosing Append will add new Subform rows to the existing rows in Zoho CRM.
Overwrite: Choosing Overwrite will replace the existing Subform rows in Zoho CRM with the data submitted through Zoho Forms Subform.

Distribute prefilled forms from Zoho CRM     
To send a prefilled form to a list of contacts in your Zoho CRM and update their responses in Zoho CRM,
  1. Configure the setup in Zoho Forms to update record in Zoho CRM using the Update Record option.

  2. In your Zoho CRM, enable Pre-population of Data under Settings > MARKETPLACE > Zoho > Zoho Forms.

    Enable Pre-population of data

  3. You can include the pre-configured form's link directly while drafting an email to a selected contact in Zoho CRM or insert the form's link while configuring an email template for a module in Zoho CRM.

  4. Pick your contacts from the Zoho CRM module and send the configured email with the link to a pre-filled form. Learn more about how this option works.  

Trigger Actions in Zoho CRM while Updating Records  

You can choose to trigger certain actions in Zoho CRM each time a record is updated in Zoho CRM using the Update Record option in Zoho Forms.

Trigger actions

Automation & Process Management
This option triggers your Workflow Rules, Blueprint, CommandCenter, and Approval Processes in Zoho CRM while updating an existing record via Zoho Forms.

Note: Reviewing processes are not supported while updating records.


Attachment & Signature
This option sends attached files and signatures from Zoho Forms to your Zoho CRM account while updating an existing record in Zoho CRM. The following attachments can be pushed from Zoho Forms to Zoho CRM:

  1. Signatures
  2. File upload/ Image Upload field attachments
  3. Merged documents (only the documents sent via email notifications can be pushed to Zoho CRM)
  4. PDF of form submissions
    You can choose to push the Default TemplateCustom Template(s)PDFs sent in form submission workflows, and PDFs sent in approval process as attachments to Zoho CRM.
    • If you choose PDFs in form submission workflows, the PDF template sent to the respondent after submitting the form (for example, the PDF downloaded from the Thank You page, or any PDF sent via email notification) will be pushed to Zoho CRM as an attachment. 

    • If you choose PDFs in approval process, the PDF template sent to the respondent along with the Final Approval Email will be pushed to Zoho CRM as an attachment.

Note: If you have configured to store your file attachments in Zoho WorkDrive using Manage Form Attachments, only the attachment link from Zoho WorkDrive will be pushed to the Zoho CRM module.

Tag Records
This option adds a tag to the records updated in Zoho CRM using Zoho Forms. You can enter a Tag name of your choice or use a form field value as a tag. You can also enter existing tag names created in Zoho CRM to associate the records updated with that tag. 
You can choose if the new tag should overwrite the existing tags of a record or append to the existing ones while updating the record.

Tag Records

Do not overwrite - Empty Values
This option avoids overwriting existing field values in Zoho CRM with empty field values from Zoho Forms while updating a record.

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Adding a new record to a Zoho CRM module

                                                                                                                Table of Contents Integration Setup Supported Modules, Attachment Fields, Field Types Trigger Actions in Zoho CRM while adding a new record Set Alert on Integration Failure Using the Zoho Forms - Zoho CRM integration, you can automatically push your ...
                                                                                                              • Zoho CRM Field

                                                                                                                The Zoho CRM field is a lookup field that helps you fetch data from a Zoho CRM module and prefill your form fields. Prefilling forms with data simplifies the form filling experience for your respondents and saves time. You can also push form entries ...
                                                                                                              • Zoho Recruit Integration

                                                                                                                Table of Contents Integration Setup Supported Field Types Trigger Actions in Zoho Recruit Set Alert on Integration Failure If you are using Zoho Recruit as the recruitment portal for your organization and looking to automate the collection and ...
                                                                                                              • Overview

                                                                                                                If you are looking to automate the process of adding data to your Zoho CRM modules, you can use the Zoho Forms - Zoho CRM integration. With this integration, you can push the form entries directly into Zoho CRM modules and pre-populate certain data ...
                                                                                                              • Zoho Sheet Integration

                                                                                                                Overview If you are looking to store your form responses in a sheet and save the time spent on manual entry of form data into the sheet, you can use the Zoho Forms-Zoho Sheet integration. With this integration, your form responses will automatically ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources