Auto-populate field values from Zoho CRM in the Zoho Form using Dynamic Webhook
Requirement Details:
Zoho Forms allows you to integrate with Zoho CRM where we can add the required fields and send it to your customers thus facilitating data collection. With this Zoho CRM and Zoho Forms integration, you can push the form entries directly into Zoho CRM modules and pre-populate certain data such as name, email, etc. from Zoho CRM in your form. However, In this Custom Solution - We're able to Auto-Populate the Forms field with the Zoho CRM - Record Data without the Integration Field by the use of the Dynamic Prefill - Webhook method.
Business Use-Case:
Consider you would like to Collect the Product informations that you're customer would like to buy using the Zoho Forms and thus you would like to Dynamically Display the Product informations like Product Price, Product Availability when the Customer Chooses the Respective Product which is available in your Zoho CRM organisation - Product Module Record. In this Case, Without the CRM - Forms integration we'll be able to Pre-populate by using the Zoho CRM Function Call using REST APIs to be Utilised in the Dynamic Prefill - Webhook in Zoho Forms.
Zoho Forms Configuration:
We need to Configure the Required fields like the Customer informations - Name, Email, Contact Number, etc. In addition to it, You need to add the Fields for the Product that needs to be displayed in the Form to be Auto-Populated with the Zoho CRM - Products Record. There should be the Primary Field for the Products in the Zoho Forms Layout to allow the Client to Choose the required Product, Either It can be the Single Line field or a Drop-down field to display the Pre-Defined Product Choices. Using the Primary field, We'll search the record in Zoho CRM to fetch the Field Values.
We should be aware about the Field type [Since it involves the Search Record Task from CRM] for the Primary field in the Zoho Form selected to Search the Record the record in Zoho CRM. Also, For the Fields needs to be selected for the Auto-Population, We'll be only able to Map the Fields based on their Field type output from Zoho CRM - Search Record Deluge Task
For Example, We've Selected the Drop-down field in Zoho Forms to display the Pre-Defined Products as Options for the Customers to Choose and we selected the Fields to be Auto-Populated as Product - Unit Price, Product - Availability status and the Product type.
Zoho CRM Configuration:
We need to create Standalone Functions in Zoho CRM and make them be available as API calls. If the function needs to be triggered without employing these methods or from external sources, you can create standalone functions and make them available as API calls. Triggering functions through REST APIs which gives the flexibility to trigger it from anywhere inside Zoho CRM or from any other application.
Navigation:
- Go to Zoho CRM > Setup > Developer Hub > Functions.
- In the My Functions page, click + Create New Function.
- Choose a Category of the function as Standalone.
- Click Create.
Use the below Script:
- grec = zoho.crm.searchRecords("Products","(Product_Name:equals:" + Product_Name + ")");
- if(ifnull(grec,List()).size() > 0)
- {
- rec = grec.get(0);
- Unitprice = rec.getJSON("Unit_Price");
- Producttype = rec.getJSON("Product_Type");
- Productstatus = rec.getJSON("Product_Status");
- }
- mp = Map();
- //use the same variables used in Forms Prefill mapping
- mp.put("Unitprice",Unitprice);
- mp.put("Producttype",Producttype);
- mp.put("Productstatus",Productstatus);
- response = Map();
- response.put("status_code",200);
- response.put("Content-Type","application/json");
- response.put("body",mp);
- return {"crmAPIResponse":response};
- // Please argument the Product_Name in the function as the string.
In the Argument Mapping, You need to Map the field "Product_Name" to search the record as a String
Calling Function using REST API in Zoho CRM:
Once the above Standalone Function has been Saved, We need to create the REST API for the Standalone Function :
- Go to Setup > Developer Hub > Functions.
- Click the Settings icon for the corresponding function which needs to be made an API.
- Click REST API.
- The API Name field displays the API name of the function which you must use to invoke it. This API name is system-generated; you cannot modify it.
- Enable OAuth2.0 and the API key sliders.
- Click Save.
It's Mandatory to Save the function after generating the REST API Key.
Dynamic Prefill - Webhook configuration in Zoho Forms:
Once you have your form built, Function has been configured in Zoho CRM and the REST API has been generated, Navigate to the Zoho Forms > In your Respective Form builder > Settings tab >Prefill > Dynamic Prefill - Webhook > Click Configure.
Search Configuration:
The Search Field will be the form field which will be used to retrieve related information from an external service. Select a form field from the dropdown as the Search Field. We need to choose the "Choose the Product" field to search the record in CRM using the Webhook.
Webhook Details:
The Webhook URL is the endpoint where your form will send requests to the external service on search. Enter the full URL of the external service to retrieve the data. We need to pass the REST API Key URL from Zoho CRM as mentioned in the Previous Step.
FuntionName : It's the Name for the Standalone Function from Zoho CRM where the REST API Key has been generated.
Authorization Type : General
The Record Identifier Key is used as a query parameter to send the value in the Search Field to Zoho CRM. During a record search, the webhook will include the Record Identifier Key as a query parameter. The value of the Search Field will be sent as the query parameter value. So, The Search Value that we've passed as a String in the Zoho CRM Standalone Function should be Configured here. Product_Name is the string available in the Argument mapping that we've used in the above Standalone Script.
URL parameters will be added as query strings to the URL for sending additional information with the Webhook request.
We need to Pass the below informations :
- auth_type : apikey
- zapikey : [It'll be available in the Zoho CRM - Rest API] Screenshot shared above.
Test Webhook:
Once the Webhook has been configured, In this step, you can test the webhook to ensure it retrieves the correct data based on the value entered in the Search Field. Enter a sample value in place of <Search Field's value> and run the test to send the request to Zoho CRM. It is checked if the format of the response received is valid. You will be able to proceed to the next step only if the received response is valid.
Auto-populate field values from Zoho CRM in the Zoho Form using Dynamic Webhook
The next step is to determine which form fields should be pre-populated with the information from the fetched data. To map the form fields that you wish to prefill with data from Zoho CRM.
- Add a form field and click the field corresponding to it.
- A popup with the JSON response will open. Identify the keys in the JSON response that contain the data you need and select it for the mapping.
- Repeat this for all the form fields that you wish to prefill.
- Click Save
Results:
Custom Solution Created by Raghu | Zoho Partner Support.
If you need any further clarifications, please don’t hesitate to contact partner-support@zohocorp.com
Additionally, we kindly ask all "Europe and UK" partners to reach out to partner-support@eu.zohocorp.com.
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
How to Auto Populate Product List Price in Zoho CRM Subform Using Client Script
Requirement Overview The customer wants to automatically update and display the List Price of the Product in the Subform of the custom module (i.e., Pre-Orders) based on the selected Price Book (i.e., Lookup field) stored in the same module. This ...Launch and Sync a Custom Widget in Flyout Mode Using Client Script in Zoho CRM
Summary: This article explains how to launch a custom widget as a flyout in Zoho CRM using Client Script, pass data from a CRM field to the widget, and update the same field based on the widget’s response. Requirement Overview: Certain use cases ...📘 Zoho CRM – Kiosk and Query Implementation to Display Zoho Books & Desk Contact Information
Business Use-case: A business wants to quickly view consolidated information about a contact from multiple Zoho applications—such as Zoho Books and Zoho Desk—directly from the contact’s record in Zoho CRM. This includes: Checking if the contact is a ...Learn How to Open Email Composer Automatically with Template in Zoho CRM using Client Script
Requirement Overview A Zoho CRM user wants to automate and simplify the process of sending a repetitive emails to different customers based on user's specific action, instead of manual clicking on Send Email button each time. Use-case In a Product ...Renaming System Default Field Labels using Translations in Zoho CRM
Requirement Overview: Clients / Users want to use the terminologies that are specific to their business as field labels to identify the field values. But the system default field labels are not editable in Zoho CRM. They want to rename the label of ...
New to Zoho LandingPage?
Zoho LandingPage Resources