Kaizen #102 - Q&A Continued

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




                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day



                                          Zoho Marketing Automation


                                                  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

                                                                                                  • 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 if
                                                                                                  • Justworks

                                                                                                    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 were
                                                                                                  • Restrict 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 zoho
                                                                                                  • How 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? - kipi
                                                                                                  • Add 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 my
                                                                                                  • Marketer'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 potential
                                                                                                  • How 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 are
                                                                                                  • restrict 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 (meaning
                                                                                                  • Introducing 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 based
                                                                                                  • CRM - 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 some
                                                                                                  • Notify 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 Luis
                                                                                                  • How 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 by
                                                                                                  • Using 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() function
                                                                                                  • Unattended 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 getting
                                                                                                  • An 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. Than
                                                                                                  • Power 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 does
                                                                                                  • Can'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 undo
                                                                                                  • Font 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 Kenya
                                                                                                  • My 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 balance
                                                                                                  • KENYA 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 through
                                                                                                  • 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
                                                                                                  • Rich 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 within
                                                                                                  • Merging 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 implementation
                                                                                                  • Unlocking 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 Zoho
                                                                                                  • Log 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 please
                                                                                                  • Report 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 owner
                                                                                                  • Document 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. Is
                                                                                                  • Syncing 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 client
                                                                                                  • Next Page