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. |
|
|
| 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 |
|
|
| 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. |
|
|
| 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. |
|
|
| 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. |
|
|
| 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. |
|
|
| 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 | 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) | ? |
|
|
| 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 |
|
|
| 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 |
|
|
| Respondent / Custom | Text | If the parameter is used for the response restriction, the value is Respondent, otherwise it is Custom. |
|
|
| 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. |
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
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
New to Bigin?
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, expandedAnnouncing 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 securityZoholics 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
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
【Zoho CRM】CRM for Everyoneに関するアップデート：関連データ機能
ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 今回は「Zoho CRM アップデート情報」の中から、CRM for Everyoneの新機能「関連データ機能」をご紹介します。 関連データ機能は、あるタブのデータを別のタブに柔軟に関連付け、異なるタブで管理されている情報を1か所にまとめて表示できます。 たとえば、組織タブとチームタブのデータを関連付けることで、必要な情報に効率よくアクセスでき、顧客理解を深めながら他チームとの連携もスムーズに行えます。 目次 1. 関連データの設定方法Zoho Books
How do I manually insert opening balance?Profit / margins on Sales orders / Invoices / Estimates
When we select an SKU or item name in any of these documents, much info such as invoice.line_items.rate is pulled from the item & filled into the document being worked on. If we had another lineItem DB field (hidden) auto filled at the same time: invoice.line_items.purchase_rateInventory to Xero Invocie Sync Issues
Has anyone had an issue with Invoices not syncing to Xero. It seems to be an issue when there is VAT on a shipping cost, but I cannot be 100% as the error is vague: "Unable to export Invoice 'INV-000053' as the account mapped with some items does notHow to activate RFQ? What if a price list has ladder price for items?
Where can I find the option to activate request for quotation? How does it work? If the item has ladder price, does it gets calculated depending on how many items are in the cart?Mailk got blocked / Inquiry About Email Sending Limits and Upgrade Options
Dear Zoho Support Team, My name is Kamr Elsayed I created this account to use for applying for vocational training in Germany. As part of this process, I send multiple emails to different companies. However, after sending only 8 emails today, I receivedCan't join canal Developers Zoho User
Hello, I received an invitation to join this channel, but I get an error when I try to join it, and I get the same error when I go to the Zoho Cliq interface > Search for a channel. Is this because I don't have a license linked to this email address?Desk Email reply - set default font / use custom font
Hello, in our e-mails, which we send to our customers, a certain font must be used (Corporate Design): Segoe UI https://en.wikipedia.org/wiki/Segoe#Segoe_UI How can this be included? How can this be set as the default font to ensure that this font isPDF Templates - Checkbox Borders
Is there a way to remove the border of a radio/checkbox on a PDF? I'd like to use the function of checkbox but if there's no easy way to remove the border (the PDF form already has a rectangle so it gets cluttered), then I'm forced to create a singleZoho CRM's custom views are now deployable from sandboxes
This feature is now available for users in the AU, JP, and CN DCs. This feature is now available for users in CA and SA DCs. New update: This feature is now available for users in all DCs. Hello everyone, We're excited to announce that you can now deploySettings Icon No Longer in ZOHO Desk?
In ZOHO desk, there has been a gear icon for settings. as of yesterday, it is no longer there. I showed up briefly this morning but is gone again. Anybody else experiecing this?Introducing the all-new email parser!
Greetings, We are pleased to introduce to you, a brand-new, upgraded version of the Zoho CRM Email Parser, which is packed with fresh features and has been completely redesigned to meet latest customers needs and their business requirements. On that note,Tip #43 - Track, Review, and Analyze Your Assist Sessions with Reports-'Insider Insights'
Did you know you can generate detailed reports for both remote support sessions and unattended access sessions in Zoho Assist? This makes it easy to monitor technician activity, measure efficiency, and review customer interactions. Let us now take a closerFunction #20: Custom calculation in item table of invoices
When you create an invoice in Zoho Books, the 'Amount' of a line item is typically calculated as the product of the "Quantity" and the "Rate" of the item. For instance, if an item has a sales rate of $50 and a quantity of 5 is sold, then the amount wouldCBSA - GST CHARGES on imports
Hi there, We have a questions about landed cost categorization. We received a shipment from overseas. CBSA invoiced us for the GST on the items. Now we entered the CBSA-GST as a separate bill and attached it as landed cost to the main invoice based onSimplified Call Logging
Our organization would like to start logging calls in our CRM; however, with 13 fields that can't be removed, our team is finding it extremely cumbersome. For our use case, we only need to record that a call happened theirfor would only need the followingSub form doesn't as formula field
Is it possible to get formula field in sub form in futures?Week date range in pivot table
Hello, I need to create a report that breakouts the data by week. I am using the pivot table report, and breaking out the date by week, however the date is displayed as 'Week 1 2014' format. Is there anyway to get the actual dates in there? ex. 1/6/2014-1/12/2014 Thanks,How do I get Status History data of my Projects?
I want to build a table in Zoho Analytics that Groups by Date, when Projects entered a certain status. I cannot find Status History or any such useful data available in the Setup of my Data Source sync. Please advise how I can achieve this?Is it possible to hide fields in a Subform?
Since layout rules cannot be used with Subforms, is there another way, or is it even possible, to hide fields in a subform based on a picklist fields within said subform? For example, if the Service Provided is Internet, then I do not want to see theWeekly Tips :Instantly find what you need with Attachment Viewer
Your inbox must be packed with project emails, shared notes, and scattered attachments. You are looking for one specific file—a presentation slide or maybe a media clip from a team update—but don’t want to dig through endless email threads or switch betweenPutting Watermark on Zoho Sheet
Can this be done?Missing Zoho Desk integration option for form workflows
According to the help page "Configure Zoho Desk integration in form workflows" we should be able to select Zoho Desk as an integration target but when I open the integrations list then Zoho Desk is not being listed in it. We are on the Premium plan which should already support Zoho Desk integrations.Gantt for 2 or more projects
Hello, I'm trying the free version of your produtc. It is veryyy good!!!! I don't know if in the Standard plan, I can overview a Gantt Graph for 2 or more Projects Milestone. This would be very helpfull for managing teams and taking decisions about who I will assign a task to. In the paid plan Do I have this possibility? Thank you.Integrating a Zoho Project Gantt Chart into Reports
Is is possible to integrate a Zoho Project Gantt Chart into a Zoho Report Dashboard. I am in the process of creating Project Status Dashboards for the projects that we track in Zoho Projects and I would like to incorporate the gantt chart within Reports. Please let me know! ThanksZOHO BOOKS - EXCESSIVELY SLOW TODAY
Dear Zoho Books This is not the first time but it seems to be 3 times per week now that the system is extremely slow. I work on Zoho Books 95% of my day so this is very frustrating. Zoho you need to do something about this. I have had my IT guy checkGantt Chart - Zoho Analytics
Are there any plans to add Gantt Charts capabilities to Zoho Analytics?Displaying related quotes in sales order and back
Hi, My colleague liked to see to which sales orders, the quote has been converted. Quote shows Invoices, but not SO. Same, they would like to see the quotes in the sales order, as they can see invoices, packages, shipment, How can we achieve this ? ThankTip of the Week #71–Auto-move incoming messages to the right inboxes with keywords
We all know that customer-facing teams, especially your sales and support teams, can’t afford to miss even a single customer conversation. But sometimes, sales queries or support requests can easily get lost in a crowded inbox or even end up in the wrongClearing Fields using MACROS?
How would I go about clearing a follow-up field date from my deals? Currently I cannot set the new value as an empty box.Migrating a Zoho Forms form into Zoho Creator
Hi, How can I migrate my Zoho Forms form into Zoho Creator? Thanks. Truly, EmadIs there any way to recall an email sent using Zoho CRM?
If an email is sent using Zoho Mail, there is a recall option/functionality that is available to the sender. Is there any way to recall an email if it was sent using Zoho CRM? I can't seem to find that option. Any help would be appreciated.Quick Create needs Client Script support
As per the title. We need client scripts to apply at a Quick Create level. We enforce logic on the form to ensure data quality, automate field values, etc. However, all this is lost when a user attempts a "Quick Create". It is disappointing because, fromis it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?
so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assignProblem with reports due to "Connected" items change - Yes this IS a problem
Now that the change has been made to use "connected" items I can no longer run the reporting I need in CRM. I should be able to start with Deals as the parent, connect down to the Account (Account_Name) on the deal as the child, then to any child itemsIntroducing notifications in the vendor portal
Imagine this: You're a recruiter working with multiple vendors on a high-volume hiring project. You’ve just updated a job description after a last-minute change from the hiring manager. One of your vendors, however, is still working off the older versionCRM limit reached: only 2 subforms can be created
we recently stumbled upon a limit of 2 subforms per module. while we found a workaround on this occasion, only 2 subforms can be quite limiting in an enterprise setting. @Ishwarya SG I've read about imminent increase of other components (e.LESS_THAN_MIN_OCCURANCE - code 2945
Hi I'm trying to post a customer record to creator API and getting this error message. So cryptic. Can someone please help? Thanks VarunHow to update "Lead Status" to more than 100 records
Hello Zoho CRM, How do I update "Lead Status" to more than 100 records at once? To give you a background, these leads were uploaded or Imported at once but the lead status record was incorrectly chosen. So since there was a way to quickly add records in the system no matter how many they are, we are also wondering if there is a quicker way to update these records to the correct "Lead Status". I hope our concern makes sense and that there will be a fix for it. All the best, JonathanAnalytics for notes created
Is there a way I can see how many notes were created per day? Via reporting or analytics?Next Page