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
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
Client Script | Update - Introducing Commands in Client Script!
Have you ever wished you could trigger Client Script from contexts other than just the supported pages and events? Have you ever wanted to leverage the advantage of Client Script at your finger tip? Discover the power of Client Script - Commands! CommandsKaizen #165 : How to call Zoho CRM APIs using Client Script
Welcome back to another exciting Client Script post! In this post, we will discuss one of the most frequently asked questions: How do you call Zoho CRM APIs from Client Scripts? In this kaizen post, 1. Ways to make calls to Zoho CRM APIs using ClientKaizen#162 : Add Tags and Open Pre-filled Email Drafts via Client Scripts
Hello everyone! Welcome to another informative Kaizen post. In this post, let us see how to accomplish the following using Client Script. 1. How to auto-tag a record based on field update? 2. How to Open a pre-filled email draft This post will provideExtension Pointers - JS SDK series #4: Managing data from a widget using ZOHO.CRM.HTTP
Handling and managing the data between two applications is a major factor for an efficient business. There are a variety of ways to handle data between Zoho CRM and other third-party applications. You can use deluge CRM tasks, create connectors, use APIKaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved
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
Custom Fonts in Zoho CRM Template Builder
Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities ifJustworks
We are in the process of moving from QB Online to Zoho Books. Our PEO service Justworks.com had an integrations with Quickbooks but, not Zoho Books which means we will have to manually enter payroll. Anyway to integrate?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 wereRestrict Payment Methods
Allow us to restrict certain payment methods specific for each customer.domain authentification on ovh and zoho
I don't succeed in adding an domain authentification on ovh. Should i first create a subdomain? But this doesn't work either, ti gi ves te same screen and the next button is greyed out when adding the info received from zohoHow to apply customized Zoho Crm Home Page to all users?
I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipiAdd option "Avoid custom home pages" to profiles
We need our sales agents and members on each department in general to keep the same Home designed by their Managers. Let all users to create custom home pages is a huge mistake. The homepage creation must be limited by profile so only Managers are allowed to build the right home page for their subordinates.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 myMarketer's Space: Leveraging CRM Data for Dynamic Content and Personalized Campaigns
Hello Marketers! Welcome back to another post in Marketer’s Space! We’re excited to continue our series on the many advantages of integrating Zoho CRM with Zoho Marketing Automation (ZMA). This series is designed to help you unlock the full potentialHow can I understand in the search results which collection a note is in and how to immediately go to this collection?
How can I understand in the search results which collection a note is in and how to immediately go to this collection? You can call the note properties window, but only the notepad is listed there. This is very inconvenient, especially when there arerestrict access to user to create invoice
hi team we need to restrict particular users from accounts dept to create invoice directly from invoice module in zoho books . Rather , they can only able to create invoice is by using "convert to invoice" from "Sales Order" module . pls help us to solve各種書類のデータダウンロードについて（Excel形式）
ZOHO CRM で見積書/受注書/請求書など、作成した書類データを1レコード分だけExcel（or csv）形式でダウンロードする方法はあるでしょうか？ 設定→データ管理→エクスポートで抽出できるのは基本的にタブ単位で、任意のレコードのみを抽出できません。Round-Robin with Load Based Assignment, can you limit which Status are considered?
Hello, We are currently using Round-Robin with Load Base Assignment. Is there a way to exclude tickets of a certain Status from being considered by the Round-Robin Assignment rules? For example... I have the following statuses. Escalation Review (meaningIntroducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities
Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text basedCRM - Copy data from Single Line to Lookup Field
Hello, I need help to create a workflow with a custom function in order to copy value from a single value field to a Lookup Field. Module : Shipment Single value field API name : Customer_ID Lookup field API name : Account_ID WOuld be great to have someNotify on new comment
I would like to notify users when a new comment is added to ticket/request? So if someone is following request they would get email or text saying that comment has been added to this request. Or request/ticket owner get notified. Thanks LuisHow to customize the task reminder notification email
HI guys, I hope someone can help with this enquiry: We have included an additional/new field of information when an activity is assigned/created, however this new field is not part of body of the task reminder notification e-mail that is generated byUsing Zia in Zoho Sheet data to research the internet and return answer to a cell in Zoho Sheet
I'm trying to see if Zia (connected with OpenAI key) can take data parameters stored in a Zoho Sheet to conduct research out on the internet then return an answer into the same Sheet. I'm trying to do the equivalent of using something like the =AI() functionUnattended Installer failure Error 1001
I found by renaming the PC I was installing and trying again it work. This has happened several times when cloning and installing many pcs and forgetting to change the computer name before installing Zoho assist. Somehow I think the computer name is gettingAn error occurred while connecting to Yodlee. Please contact support.india@zohobooks.com and we'll help you out.
Hello Zoho, We frequently get the below error while refreshing bank feeds in Banking Tab. "An error occurred while connecting to Yodlee. Please contact support.india@zohobooks.com and we'll help you out." Ticket No 90609456 Please fix the same. ThanPower of Automation :: Trigger Automatic reminders to the task owners five days before the due date.
Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-Zoho Flow reads record Tag as number instead of text string. How do I change it?
I have experience with flow and have a number of them working. This flow is supposed to add a record in a custom module when a Contact record is edited or created with a specific tag. Trigger criteria is "Tag contains 'Athlete' ". However, the flow doesCan't retrieve url after link in note is converted
When in a text note if you paste a url after a few seconds Notebook will turn the link into a box with the title of the page that is a button to the website. You can click there dots to delete the new button but there seems to be no way to simply undoFont used in quote blocks are not consistent between devices
Hello. I noticed that as of recent, the font used in quote blocks is not the same on every device. The screenshot posted shows how it looks like on both the mobile and browser versions respectively. Personally I like the browser one more.Change my Region of registration to Kenya and not USA
help change registration region to KenyaMy running bank balance and my overview bank balance differs
Hi please assist me. Why would my running balance and my overview bank balance differs. The correct balance is my running bank balanceKENYA REVENUE AUTHORITY ETIMS/TIMS INTEGRATION AND E INVOICING
Dear Zoho, In reference to the above. I have been having challenges with e-invoicing with KRA e-tims to push my invoices and the integration. Below are some of the screenshots; Kindly help. Thank you. Will appreciate your quick response.Requiring Proxy
We are trying to get support from a company that uses Zoho assist. When we download the helper it is questing that we put in a proxy. What info do we need for the proxy / or to not need a proxy? I have tried a hot spot and allowing the program throughHow 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 makingRich Text Editor in Zoho Mail Android app
Hello everyone! In the latest Android version(v2.8) of the Zoho Mail app, we have brought in support for the Rich Text Editor on the compose screen. Rich Text Editor empowers you to create well-structured and visually appealing emails directly from withinMerging Writer Titles
When merging from CRM into Writer, is there a way to add fields to the document header? This would be very helpful for saving. Is there a way to link the document automatically to the module?Download fails
We are unable to download data. When we try, we get the message "Download failed." We have two Bases. Downloads are working in one but not the other. The Base with the problem is 'Projects'. We're trying to download Time Records from the Month view. Note:Is Zoho tables still being developed?
Has this product been abandoned? I haven't seen any useful new features or stability improvements over the past six months or more. I think Tables is a great concept, filling a niche between spreadsheets and full database tools, but the current implementationUnlocking New Horizons: A Year in Review
As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,PDF Import
Hi Guys, Zoho Sheet now supports file formats such as XLSX, XLS, XLSM, ODS, CSV, TSV, SXC, XLTX, and TXT. However, support for PDF files is not available yet. Adding this option would be very helpful. Thank you!Zoho Analytics vs Power BI vs Google Data Studio
I have been using Zoho Analytics for some time but appears that it is significantly behind Power BI and Google Data Studio in terms of functionality. Our use-case for Zoho Analytics is using data that is coming from third-party sources (and not from ZohoLog a Call Function
First, thank you for implementing the Log a Call function. It's been a frequent request on our team before we can adopt Zoho CRM, and this helps remove that. However, one small detail: the reason people wanted Log a Call was to quickly log a call's activity with the minimum effort possible. With the structure of the new Log a Call function, you have required several fields that are unnecessary for most people and that significantly slow down salespeople or CSRs in logging calls. Could you pleaseReport Builder: Create Detailed Email Report for Sent Sales Emails
I am trying to create what I perceive to be a simple report, showing which contacts have been emailed by my sales team over a certain time period. My requirements: Create a report which shows all emails sent in the past month by a particular account ownerDocument Approval Workflow for Non-Users
Our organisation has not added client users yet to Zoho but we are currently exploring how we can use the document Review and Approval Workflow to send out project updates to clients. While testing, we found that we can only pick users as approvers. IsSyncing Timesheets between Projects and Desk
All users able to see their own timelog entries from all apps in one place, synced immediately. All managers able to view total/all time entries from one place. This is something that has come up for us and multiple clients. Example: we have a clientNext Page