Kaizen #102 - Q&A Continued
Heya! Kaizen time again, folks!
Picking up the thread from our centennial post, this week we will be answering the remaining questions posted in the feedback.
Q: The ability to break down each value of Multi-picklist and handle it in the same way as "Multi-select lookup" in a custom report.
A: Steps to get multi-picklist values in the report
You can view the values selected for multi-pick list field and can filter the records using values selected in the field.
Let us look at this with an example.
Step 1: In the Reports module, select the Create Report button.
Step 2: Select the primary module for which you have to create the report. For sample, let us take the Leads module. We will not include any child module to keep this sample short and crisp.
Step 3: Click the Continue button in the top right corner of the page.
Step 4: Navigate to the left panel of the screen and edit the column list.
Step 5: Search your Multi-picklist field in the search bar and add it to the Column list.
Step 6: Now choose the Filters button next to the Column and add filter.
Step 7: Under Advanced Filters, choose the Multi-picklist field and build criteria stating that the field is not empty.
This will fetch all the records that have a value for this Multi-picklist field.
If you have not applied any advanced filters, it will fetch all the records with the multi-picklist field despite empty values.
To create filters based on the values of multi-picklist, use the contains comparator.
Following is a sample criteria:
Now, all the records with the value Option 3 in the multi-picklist field will be listed as below.
Q: Widgets using Typescript
A: Presently widget can be developed only using our JS SDK. Refer to the below link for the latest version of SDK.
Q: Why can't I access a record by using "ZDK.Page.getSubform" to get a sub form? The following code will access the record.
ZDK.Page.getField('SUBFORM_API_NAME').getValue(); ZDK.Page.getForm().getValues().SUBFORM_API_ NAME;
I am not sure of the use of getSubform
A: Currently, using getSubform() you can only set criteria for lookup fields.
For example, if you want to list the available instruments in the lookup field " Instrument Name" based on the type of Instrument selected in the field "Type" only for standard layout.
var Product = ZDK.Page.getSubform("Product_list").getField("Product_Name"); Product.setCriteria("(Product_Category:equals:"+value+")", { filterOnSearch: true }); |
For more details on how to use getSubform() refer to Kaizen #91: Dynamic Lookup filters using Client Script.
ZDK.Page.getField('SUBFORM_API_NAME').getValue() will not provide the subform record values. We are working on providing this support.
Q: We need to have more options and features under the blueprint as well as we should be able to use the Approval Process within Blueprint currently we need to break the blueprint and again create a new blueprint based on the result of the approval process.
A: Having an approval process inside a blueprint is in the works.
However, as a workaround, you can mimic the entire approval process itself in the blueprint with custom states such as "Rejected", "Approved", or ones that suit your business logic.
For more insights into this topic, please refer to this thread started in our community.
You can also refer to a few use cases in Approval Process, here.
Q: *I would like to be able to use "Map Dependency Fields" to set fields outside the sub form as parent items and fields inside the sub form as child items.
* I would like to be able to select "values contained in sub-form records" as a criterion item for layout rules. For example, suppose there are 10 records in field A (Single line) and sub forms "field B (Picklist), field C (Lookup)". I want to control the display of fields A and C based on the condition that field B "contains/not contains" n or more specified values.
* I want the ability to "include/exclude" records that contain a specific value in a subforms aggregate function.
Suppose a subforms record has a picklist "AAA, BBB, CCC". If the value is "BBB", it would be helpful to have a function that does not aggregate the items to be aggregated for that record. It would be very useful to be able to treat values contained in multiple records as conditions, so I hope this will be possible.
A: Conditional rules in aggregate fields will solve these questions and it is already under development. This feature will be available on an early-access basis, soon. We will keep you posted when it becomes available.
We hope you found answers to all your questions!
To improve our Kaizen series further and address any remaining challenges you may be facing, kindly let us know in the comments section.
Your feedback will greatly help in enhancing your experience with us. So keep it coming!
Cheers!
Access your files securely from anywhere
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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
Kiruthiga G
SOUNDTEC
Piyush Goyal
Sticky Posts
Kaizen #198: Using Client Script for Custom Validation in Blueprint
Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.Kaizen #226: Using ZRC in Client Script
Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In thisKaizen #222 - Client Script Support for Notes Related List
Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore howKaizen #217 - Actions APIs : Tasks
Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.Kaizen #216 - Actions APIs : Email Notifications
Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are
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
Card payment surcharge?
Hi, I would like to offer my customers the ability to pay invoices by card (using the PayPal integration). However, PayPal charges me around 5% to receive a card payment, and I would like to pass on this cost to my customer by way of a card payment surcharge. Is there any way for Zoho Invoice to be set up to automatically add a defined "card processing fee", say 5% of the invoice total, if the customer elects to pay by card? I don't want to add this on to invoice manually, since most of my clientsJavascript Error
I don't know how this happened but I'm constantly getting popup windows with Javascript coming from Notebook. I have no idea why this is happening. Screen shot attached. Thanks, Joe BerryZoho POS App Hanging Issue – Sales Becoming Difficult
The Zoho POS app frequently hangs and becomes unresponsive during billing, making it very difficult to complete sales smoothly. This commonly happens while adding items, during checkout, or at payment time, especially during peak hours. These issues causeTip #62- Exploring Technician Console: Send Ctrl + Alt + Del- 'Insider Insights'
Hello Zoho Assist Community! This week, we’ll be exploring the Send Ctrl + Alt + Del option in the Technician Console. Let’s jump right in. System administrators often rely on Ctrl + Alt + Del when managing remote devices that have unresponsive applicationsDisappearing Mouse cursor in Zoho Mail / Windows 11 (Chrome + Edge)
I'm seeing an issue when writing mails with the light theme with the mouse cursor being white and the document area also being white - making it nearly impossible to see the mouse cursor. I see the problem on Windows 11 under Chrome and Edge. (Yet toSKUs for Invoices, POs, etc.
It doesn't appear that one can enable SKU display on invoices, POs, etc. This is problematic, and I don't see a good reason why this shouldn't be an option. Some of our vendors and customers use this in their system. Every other identifier code is availablehow to avoid duplicate customer
How can i avoid to create a duplicate customer. I charged a same customer with two different plans and it showed up twice in my customer list and subsequently in Zoho books contacts. It creates confusion to have a same customer appears multiple times in customer or contact list. How can i avoid it.Tags with spaces
I imported notes from Evernote where tags can have spaces in them (for example "House Expenses" or "House Improvements". The import worked fine. Now I want to add a new note and assign it a tag. As soon as I type "House" followed by the space I get aRSC Connectivity Linkedin Recruiter RPS
It seems there's a bit of a push from Linkedin Talent Solutions to keep integrations moving. My Account Manager confirmed that Zoho Recruit is a Certified Linkedin Linkedin Partner but does not have RSC as of yet., (we knew that :-) She encouraged meim facing issue on generate the Estimate price
i couldn't understand what is the issue , i cant generate Estimate price where is the issuecannot be able to add user
Dear team I tried to add a new user for sales team, but after entering the OTP its showing error message cannot add nowChanging an existing item to different accounts & inventory-tracked
Hi everyone, I have an item in Zoho Books that was originally set up as a non-inventory item. Over time, I associated it with different sales and purchase accounts, and I now have many invoices, bills, and reports that use this item. My business processHow do I edit the Calendar Invite notifications for Interviews in Recruit?
I'm setting up the Zoho Recruit Interview Calendar system but there's some notifications I don't have any control over. I've turned off all Workflows and Automations related to the Calendar Scheduling and it seems that it's the notification that is sentbig 5 accounts
how do you find what accounts are listed as Big 5 ?Zoho recruit's blueprint configuration is not functioning as mapped
Current Status: Zoho Blueprint is not functioning as configured. Issue: We are moving a Candidate status in Zoho Recruit "for active file" but we encountered: "Status cannot be changed for records involved in Blueprint." This happens to various clientDelay in rendering Zoho Recruit - Careers in the ZappyWorks
I click on the Careers link (https://zappyworks.zohorecruit.com/jobs/Careers) on the ZappyWorks website expecting to see the job openings. The site redirects me to Zoho Recruit, but after the redirect, the page just stays blank for several seconds. I'mfavorites no longer listed
Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!How to add interviews through API
I'm trying to add an interview without much luck. The documentation gives examples of adding just about everything except an interview. However, the issue might be the way I'm formatting it, because the documentation is unclear to me. It seems as if the xml should be passed in the url, which seems unusual. I've tried the data as both plain and character escaped, but nothing seems to work, nor do I even get an error response. https://recruit.zoho.com/recruit/private/xml/Interviews/addRecords?authtoken=***&scope=recruitapi&version=2&xmlData=<Interviews> <rowOffer already made- but I withdrew it
I made an offer letter, but made a mistake on it. I withdrew the offer but now I can't recreate the correct offer. Zoho keeps saying that "A same offer has already been made". I look in the "offers" and there are NO offers (this is the first time I'veControl the precision of answer bot responses
Hello everyone, Admins can control the precision with which the Answer bot analyzes and generates a response by adjusting the threshold levels. Based on predefined threshold values, Zia analyzes how closely the query matches with the available KB articles.Rebrand your CRM with the all-new custom domain mapping setup
UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elatedAdd Israel & Jewish Holidays to Zoho People Holidays Gallery
Greetings, We hope you are doing well. We are writing to request an enhancement to the Holidays Gallery in Zoho People. Currently, there are several holidays available, but none for Israel and none for Jewish holidays (which are not necessarily the sameSender Email ID is duplicate
My sender id "automate@erplaunchpad.com" is coming as duplicate but I have not used it anywhere else please helpBuilding Toppings #6 - Install and uninstall actions
Hello Biginners! In our previous forum post, we explored creating connections - specifically, custom service connections in the Bigin Developer Console. In this post, we'll focus on another feature that can be used in every topping: install actions. We'llNew UI in Zoho One CRM
Hello, Just switched to the new UI for Zoho One CRM, do not like it, especially the search functions. What are the steps to backstep to the previous UI? UPDATE: I found it.App like Miro
Hi all, is there a way to have a interactive whiteboard like in Miro? We want to visualize our processes and workflows in an easy way.Important updates to your connectors
Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of theHow Do Mutliple Sales People Prospect in the "LEADS" module without calling the same leads?
We have 4 sales reps and the Leads module does not have real time intuitive knowlodge to make the sales rteps dont call the same people at the same time. How can we crate a fluent prospecting sytem where the salres reps can go out bound without callingKeeping track of project expenses
I have talked to a few support techs and it is very hard for me to believe that Zoho's project accounting software can't keep accounts for my projects. I must not understand what they're saying. We get a contract to build something. So the project revenueMailbox delegation - A secure way to enable collaboration
Admins often encounter scenarios where a user needs another team member to access and manage their mailbox during extended leave, role transitions, or while handling high email volumes. In such situations, ensuring business continuity without sharingCanvas View bug
I would like to report a bug. When clone a canvas view from an existing canvas view, if the original canvas view have canvas button with client script. Then the new create canvas view will have canvas button, it is make sense. But when I try to deleteExport blueprint as a high-resolution PDF or image file
This would be a good feature for organizations that want to share the blueprint process with their employees but don't want them to have access to the blueprint in the system settings. At the moment all that users can do is screenshot the blueprint orZoho Recruit Community Meetup - London 🇬🇧 (Venue Finalised)
Hello Recruiters! We’re excited to announce that the Zoho Recruit team is coming to the UK for an in-person Zoho User Group (ZUG) Meetup in London! This is your chance to connect with fellow Zoho users, learn from experts, and walk away with actionableIs Zoho down today?
I can't do a single thing. I tried changing some views and reports and got "undefined" - then I tried editing a form, got "undefined' - started a new form and can't add any fields as when I drag and drop it also says "undefined." What is going on? HELP.How to create estimates/Invoices with sub-totals
Every other accounting package can create estimates and invoices with Sub-totals. How can I do that in ZohoBooks?【参加無料】東京 Zoho ユーザ交流会 NEXUS ー AI エージェント (Zia Agents)の活用事例 / CRMで実現するマーケティング業務効率化
ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 3月27日(金)に東京、新橋で「東京 Zoho ユーザー交流会 NEXUS」を開催します！ ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー ✒️申し込みはこちらから：https://www.zohomeetups.com/tokyo2026vol1#/?affl=communityforumpost2 ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー ★参加のおすすめポイント ✅ AIエージェント（Zia）のリアルに使える実例を知るPython - code studio
Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already🚀 WorkDrive 6.0 (Phase 1): Empowering Teams with Content Intelligence, Automation, Accessibility, and Control
Hello, everyone! WorkDrive continues to evolve from a robust file management solution into an intelligent, secure, and connected content collaboration platform for modern businesses. Our goal remains unchanged: to simplify teamwork, strengthen data security,Support Custom Background in Zoho Cliq Video Calls and Meetings
Hello Zoho Cliq Team, We hope you are doing well. We would like to request an enhancement to the video background capabilities in Zoho Cliq, specifically the ability to upload and use custom backgrounds. Current Limitation At present, Zoho Cliq allowsISO 27001 Compliance
What are people doing to ensure ISO 27001 compliance for their Zoho environments? It would make sense for Log360 Cloud to integrate natively with the Zoho suite, but that is not the case. It requires a gateway cluster, which is not an option for a fullyNext Page