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
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
Shwetha
Etomate Technology LLP
4_Saravanaprakash T
anthony
DPS Inc.
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 teamWhat'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 dataWe 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 constructingZoho 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
New to Zoho TeamInbox?
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
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 Learn - Public Courses
Hi guys, How can a non Zoho user enroll for a public course? cheersRich-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 versatileEmail 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 optionZoho 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 deceptiveZoho 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 intoAdd 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 beNeed 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 werePossible 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":"StageCreating 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 TemplateDarshan 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 tendZoho 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 -> EmailDeleted 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 thereEmails 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 fromReal 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 fromZoho 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 simplifiesBIN 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?!? ThanksBigin & 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 contactZoho 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 productStorage 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 , whichAddress 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 extensionsColour 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 DueImplement 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 availabilityTwo 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, appointmentsHow 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 makingCRM 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 filesA 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, rightRollup 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 featureIs 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 myWhat 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 appreciateCan 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 whereZoho 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-HowFeatures 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 consultationGenerating 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. ThanksNext Page