All Zoho Survey tables explained

All Zoho Survey tables explained



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

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.

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.

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).

This table stores basic information about a survey.

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!

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.

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

All data relating to the individual questions is stored here.

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.

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

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.

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…

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.

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

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

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

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

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

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

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

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

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
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.


    Access your files securely from anywhere







                          Zoho Developer Community






                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts



                                                      • Topic Participants

                                                      • Sven

                                                          • Sticky Posts

                                                          • What’s New in Zoho Analytics – September 2025

                                                            Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
                                                          • Announcing Agentic AI - Ask Zia!

                                                            We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
                                                          • Invitation-Based User Access in Zoho Analytics

                                                            Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
                                                          • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

                                                            Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you
                                                          • [Webinar] Evolving BI & Analytics in the Age of AI

                                                            Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations


                                                          Manage your brands on social media



                                                                Zoho TeamInbox Resources



                                                                    Zoho CRM Plus Resources

                                                                      Zoho Books Resources


                                                                        Zoho Subscriptions Resources

                                                                          Zoho Projects Resources


                                                                            Zoho Sprints Resources


                                                                              Qntrl Resources


                                                                                Zoho Creator Resources



                                                                                    Zoho CRM Resources

                                                                                    • CRM Community Learning Series

                                                                                      CRM Community Learning Series


                                                                                    • Kaizen

                                                                                      Kaizen

                                                                                    • Functions

                                                                                      Functions

                                                                                    • Meetups

                                                                                      Meetups

                                                                                    • Kbase

                                                                                      Kbase

                                                                                    • Resources

                                                                                      Resources

                                                                                    • Digest

                                                                                      Digest

                                                                                    • CRM Marketplace

                                                                                      CRM Marketplace

                                                                                    • MVP Corner

                                                                                      MVP Corner







                                                                                        Design. Discuss. Deliver.

                                                                                        Create visually engaging stories with Zoho Show.

                                                                                        Get Started Now


                                                                                          Zoho Show Resources


                                                                                            Zoho Writer Writer

                                                                                            Get Started. Write Away!

                                                                                            Writer is a powerful online word processor, designed for collaborative work.

                                                                                              Zoho CRM コンテンツ




                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Tip of the Week - Extracting Data from JSON Columns

                                                                                                            Let's say you are importing a CSV or Excel file into Zoho Analytics. What if the file contains a few columns in JSON format? This is where Zoho DataPrep, embedded right within Zoho Analytics, comes in handy. This week's tip explains how to extract data
                                                                                                          • Deluge UI Updates

                                                                                                            Are there any updates planned for the Deluge UI in Zoho Desk? It feels quite dated and lack-lustre after you've spent some time in the CRM Deluge UI.
                                                                                                          • Zia Agents - Follow Ups

                                                                                                            It would be nice to have Zia Agents do follow ups. A lot of times agents are trying to schedule things with users and they say "can we set your printer up tomorrow?" and the user never says anything. A way to have a personalized reminder to the user automatically
                                                                                                          • Hide Agents name in Ticket Responses in "My Area"

                                                                                                            We were able to hide the agents name in the emails, however, the customer is able to see which agent has responded to a ticket in the thread of emails by going into their Help Center thread. Is there any way we can hide that information?
                                                                                                          • Option to Automatically Update Extensions

                                                                                                            Hello Zoho Desk Team, We recently received an email notifying us about an extension update that must be done manually. We’d like to request a feature that allows extensions to be updated automatically without requiring manual intervention. This would
                                                                                                          • Embed Report with Auto Height

                                                                                                            Hello Developers, When we embed report within Page, we are getting one awesome feature to adjust the report height. "Auto" and "Custom' height. This "Auto" option works well when we have no records. But I want to embed report based on some conditions
                                                                                                          • Zoho Payroll: Product Updates - August 2025

                                                                                                            This month’s updates to Zoho Payroll bring enhanced efficiency and smarter features, simplifying payroll management for users in India, UAE, KSA, and US. Read on to explore how these updates can streamline your workflow. Filter Pay Runs by Type (India,
                                                                                                          • Numerical Rating for Interviewer Assessments

                                                                                                            Introducing Numerical Rating, a powerful new addition to interviewer assessments that brings precision and flexibility to candidate evaluations. ✅ What is Numerical Rating? Numerical Rating lets interviewers assign a score for each question in the assessment,
                                                                                                          • User Tips: Adding Multiple Products (Package) to a Quote v2.0 (with Client Script)

                                                                                                            This solution is an improvement on the original idea which used deluge. My solution was posted in the comments are: https://help.zoho.com/portal/en/community/topic/adding-multiple-products-package-to-a-quote The updated version uses client script instead
                                                                                                          • Are downloadable product available in Zoho Commerce

                                                                                                            Hi all. We're considering switching to Zoho Commerce for our shop, but we sell software and remote services. Is there a features for downloadable products? I can't find any information about this. Thank you very much Alice
                                                                                                          • Need Faster Help? Try Live Chat Support

                                                                                                            Hello there, We understand that sometimes, whether you’re facing an issue, exploring a feature, or need quick clarification, sending an email and waiting for a response just doesn’t cut it. You need answers, and you need them now. That’s exactly why we
                                                                                                          • Custom image for each contact using merge tag

                                                                                                            Hi, I'm wondering if it's possible to set up an email campaign to display a different image for each contact using a custom field for the image url. I tried inserting custom html: <img src='$[UD:APP_IMAGE_URL||]$'/> but the editor seemed to reject this and did not actually add anything to the email template. Has anyone got any ideas? cheers, Jeremy
                                                                                                          • Comment Reactions like a Thumbs Up

                                                                                                            Can we please have the ability to emoji react on comments or at the very least, thumbs a comment up? Literally every other project management system out there can support this and it is very much needed to just acknowledge a comment instead of completely
                                                                                                          • Zoho Mail Search Engine Sucks

                                                                                                            Hello There! I really like all the features of Zoho Mail and I believe is way better than Gmail except for the Search Function. I believe Zoho Mail has a very poor search function, if you misspelled a word in the search box, Zoho Mail won't display any
                                                                                                          • Allow Subtasks and Task Lists to have their own Layout

                                                                                                            I'd like to have the ability for subtasks and task lists to have their own layout.  A subtask for us doesn't require all the fields that a parent task has.  The subtask seems cluttered with all the extra fields. Within a project Task List had different purposes.  I'd like the task layout to be different for some task lists.
                                                                                                          • How to update Customers in Zoho Books through Zoho Flow?

                                                                                                            Updating customers in Zoho Flow using a "update customer" action is deleting contact persons in Zoho Books.
                                                                                                          • Conect chat of salesiq with zoho cliq

                                                                                                            Is there any way to answer from zoho cliq  the chat of salesiq initiated by customers?
                                                                                                          • How to transfer credit between customers?

                                                                                                            Hi All, We have a slightly odd situation. It happens that we have two separate customers that are related to each other personally. One customer has an amount of credit, and would like to use that credit to pay the *other* customers invoice. How would
                                                                                                          • Zoho Books Reports: Basic report with total items sold and Cost of goods sold

                                                                                                            How can books show a report with Item Name || Qty Sold || Total Revenue || Total Cost of Goods Sold || Margin I need to factor in also invoices that have been credited where customers returned good. This seems like such a basic report, I'm sure I'm missing
                                                                                                          • The amount entered is more than the balance due for the selected bills."

                                                                                                            Hi Team i am trying to record payments for vendors using API and getting this error in response as { "code": 28011, "message": "The amount entered is more than the balance due for the selected bills." } JSON is prepared according to Documentation and
                                                                                                          • VBA handling named ranges

                                                                                                            In VBA I'm able to work with a single cell named range. E.g. Set Jr = Range ("Year").Value. Also other options are working fine, like Range("Year").Address shows $L$3. However a named range refering to multiple cells is not working for me. Eg. tbl_Test
                                                                                                          • Kaizen #176 - Optimizing the Use of Record ID Variables in Zoho CRM Queries

                                                                                                            Hello everyone! Welcome to another week of Kaizen! Since the release of Queries, we have covered Handling Query Variables in Zoho CRM, Serialization and Schema Management, and Leveraging the 'crmAPIResponse' object in Queries in previous posts. Today,
                                                                                                          • Unbilled Items Report?

                                                                                                            Hello! Is there any way to display a list of items that remain unbilled, without creating an invoice for each customer to see if the unbilled items box is displayed? ;-) Ben
                                                                                                          • Consolidation of Multi currency

                                                                                                            Would like to discuss on the possibility of consolidating the ZOHO companies
                                                                                                          • Landed Cost Allocation / Custom Duty manual data entry

                                                                                                            My client is an import business. They must manually enter the duty for each item with landed cost allocation in Bill. This is because customs duties cannot be allocated based on Quantity, Value, Weight, and Dimensions. Manual data entry is highly time-consuming
                                                                                                          • Territories Just Don't Work

                                                                                                            I have been on chat and screenshare support for the past 3 days and am getting no resolution so hopefully, someone here can help me. I am the Super Admin of my organization. We publish books globally. I want to break down the books into territories so
                                                                                                          • Negative Opening Balance

                                                                                                            How can I add Negative Opening balance - meaning a credit balance to a Customer or a debit balance to a vendor? If I go thru Sales-->Customers, and if the opening balance is Rs. 1000 (credit balance), it does not allow me to enter a "minus" sign or mention
                                                                                                          • Single-Line Invoicing from Sales Order Despite Multiple SKUs Shipped

                                                                                                            We deal mostly with Government Tenders And Lets say we got a tender that needs 125 XYZ Laptops Then we found 95 Laptops with a different SKUs and 30 Laptops with different SKUs We talk with the IT department of the government company and they approve
                                                                                                          • 📣📣 Zoho Bookings Schedulathon 2025 is here!

                                                                                                            Hey Zoho Bookings fam, We're excited to invite you to our first-ever hackathon: Yes, Zoho Bookings Schedulathon 2025 is live now. This is a virtual event and you can participate anywhere from the world. Businesses should be able to set up meetings from
                                                                                                          • I want to send out a new newsletter each month

                                                                                                            Without rebuilding a whole journey is there a way to create a new newsletter that is sent to an existing journey monthly?
                                                                                                          • Reinstalling Workdrive Truesync client

                                                                                                            Hi, I attempted to update to the beta version of TrueSync, but it was unstable and kept crashing, so I need to revert to the stable version. How do I properly reinstall TrueSync on a Windows PC? I couldn't install the 3.15.x version directly over the
                                                                                                          • Evaluating Creator; yesterday fine; today connection times out

                                                                                                            Yesterday I spent hours creating a new app, and it worked fine. Today I cannot access creator.zoho.com. Is this common? I'm in the evaluation mode, but I'm thinking I'm going to keep looking. It worked from my home computer, and now I'm checking it from my work computer. My work computer always works just fine, so I shouldn't htink there would be special settings or anything. If there are, how to find out what they could be? Using Chrome on Windows XP The error I get is: The webpage at https://creator.zoho.com
                                                                                                          • Pivot Chart seems to show "old" data - how do I make it update?

                                                                                                            I wonder how to make a Pivot Chart "update" its data contents. Here is the background: I need to report a subset of data that is so complicated that it is easier to make a calculation and put the result in a "reporting form", and then display the data from that form.  So, I get data from the "original form" GRANTS, make some calculations and put the result in the "reporting form" PERIOD.  Now I can watch the result in a list called LIST, which works fine. The list LIST shows that form PERIOD contains
                                                                                                          • Upcoming Changes to LinkedIn Parsing in Resume Extractor

                                                                                                            Starting 31 July 2025, the Zoho Recruit Resume Extractor will no longer support direct parsing of candidate data from LinkedIn profiles. Why Is This Change Needed? In accordance with LinkedIn’s platform policies, extracting profile data through browser
                                                                                                          • how to create view in leads module to that will show all leads + converted leads?

                                                                                                            is it possible to make custom view that combine all leads + converted leads? how to do that
                                                                                                          • Reply and react to comments

                                                                                                            Hi everyone! We're excited to bring to you a couple of new features that'll make your sprint process simpler. A cloud application brings with it an array of social media features that can be efficiently used in your organizational setup. As an agile scrum
                                                                                                          • Announcing Early Access to "Zoho CRM for Everyone" — A new and exciting update to Zoho CRM

                                                                                                            Zoho CRM For Everyone is now officially available to all customers, and the Early Access Program has come to a close. We want to extend our sincere thanks to everyone who participated in the program. Your valuable feedback played a key role in shaping
                                                                                                          • Avalara Sales Tax integration - AVATAX

                                                                                                            Just wondering if anyone else is having troubles with this integration?  Seems as though Avalara changed their billing process, unbeknownst to Zoho, and now ALL transactions are counted by Avalara, not just transactions in a taxable jurisdiction.  This caused a huge price adjustment billed to us by Avalara within a month of us signing up.  And Avalara is not cheap to begin with! Avalara has been great in waiving that increase, but there seems to be no fix.  Zoho is aware of the problem, but slow
                                                                                                          • Invalid value passed for description

                                                                                                            Dear Sir, When I am entering the purchase bill , the following message showing "Invalid value passed for description" what should I do ? I am attaching screenshot. With Regards, Harish harish@cracku.in 7978841636
                                                                                                          • Zoho Creator - 2024 Release Projection 1

                                                                                                            Hello everyone! As we enter 2024, we'd like to extend our warmest wishes for success and prosperity. Your fantastic response to our Product Roadmap page last year has been incredibly motivating. Continuing on this path, we're excited to share a glimpse
                                                                                                          • Next Page