New Features rolled out on April 13, 2016

New Features rolled out on April 13, 2016

Use 'Look-up' Fields in Formula columns

Zoho Reports now supports  'Look-up ' fields in formula columns. Previously, it was not possible to use formulas on a lookup field.  You can refer to the  Defining lookup   section in this  help documentation  to learn about creating a lookup. 

Note

  • This functionality will be applicable only if the lookup column has been created with the delete criteria set as  No Action on this (child) table .

You can use the lookup field to create both custom and aggregate formulas. Refer to the topic ' Adding Formulas ', to learn about creating a formula column.

Full Join Support for Query Tables

Zoho Reports now supports full join for query tables. The   FULL JOIN combines the results of both left and right outer joins.

The joined table will contain all records from both the tables and will fill in 'null' in the case of missing  values. You can refer to this video on ' How to create a query table '.

Custom Field Support in Zoho Projects Advanced Analytics Add-on

You can now include the custom fields available in your Zoho Projects portal in the reports that you create in the advanced analytics add-on. These custom fields will be automatically fetched upon the next schedule. Refer Zoho Projects: Advanced Analytics add-on to know more.

    Access your files securely from anywhere


            Zoho Developer Community




                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day



                                          Zoho Marketing Automation
                                                  • 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


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

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

                                                                                                  • Zoho Learn - Public Courses

                                                                                                    Hi guys, How can a non Zoho user enroll for a public course? cheers
                                                                                                  • Rich-text fields in Zoho CRM

                                                                                                    Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile
                                                                                                  • Email Alerts for New Audit Log Entries in Zoho Desk

                                                                                                    Dear Zoho Desk Team, The Audit Log feature in Zoho Desk is a fantastic tool for tracking changes and ensuring transparency in the helpdesk. However, to make this tool even more effective, I’d like to request an enhancement. Currently, there is no option
                                                                                                  • Zoho Meeting app update.

                                                                                                    Hello, everyone! In the latest Android (v2.3.7) and iOS (v1.7.1) versions of the Zoho Meeting app, we have brought in support for the following features: Report Abuse option. WorkDrive integration. Report Abuse option You can now report to us any deceptive
                                                                                                  • Zoho Learn - Public Courses

                                                                                                    Hi guys, How can a non Zoho user enroll for a public course? cheers
                                                                                                  • [Free Webinar] Building intuitive UI/UX with HTML & ZML in Zoho Creator - Creator Tech Connect

                                                                                                    Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into
                                                                                                  • Add Ability to Designate Decision Branches as "Error Branches"

                                                                                                    Zoho Flow gives the ability to track down, troubleshoot, and fix errors with the Status and Filter dropdowns in the History tab. This works well for when a "normal" Flow action registers with an error. However, there are other times where it would be
                                                                                                  • Need to send message to slack channel from zoho people form

                                                                                                    - I have setup slack connection in zoho people, it is successfully showing connected - I am using connection name to send message view custom function, but it is not working: response = invokeurl [ url :"https://app.slack.com/client/T78002gHF/C089773324"
                                                                                                  • 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
                                                                                                  • Possible to change Deal Stage via Deluge function in a Workflow automation when there's a Blueprint implemented for the pipeline?

                                                                                                    I've configured a Blueprint for my Deals module pipeline. I want to change the Stage value for a Deals module record through a Deluge function in a Workflow Rule, but I get this error message: "Deals record update response = {"code":"RECORD_IN_BLUEPRINT","details":{"api_name":"Stage"},"message":"Stage
                                                                                                  • Creating stunning templates for appointment notification emails

                                                                                                    Good day folks! Can you guess what we are going to check out today? We have designed a few samples to showcase the power of customizable email notification templates. Template 1 Template 2 Template 3 Template 4 Template 5 Template 6 Template 7 Template
                                                                                                  • Darshan Hiranandani : Feature Request: Allow Uploading Edited Meeting Recordings for Attendees

                                                                                                    Hello everyone, I'm Darshan Hiranandani, wanted to propose a feature that could be useful for meeting organizers. Would it be possible to allow meeting organizers to upload an edited version of the meeting recording? Here’s the use case: many of us tend
                                                                                                  • Zoho mail filter Add to WorkDrive doesnt't work

                                                                                                    Hello, We have a problem with using the filter in the email. So, we want that when a bulk payment confirmation from the online store arrives, this email is automatically saved in HTML format on the drive using the action 'Add to Zoho WorkDrive -> Email
                                                                                                  • Deleted message in SPAM

                                                                                                    In one of my gmail accounts (getnickifit@gmail.com) I had an email from PayPal in the SPAM folder. I thought I was moving the message to the inbox from the zoho mobile but it looks like it was deleted. It is no where to be found--inbox, trash, etc. Can it be restored?
                                                                                                  • i keep see there is a connetion issue connecting 3rd party api on zoho when using zia

                                                                                                    hi there , i have set up open ai api to zoho zia (copied and pasted to zoho zia) but I keep getting notificaiton "there is a connetion issue connecting 3rd party api on zoho" when using zia on top when click zia and try to type in word there
                                                                                                  • Emails take up to 14 hours to arrive and often never arrive at all.

                                                                                                    I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from
                                                                                                  • Real Estate CRM

                                                                                                    How can I tailor my CRM for real estate? I had seen an image where the CRM included property tabs.
                                                                                                  • Emails take up to 14 hours to arrive and often never arrive at all.

                                                                                                    I've been on hold on your support phone for two hours. I spent an hour waiting to talk to somebody somebody finally picked up. They asked me to give them my ID number and when I found it, they were gone they didn't hang up. They just walked away from
                                                                                                  • Zoho Desk Validation Rule Using Custom Function

                                                                                                    Hi all, I tried to find the way to validate fields using custom function just like in Zoho CRM but to no avail. Is there a way to do this?
                                                                                                  • Custom function daily limit and procedural programming

                                                                                                    Dearest Zoho Today, support confirmed that if I call a custom function from another custom function then I will use up two, with regards to my daily limit. A few times, we have blown our daily limit and that means that ordinary business processes don't run for the rest of the day. I have to mop these up the following day and there is no guarantee that I will get it right. Therefore, I can't afford to waste any. Procedural programming has been around for over 50 years now and it greatly simplifies
                                                                                                  • BIN Locations

                                                                                                    Hi, I’m new to Zoho inventory and unless Im missing something, I cannot find BIN locations anywhere in ‘items’? please tell me it’s there somewhere?!? Thanks
                                                                                                  • Bigin & Booking. Associate the appointment with existing customers in bigin.

                                                                                                    I tried to change the stage of the pipeline associated to a existing contact after he book a appointment in Booking. I use flow to create a event in booking when a appointment is done. But.... How can I relate the appointment with the existing contact
                                                                                                  • Zoho Finance Limitations 2.0 #12: Can't sync Books System Fields (Item Category or Preferred Vendor) to CRM Products. Double entry required

                                                                                                    We add products to Books and sync them to CRM whenever updates are done. However I still have to do double entry because the Books "Item Category" and "Preferred Vendor" fields are not available as options to sync. Scenario Workflow I add a new product
                                                                                                  • Storage Space Issue

                                                                                                    I made a few Header templates in the CRM email that adds some fields ( 2 fields to be exact ) to the subject line, however I ran out of "storage Space" when I need to add it to 3 more members of my team. How do I solve this ? If I need to upgrade , which
                                                                                                  • Address Input and Map Functionality Challenges in Zoho: Need Advice

                                                                                                    I just started using the Zoho ecosystem for my business. Everything seems to be working fine, except for the map features built into the applications. It's quite difficult to input an address when creating a new lead. Some of you might suggest using extensions
                                                                                                  • Colour Coded Flags in Tasks Module List View

                                                                                                    I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due
                                                                                                  • Implement Meeting Polls in Zoho Bookings

                                                                                                    Dear Zoho Bookings Support Team, We'd like to propose a feature enhancement related to appointment scheduling within Zoho Bookings. Current Functionality: Zoho Bookings excels at streamlining individual appointment scheduling. Users can set availability
                                                                                                  • Two way sync between Bookings and Zoho Mail Calendar

                                                                                                    Is there a way to enable a two-way sync between Bookings and the Zoho Mail Calendar? As far as I know, it is only possible to check conflicts from Bookings and push meetings from Bookings to the Calendar. However, when I press the sync button, appointments
                                                                                                  • How to link Custom Fields in Ticket view

                                                                                                    Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making
                                                                                                  • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

                                                                                                    Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files
                                                                                                  • A consultant with different working hours for each workspace

                                                                                                    As of now, it doesn't seem to be possible to set different working hours for a single consultant in two (or more) different workspaces. For example: A  consultant is going to work 2 weeks/month at workspace A and 2 weeks/month at workspace B. Yet, right
                                                                                                  • Rollup summary for custom module

                                                                                                    Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature
                                                                                                  • Is it possible to set a value to a field based on certain conditions

                                                                                                    Greetings Say i have a field that i want to set its value based on the value of another field.. for example if "number" field has value greater than 10, i want to set my field's value to X. Or if radio group had option 1 selected, then i want to set my
                                                                                                  • What is the Desk API?

                                                                                                    I'm trying to fetch a lookup field data from desk to our creator application and it doesn't work. I'm guessing that my search parameter is wrong? On my trial function fetch if I use these: tickets = invokeurl [ url :"https://desk.zoho.com/api/v1/tickets/351081000145244764"
                                                                                                  • How to Parse XML Data Returned by API?

                                                                                                    I have several APIs integrated with my CRM and they work great. I am having some trouble though parsing data out of a large string/array in Funtions? I need to be able to pull the DeviceId and the WebSiteDeviceName from each PanelDevice. I would appreciate
                                                                                                  • Can the meeting location be specified by the customer?

                                                                                                    I own a painting company. I offer free estimates to customers, and I'd like them to be able to enter the meeting address in the booking form... so, the place they want me to give a painting estimate for. I need the customer to be able to tell me where
                                                                                                  • Zoho Bookings - Reserve with Google

                                                                                                    Does Zoho Bookings plan to to integrate with Reserve with Google?
                                                                                                  • Single use booking

                                                                                                    Hello everyone! It would be very interesting to be able to generate unique booking links. Once a booking is made through that link, it will no longer work. Calendly has something similar: https://help.calendly.com/hc/en-us/articles/1500001292022-How
                                                                                                  • Features Req: Service-Specific Calendar And Limit number of bookings per guest

                                                                                                    By The Grace of G-d. Hi, I Came across 2 features i believe more users would love to see added to the amazing bookings app: 1. Service-Specific Calendar I dont want to open my whole calendar to all of my services. For Example, Lets say i have a free consultation
                                                                                                  • Generating Discount Coupons for Zoho Bookings

                                                                                                    Hi, Is there provision to generate Discount Coupons for appointment bookings? I could not see that in the settings and this is very much needed. Please suggest us. Thanks
                                                                                                  • Next Page