Bit Form Integration With Zoho Analytics

Using Zoho Analytics integration with WordPress form builder, you can analyze your data in a much efficient way. You can easily integrate without any coding. This Documentation goes through the configuration process.

Integration Settings

Authorization Process

First, you have to log-in to your WordPress dashboard. Then click on Bit form from the left sidebar. Select an existing form that you want to integrate with Zoho Analytics if you don’t have any form please create a new form. Please follow the screenshots below:

Then click on the Settings menu from the top navigation bar. Navigate to Settings->Integrations->Click on (+) ->Select Zoho Analytics. Please follow the screenshots below:

Select a data center from the dropdown. Then click on the Zoho API Console. Navigate to API Console->Get Started->Server-based Applications. Please follow the screenshots below

Fill those fields (Homepage URL and Authorized Redirect URLs) the same as your Integration Homepage. Then click UPDATE.

Then copy the Client ID and Client Secret and paste it to the Bit Form integration page. Then click on the Authorize button (wait for a few seconds). After the successful authorization click on the Next button.

Integration Steps

Select Workspace & Map Fields

Select the workspace and table from the dropdown. Then map Bit Form fields with Zoho Analytics fields in which you want to send/update data.

Zoho Analytics doesn’t support data INSERT/UPDATE in the integration table

Action

You can update Zoho Analytics records by using criteria.

Example criteria: (“Table Name”.”Department”=’Finance’ and “Table Name”.”Salary” => 9000)

Params	Description	Data type
Table Name	Zoho Analytics column name based on which rows will be updated.	TEXT
Department, Salary	Zoho Analytics column name based on which rows will be updated.	TEXT
Criteria	Criteria based on which rows will be updated. The criteria must be in the format: “Table name”.” ” Supported Operators	OPERRATOR / TEXT

Supported operator for the Criteria

=	!=	<	>
<=	=>	LIKE	NOT LIKE
IN	NOT IN	BETWEEN (to be used as: “BETWEEN ” AND ”)

There is another feature named Update Preference. If you select Yes when the criteria don’t meet a new row will be inserted in Zoho Analytics.

When No is selected then a new row won’t be inserted if the criteria don’t meet.

Set Workflow

In the end, create a Workflow for triggering the integration. Select the integration that you created before.