All Zoho Survey tables explained

Introduction

Hey everyone! Sometimes, deciphering the structure and meaning of data in Zoho Analytics, especially when Zoho’s native syncs and integrations are activated, can be quite challenging. That’s why I’ve put together an overview, not only to aid myself but also to assist others in navigating through these complexities.

I hope that this article is helpful and would be pleased to receive additions and corrections (if there are still errors despite my checking).

If you want to see prettier tables, have a look here :D

Collectors

The table plays an important role in the administration of surveys, especially when using the multi-collector feature. This feature makes it possible to distribute a survey to different groups and then filter the results by group.

What is a collector?

A collector is basically a way to distribute a single survey in different ways. Normally a survey is shared via a single link, but with this feature separate links can be created for different groups. This makes it easier to filter and analyze responses by group. In addition, numerous settings such as restrictions, quotas, visibility and hash URLs can be set separately for each collector.

A practical example illustrates this: Suppose you are organizing a workshop for many different customers from different companies and want to get feedback from the participants. Instead of creating separate surveys per company, you can create a single survey and send it to each participant using multi-collectors. This way, all incoming responses are already automatically segmented by company without participants having to provide information manually.

The Collectors table therefore makes it easier for you to organize survey activities.

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Respondents.Collector ID
Name	Text	Name of the collector
Unique URL	Text	The public URL where the survey can be accessed
Survey ID	Text	Reference to the survey to which this collector belongs	Surveys.ID
Status	Text	Indicates whether the collector is still accepting submissions or is already closed.		open, closed
Type	Text	Specifies whether the collector is public or private. If a survey is set as private, it can only be opened by logged-in Zoho users.		public, private
Offline URL	Text	Zoho Survey offers the option of completing surveys offline. This means that responses can be received even without an Internet connection and can be viewed and uploaded after authentication. Further information can be found here: https://help.zoho.com/portal/en/kb/survey/launch/offline-survey/articles/offline-surveys Attention: Even if this function is deactivated, a URL is displayed here. If this is opened, a corresponding message appears stating that it cannot be accessed.
Offline Enabled	Boolean (DecisionBox)	Indicates whether the offline feature is activated or not.		Yes No
Published Date	Date + Time	Time at which the Collector was published.
Cut Off Date	Date	Time at which the collector should be closed (this is the deadline specified in the settings).If a collector was closed manually, the date is not entered here (unfortunately this cannot be found anywhere else).
Multiple Response	Text	This column is always empty, even the support team couldn’t help me here. It looks as if information on restrictions is stored here (Editor 🡆 Publish 🡆 Restrictions 🡆 Response Restriction).

Surveys

This table stores basic information about a survey.

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Survey IDQuestions.Survey IDVariables.Survey IDResponse Variables.Survey IDCollectors.Survey IDPages.Survey ID
Language	Text	Identification of the standard language selected for the survey		Set 1 of the ISO 639 language codes
Created Date	Date + Time	Date on which the survey was created (the publication date can be found in the Collectors table!)
Modified Date	Date + Time	Time of the last editing of the survey
Page Count	Positive number	Indicates the total number of pages in the survey.
Title	Text	A different title can be configured in the settings if the name of the survey (table column ‘Name’) is not to be used.
Submit Button	Text	The text stored in the settings for the button to send the survey
Back Button	Text	The text stored in the settings for the button to go back to the previous page has been changed.
Enable Back	Text	Indicates whether the respondent can return to the previous page or whether the button is not displayed.		true, false (Attention! Zoho uses the text true and false here and not the data type Desicion Box, this inconsistency is confusing and must be taken into account).
Next Button	Text	The text that was defined in the settings for the button to go to the next page
Group ID	Number	Reference to the department in which the survey was created	Departments.ID
Name	Text	Survey name
Type	Text	As a rule, the value “survey” is available here. However, if scores have been configured under Editor 🡆 Advanced settings, the value scoring is available instead.		survey, scoring

Hint

If a survey is missing, please check the data source settings. Go to the Zoho Survey data source and select ‘Edit setup’. There you can select the desired or missing table. If the option Automatically import new surveys is selected, there should normally be no missing data!

Pages

The table contains all the information about the pages in the survey. Normally, this table should not play a major role in evaluations, unless you want to use the page title for segmentation.

Table structure

Column name	Data type	Explanation	Table relationships
ID	Number	Primary key	Responses.Page ID Questions.Page ID
Title	Text	Title of the page
Description	Text	Description text
Question Count	Positive number	Indicates the total number of questions on the corresponding page
Survey ID	Number	Reference to the survey in which this page exists	Surveys.ID

Questions

All data relating to the individual questions is stored here.

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Question ID
Type	Text	Indicates the type of question
Text	Text	Question text
Page ID	Number	Reference to the page on which the question is located	Pages.ID
Trashed	Boolean (DecisionBox)	Indicates whether the question is visible or whether it has been deleted		Yes No NULL
Mandatory Enabled	Boolean (DecisionBox)	Indicates whether the question is defined as a mandatory fieldThis column can contain the value NULL! Further information on the supported question types can be found below.		Yes No NULL
Random Enabled	Boolean (DecisionBox)	Indicates whether a random order of answer options is activated for the questionThis column can contain the value NULL! Further information on the supported question types can be found below.		Yes No NULL
Hint Enabled	Boolean (DecisionBox)	Indicates whether a hint text is stored for the questionThis column can contain the value NULL! Further information on the supported question types can be found below.		Yes No NULL
Other Option	Boolean (DecisionBox)	An optional “Other” field can be activated for certain questions. This column indicates whether this setting is active. Please note that the “Other” field cannot be used for all question types. Therefore, this column may contain the value NULL. Further information on the supported question types can be found below.		Yes No NULL
Hint	Text	If configured, the information text is stored here
No. Of Stars	Positive number	Maximum number of stars to be awardedThis column can contain the value NULL! Further information on the supported question types can be found below.

Question types

Zoho Survey offers a variety of question types, and depending on which type you select, certain options may not be available, resulting in the corresponding Boolean (DecisionBox) fields having the value NULL. In the table below you will find an overview of all available question types.

Type	Field name (on the UI)	Note	Mandatory Enabled	Random Enabled	Hint Enabled	Other Option	No. Of Stars
full_name	Full name		NULL	NULL	Yes/No	NULL	NULL
demographic	Contact details		NULL	NULL	Yes/No	NULL	NULL
heading_descriptive	Heading and description	This is not a question! This element is only used to display text	NULL	NULL	NULL	NULL	NULL
single_drop_down	Dropdown field (one answer)		Yes/No	Yes/No	Yes/No	Yes/No	NULL
multi_select_dropdown	Dropdown field (many answers)		Yes/No	Yes/No	Yes/No	Yes/No	NULL
likert_rating	Rating Scale	The following setting is selected: Likert scale (can be selected when initially added)	Yes/No	NULL	Yes/No	NULL	NULL
image_star_rating	Image Selection	The following setting is selected: Star rating	Yes/No	NULL	Yes/No	NULL	Positive number
image_single_choice	Image Selection	The following setting is selected: Multiple selection (one answer)	Yes/No	Yes/No	Yes/No	NULL	NULL
image_multiple_choice	Image Selection	The following setting is selected: Multiple selection (multiple answers)	Yes/No	Yes/No	Yes/No	NULL	NULL
boolean_choice	Boolean		Yes/No	NULL	Yes/No	NULL	NULL
combined_file_upload	File Upload		Yes/No	NULL	Yes/No	NULL	NULL
calendar_box	Date/Time		Yes/No	NULL	Yes/No	NULL	NULL
email_textbox	Email		Yes/No	NULL	Yes/No	NULL	NULL
single_textbox	Short Answer		Yes/No	NULL	Yes/No	NULL	NULL
textarea	Long Answer		Yes/No	NULL	Yes/No	NULL	NULL
continuous_sum	Continuous Sum		Yes/No	NULL	Yes/No	NULL	NULL
matrix_text_box	Matrix Textbox		Yes/No	NULL	Yes/No	NULL	NULL
matrix_radio_box	Matrix Choice (One Answer)		Yes/No	NULL	Yes/No	Yes/No	NULL
matrix_check_box	Matrix Choice (Many Answers)		Yes/No	NULL	Yes/No	Yes/No	NULL
matrix_likert_rating	Matrix Rating Scale	The following setting is selected: Likert scale (can be selected when initially added)	Yes/No	NULL	Yes/No	NULL	NULL
matrix_grid	Matrix Grid		Yes/No	NULL	Yes/No	NULL	NULL
matrix_drop_down	Matrix Dropdown		Yes/No	NULL	Yes/No	Yes/No	NULL
matrix_star_rating	Matrix Star Rating		Yes/No	NULL	Yes/No	NULL	Positive number
multiple_textbox	Multiple Textboxes		Yes/No	NULL	Yes/No	NULL	NULL
single_choice	Multiple Choice (One Answer)		Yes/No	Yes/No	Yes/No	Yes/No	NULL
multiple_choice	Multiple Choice (Many Answers)		Yes/No	Yes/No	Yes/No	Yes/No	NULL
nps	NPS		Yes/No	NULL	Yes/No	NULL	NULL
ranking	Ranking		Yes/No	NULL	Yes/No	NULL	NULL
slider	Slider Scale		Yes/No	NULL	Yes/No	NULL	NULL
signature	Signature		Yes/No	NULL	Yes/No	NULL	NULL
star_rating	Star Rating		Yes/No	NULL	Yes/No	NULL	Positive number
numeric_textbox	Number		Yes/No	NULL	Yes/No	NULL	NULL
matrix_weightage	Matrix Rating Scale	The following setting is selected: Weighted selection (can be selected during initial addition)	Yes/No	NULL	Yes/No	NULL	NULL
choice_weightage	Rating Scale	The following setting is selected: Weighted selection (can be selected during initial addition)	Yes/No	NULL	Yes/No	NULL	NULL

Respondents

This table stores data on the specific completion of the survey, including information on who completed it and when, and to which collector it belongs.

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Respondent IDResponse Variables.Respondent ID
Start Date	Date + Time	Time at which the respondent opened the survey
End Date	Date + Time	Time at which the respondent submitted/completed the survey. If the survey has not yet been completed, this value is of course empty
IP Address	Text	IP address of the respondent; whether this data is saved or not depends on the setting in the collector (under general restrictions)
Status	Text	Indicates whether or not the survey has already been completed or submitted by the user		completed, partial
Collector ID	Number	Reference to the collector through which the survey data was collected	Collectors.ID
Survey ID	Number	Reference to the survey	Surveys.ID
Time Taken in Minutes	Decimal number	Time difference between start and end time in minutes
Time Taken	Number	Time difference between start and end time in seconds
Survey Modified Time	Date + Time	Time at which the survey was last edited

Hint

This table also contains data records of survey responses that are not yet complete (type = partial). Please take this into account when evaluating the data, as these should generally be excluded…

Response Variables

URL parameters can be configured in the editor under Advanced settings. If data has been transferred in a survey link and a response has been submitted, this data is saved here.

In addition, URL parameters can also be used as response restrictions, whereby these can be set per collector. This means that only one submission is permitted per unique URL parameter value.

These parameters are not visible in the editor under Advanced settings, but are also saved in this table.

Table structure

Column name	Data type	Explanation	Table relationships	Values
Respondent ID	Number	Reference to the data set of the respondent	Respondents.ID
Variable ID	Number	Reference to the variable	Variables.ID
Variable Label	Text	Description
Variable Value	Text	Value of the variable
Skipped By Logic	Boolean (DecisionBox)	?		Yes No NULL
Survey ID	Number	Reference to the survey	Surveys.ID

Variables

This table contains the basic data of the variables (URL parameters).

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Response Variables.Variable ID
Name	Text	Name of the parameter, i.e. the exact string used in the URL
Label	Text	Description of the parameter
Type	Text	Data type		numeric text email choice date essay (only for parameters used for response restriction!)
Unique Order	Text	Order in which the parameters were added (in the advanced settings)		Capital letters (A, B, C, etc.)
Trashed	Boolean (DecisionBox)	Indicator whether the parameter has been deleted		Yes No NULL
Respondent / Custom	Text	If the parameter is used for the response restriction, the value is Respondent, otherwise it is Custom.		Custom Respondent
Survey ID	Number	Reference to the survey	Surveys.ID

Responses

This table is of particular interest as it contains the answers to the questions that were submitted.

Table structure

Column name	Data type	Explanation	Table relationships	Values
Respondent ID	Number	Reference to the respondent’s data record	Respondents.ID
Question ID	Number	Reference to the question	Questions.ID
Option ID	Number	Reference to the option: “Option” refers to the selected value in a drop-down field or the selected answer in a multiple choice question. Image selection questions also refer to an option. However, it should be noted that this does not currently contain any information about the image, so it is unfortunately useless. For further details, please see the section on the corresponding table!	Options.ID
Text	Text	Answer to the question. This field is empty if it is a dropdown field or a multiple choice question (then the answer is the selected option)
Row ID	Number	Reference to the row	Rows.ID
Column ID	Number	Reference to the column	Columns.ID
Row	Text	The name of the row (this is simply a lookup, unfortunately the value at the time of the evaluation is not saved)	Rows.Text
Column	Text	The name of the column (this is simply a lookup, unfortunately the value at the time of the evaluation is not saved)	Columns.Text
Option	Text	The name of the option (this is simply a lookup, unfortunately the value at the time of evaluation is not saved)
Survey ID	Number	Reference to the survey	Surveys.ID
Field ID	Number	Reference to the field if it is a text field or a number field. Further information can be found in the section on the corresponding table!	Fields.ID
Not Applicable Enabled	Boolean (DecisionBox)	For certain questions, you can add the option “Not applicable”. If this option was selected by the respondent, this flag is set. The option can be activated for the following question types: ranking, image_star_rating, matrix_star_rating, matrix_likert_rating		Yes, No
Others	Text	For certain questions, it is possible to activate the “Other” option. You can find more information on this in the section on question types! If this option is activated and the respondent has used it, the answer is not recorded in the “Text” field, but in this field.
Page ID	Number	Reference to the page on which the answered question is located.	Pages.ID
Field	Text	The name of the field (this is simply a lookup, unfortunately the value at the time of the evaluation is not saved)	Fields.Text

Rows

The row information for multi-line questions, such as those that occur in a matrix, is recorded in this table. The data in this table relates to the following question types (Questions.Type):

• matrix_likert_rating
• matrix_grid
• matrix_check_box
• matrix_star_rating
• matrix_radio_box
• matrix_text_box
• matrix_weightage
• ranking
• matrix_drop_down
• image_star_rating

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Row ID
Question ID	Number	Reference to the question	Questions.ID
Text	Text	Name of the row
Survey ID	Number	Reference to the survey	Surveys.ID
Unique Order	Text	Specifies the sequence

Columns

The column information for questions with multiple columns that only occur in a matrix is recorded in this table. The entries in this table refer to the following question types (Questions.Type):

• matrix_grid
• matrix_text_box
• matrix_radio_box
• matrix_drop_down
• matrix_check_box
• matrix_weightage

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Column ID
Text	Text	Name of the column
Question ID	Number	Reference to the question	Questions.ID
Survey ID	Number	Reference to the survey	Surveys.ID

Fields

This table contains information on group input fields that are used to enable multiple entries per question. This also includes the file upload field and the Boolean (DecisionBox) field, as multiple fields can also be configured here as an option.

In the table, the fields of the following question types (Questions.Type) are listed:

• continuous_sum
• demographic
• Boolean (DecisionBox)_choice
• multiple_textbox
• full_name
• combined_file_upload

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Field ID
Text	Text	Name - Attention! If there is only a single switch, “Boolean (DecisionBox)” is displayed here. Otherwise, the corresponding values for the labels will of course appear.
Type	Text	Indicates the type of input field.		single_textbox, numeric_textbox, email_textbox, file_upload, single_choice
Unique Order	Text	Specifies the order.
Sequence No	Number	Specifies the order.
Question ID	Number	Reference to the question	Questions.ID
Survey ID	Number	Reference to the survey	Surveys.ID
Mandatory Enabled	Boolean (DecisionBox)	Indicates whether the field is defined as a mandatory field or not.		Yes, No

Options

The selectable values that are available in drop-down fields or for multiple-choice questions are saved here. There is also an option for image selection questions. However, it should be noted that this option currently contains no information on the image and is therefore unfortunately useless. In addition, this table is also important for weighted rating scales, as the weightings are saved here. A look at this table is therefore essential for evaluations with this type of scale.

Options are saved for the following question types (Questions.Type):

• matrix_drop_down
• single_choice
• single_drop_down
• image_single_choice
• multi_select_dropdown
• multi_select_dropdown
• multiple_choice
• matrix_weightage
• choice_weightage

Table structure

Column name	Data type	Explanation	Table relationships	Values
ID	Number	Primary key	Responses.Option ID
Text	Text	Name of the option/answer
Question ID	Number	Reference to the question	Questions.ID
Survey ID	Number	Reference to the survey	Surveys.ID
Column ID	Number	Reference to the column	Columns.ID
Weightage	Number	For questions of the rating scale type and the Weighted selection option set, the respective weighting is displayed here.

• Topic Participants

• Sven

• Sticky Posts

• Announcing Zoho Analytics 6.0 Beta!

  We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

• What's New in Zoho Analytics - August 2024

  Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

• We are coming to your city! Zoho Analytics Community Meetup

  Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

• Zoho Analytics: 2021 Look Back

  As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

• [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

  Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO

• Recent Topics

• Enhancements to Zoho Corp Help Center "Team Requests" View

  Dear Zoho Team, I hope this message finds you well. The ability to view both my tickets and my team’s tickets in the Zoho Corp Help Center is a fantastic feature, especially as the focal point for Zoho in our organization. However, we’ve encountered a

• We've revised the pricing model of CRM portal user licenses

  Hello everyone, We’re making important updates to our pricing structure for portal user licenses, effective from the next payment cycle. The new slab-based pricing is as follows: Previously, these portal user licenses were priced at $5/ user/ month. As

• Zoho and Hostaway webhok integration.

  I want to receive data coming from hostaway webhook and receive it in zoho crm to create or update record in a module based on conditions. The hostaway webhook sends data every time a reservation is created or modified or cancelled. The hostaway sends

• Layout Prompt when creating an oportunity

  Hi There, Is there a way to create a pop-up prompt when I create a new Deal giving me the option of what layout to use based on a certain requirement? So, if the prompt had two options 1. is a new business Deal 2. is a renewal Deal Thanks in advance

• A recap of Zoho Sprints 2024

• Unable to create custom fields for shipment order

  I'm unable to create custom fields for shipment orders, even though the custom fields are set up correctly. A request to the following endpoint: https://www.zohoapis.com/inventory/v1/settings/preferences/customfields?organization_id=${ZOHO_ORGANIZATION_ID}&entity=shipment_order

• Records per page in New UI

  It seems the new UI lack of "Records per page" function, it is very handy if you are looking for a data that you don't know the exact search term, but you know it may "between" few entries. without a "page" function, we kind of have to keep page down and page, the autoload is not that fast, and you are dealing with thousands of entries. Could we please have the "records per page" function back to New UI (also it shows total counts of the record) Looking forward to hear from you.

• zet pack not working

  We are using the zet pack command to package our Zoho extension. However, after running the command, the extension gets packed, but the resulting package is empty. We've attached a screenshot for reference. Could you please assist us with resolving this

• CSV File Added to Form - Parse and Map to Fields

  Hi,  I apologize, I can't seem to find a clear explanation or help article on how to parse a CSV file. On validate, I process this deluge script. fileContent = Collection(input.File_upload.content); result = fileContent.values(); info result; What I want to do is create a record (in another form), and map certain fields to fields in the form.  I can get values, which is the whole file but no keys. If I use result = fileContent.keys(); I get "0" As you can see from CSV, my first line is my map and

• Encountered an error while creating a bill in Zoho Inventory: {"code":6,"message":"Invalid data provided"}

  I attempted to create a bill using the Zoho Inventory API, but I received an error: {"code":6,"message":"Invalid data provided"}. However, when I made the same request again, it was successful. Does anyone have insights on why this happened?

• Free user licenses across all Portal user types

  Greetings everyone, We're here with some exciting and extensive changes to the availability of free user licenses in CRM Portals. This update provides users with access to all Portal user types for free to help them diversify their user licenses and explore

• Custom "Filter By" in Client Portal

  Currently our client portal only shows items for that specific person that is logged on to the portal, we want the current logged user to see all items for that user's company. An example would be invoices, so the current user would see all invoices for

• Why do I need to send the Customer ID in the Create Purchase Order Request?

  I'm trying to create a purchase order using this endpoint https://www.zoho.com/inventory/api/v1/purchaseorders/#create-a-purchase-order Unfortunately, I'm getting this error { "code": 4, "message": "Invalid value passed for Customer ID" } The doc doesn't

• How to Retrieve Serial Numbers of Items in Zoho Inventory via API?

  Hello, I am currently working with the Zoho Inventory API and need to retrieve the serial numbers associated with specific items in our inventory. After reviewing the documentation, I couldn’t find an endpoint dedicated to fetching serial numbers for

• merging email accounts

  previously I was using 5 mail pop mailboxes within VO , 2 of them are becoming obsolete so I was thinking about deleting the obsolete ones and merge the remainders into my main account mailbox within VO , is this possible ? thnx in advance.

• Queries filtered by current page/record

  I have been trying to use the new queries feature, and I can filter the query, but I'm coming unstuck because I don't understand how to make the query dynamically include the filter of the current record. ie if I'm on a deal, to filter all the records

• ZohoPeople API - Retrieve leave type IDs

  Hi All, I have created a leave type in Zoho People UI. Now I need to fetch the  Leave Type ID of it. As per the documentation[1] I used the  curl request [2]. But I ended up with the error response from the API.  {"response":{"message":"Error occurred","errors":{"message":"Server Error Occured","code":7031},"status":1,"uri":"/api/leave/getLeaveTypes"}} The new API[3] does not tell anything on how to retrieve the Leave Type ID.  Have you done any changes to the API recently. If so please let me know

• Inadequate Customer Support

  Hello & Greetings! I have been a pro Zoho user since the last 2 years and I would admit that the apps that are being offered are good, however the support we receive has a lot more to achieve. This being a design issue rather than a staff issue. Being

• Incorrect Closing Stock Amount value

  Act as Zoho Inventory Expert. We are a construction company, OVAL Projects Engineering Limited. We started using Zoho Inventory for Stock Management.I have multiple warehouses. I have encountered a problem while generating custom warehouse wise inventory

• The Next Chapter for CRM for Everyone: Moving from Early Access to Phased Rollout for Customers

  #CRM25Q1 Hello Everyone, Until now, CRM for Everyone has been available in early access mode exclusively for users who opted to try the new version. We are now transitioning to a phased release, starting with the basic edition. We are thrilled to announce

• Zoho vault uses only password to unlock not a TouchID

  TouchID works when normally openning app but when called from keyboard while browsing or trying to log to another app it shows only password option to unlock. This behaviour is only on iPad Mini witch latest 18.2OS

• Unable to add Guest Members

  We are having issues adding Guest Members to our Cliq account. We have sent out a number of request but it seems that only some people are able to access the platform. Others have received a message stating that they need to be granted access from an

• Webhook when estimate is refused is not firing

  Hello, I use a workflow through make that sends estimate with zoho books (I paid books and sign). -Those estimates when accepted are firing the webhook that I create in zoho sign (photo 1) -However when refused they are not firing the webhook that I created

• New Leave Type: Compensatory off

  Hi, there is a new Leave Type: Compensatory off. Can someone tell me how to use it, because it sounds it could work for overtime compensation for our techs. Thanks Andreas

• Invoice status on write-off is "Paid" - how do I change this to "Written off"

  HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way

• Create a custom button to modify custom fields in zoho Inventory

  I am needing a script for two buttons, 1. Button will add todays date to a custom field named cf_sent_to_sov 2. Button will mark a checkbox or unmark a checkbox field named cf_parts_ordered I have been trying to figure out deluge but have not got anywhere

• How to add a record for a different report

  I have one form and it has two reports I need to programmatically add records to both reports For example one report is draft and other is processed After the user performs some action on the draft report I want to create a new report in Processed and

• Create custom rollup summary fields in Zoho CRM

  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

• How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

  How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

• Webhook 'when estimate is refused' is not firing

  Hello, I use a workflow through make that sends estimate with zoho books (I paid books and sign). -Those estimates when accepted are firing the webhook that I create in zoho sign (photo 1) -However when refused they are not firing the webhook that I created

• Amazon Integration

  Hi, I am seller on Amazon , & I would like to sign up for Zoho books. However my question is can we automate/integrate invoicing, charges and returns in amazon with Zoho using API? Do you have a developer for this? I did take a look at zapier however it just has a create Invoice function nothing else.

• Link project tasks to tasks in CRM and/or other modules.

  Hello, I have created and configured a project in Zoho Projects with a set of tasks. I would now like to link these tasks (I imagine according to the ID of each one) to actions in the CRM: meetings, tasks, analytics). The aim is to link project tasks

• Zoho CRM API Credits & Limits for Workflow

  Hi Team, Just wanted to clarify how the API credits work for Zoho CRM and workflows with custom functions. API Credits are based on your subscription and are set at the account level. You can buy additional credits if needed. For Enterprise customers,

• Count the NUMBER of Contacts for an Account automatically

  Hello. Is there any way Zoho can count the number of CONTACTS for a particular ACCOUNT and have a field in the ACCOUNT module update itself automatically? Currently we use Zoho to administer our language school and the Contacts represent students and Accounts represent Grupos (Classes). It would be very useful for us to have a feature like this enabled, and I can see other similar applications requiring something like this. The solution would be even better if the Contacts met a specified criteria,

• How to use Twilio to send appointment notification and reminder SMS in Zoho Bookings

  Hit no-shows out of the ballpark by combining Zoho Bookings and SMS providers. SMS notifications help you remind customers of their appointments and reduce no-shows by reaching out where they are. In this guide, we'll configure an SMS provider called

• geographic search filter in map view

  Hi, I have a recruiting and timesheet system built in Creator. The client wants to enhance the search for candidates based on their location and filter by job skills - currently they look on the Map View which uses the geo location or post code of the

• Announcement: Upcoming changes to the permission grant flow for OAuth apps

  This announcement is intended for app developers who use the Zoho API console. We're going to implement an important update to the way users grant permission for the OAuth apps created through the API console. What’s changing? Currently, users can grant

• Add Google Workspace Module to Zoho Flow

  Dear Zoho Flow Team, I hope this message finds you well. We’d like to request the addition of a dedicated Google Workspace module in Zoho Flow. Currently, there are no triggers or actions for Google Workspace, which limits our ability to integrate and

• How do i remove the Powered by Zoho logo from my careers page

  Can I remove this? ​

• Totals on Pivot Table

  Is there a way to change the way the subtotal calculates? In this example I have a formula to give me the average monthly attendance ....but I want the grand total of the month to be the sum of all the average attendances...any ideas? Thank you!@

• Next Page