【Zoho CRM】フィルター機能のアップデート：ルックアップ項目を使ったデータフィルタリング

【Zoho CRM】フィルター機能のアップデート：ルックアップ項目を使ったデータフィルタリング

ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。
今回は「Zoho CRM アップデート情報」の中からフィルター機能のアップデートをご紹介します。
 
ルックアップ項目を使ったデータフィルタリングがより詳細に行えるようになりました。
​この機能は詳細フィルターとカスタムビューで利用でき、必要な情報を正確に取得できます。

これにより、タブ間を移動することなく、より深く正確な方法でデータを絞り込むことが可能になります。

◉できること
  • 詳細フィルターとカスタムビューで、ルックアップ先タブの項目が選択可能
  • 複数タブの項目を組み合わせたデータの絞り込み
  • 抽出データへのマクロ実行・一括メール送信・項目更新などの操作が可能
◉活用例
  • マーケティング - 取引先の業種や年間収益で顧客を絞り込み、ターゲットメールを配信
  • 購買管理 - 仕入先の評価に基づいて製品リストを抽出
  • 保険業務 - 契約期間や保険料額で契約者をフィルタリング

 

取引先業種別の連絡先フィルタリング 

画面左にあるフィルターの設定エリア内にある「フィルター条件：関連タブ」から、該当のタブに関連づけられている任意のルックアップ項目を選択します。
「フィルターを適用する」を選択すると、ルックアップ項目を基準としたフィルターが適用されます。


また、本アップデートからルックアップ項目におけるデータ名の検索欄がドロップダウン形式に変更されました。
これにより、検索時に直接データを選択することが可能です。

  

  

利用時の制限

  1. フィルターで使用できるルックアップ項目は最大3つまで(関連タブやサブフォームの項目を含む)
  2. ルックアップ先のタブからは最大5つの項目まで追加可能

 補足     

以前は関連する商談での連絡先フィルタリングのみ可能でしたが、関連取引先の項目でも絞り込めるようになりました。
​
今回の機能アップデートに関する該当動画（英語）は、こちらをご確認ください。     

 

いかがでしょうか。CRMをご利用中のユーザーさんは、ぜひ試してみてください！

https://zurl.co/jKTM

Info
適用範囲：プロフェッショナル、エンタープライズプランのJP(日本)、AU(オーストラリア)、CN(中国)データセンター

……………………………………………………………………………………………………………………

Zoho オンラインフォーラムの最新情報をいち早く入手しませんか？

Zoho Japan Community フォーラムの「フォローする」ボタン(右側)をクリックすると、最新の投稿やコメントをメールで受け取れます。

フォロー方法
  • フォーラム全体をフォロー：フォーラムトップページの「フォローする」をクリック
  • 特定のトピックのみフォロー：興味のあるサブフォーラムを選択し、「フォローする」をクリック
コミュニティのイベント情報も当フォーラムでお知らせしますので、ぜひフォローをお願いします！

      • Recent Topics

      • Add Actionable “Smart Commits” for GitHub Integration

        Hi Zoho Projects Team, I am submitting a feature request to introduce Smart Commits support for the GitHub integration in Zoho Projects. The Current Limitation: Currently, Zoho Projects offers a "passive" integration. Including a Task ID in a commit message

      • Item Details Field - New Barcode / Document option?

        Is this a new feature??? its in both books and inventory.

      • Items attribute questions

        Many of my items have attributes, such as size and color. How can I add new fields to the "New Items" screen to capture that in my Purchase Orders, Items, and Sales Order pages? I only see these attribute fields when adding an Item Group. Also, on the

      • SEO recommendation of H1 tag for website tittle

        The exact words are “ It is good practice to place the page title inside the H1tag.” Now I already have one H1 tag on my website but it is not website tittle. In the SEO recommendation that is clear too that I have h1 tag on my page. Now I don’t know

      • Anyone Building AI-Based SEO Dashboards in Zoho Analytics?

        Hey everyone, I’m currently working on an SEO reporting dashboard in Zoho Analytics and looking to enhance it with AI-based insights—especially around AI visibility, keyword trends, and traffic sources. The goal is to track not just traditional metrics

      • Knowledgebase SEO

        We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by search

      • Marketing Tip #15: Rank better with keyword-rich URLs for product pages

        Your product page URL is a small detail that can make a surprisingly big difference. Clean, readable URLs help in two ways: They’re easier for customers to trust and remember (no one likes clicking a link that looks messy or random). They help search

      • Marketing Tip #26: Optimize product images for SEO

        Product images can do more than make your store look good. They can also help customers discover your products through search. Since search engines can’t "see" images, they rely on text signals to understand what an image is about. Two small actions make

      • Zia Agents in Zoho CRM: a better way to set up digital employees

        Hello everyone, If you've been using Zia Agents in Zoho CRM, so far using Connections was the only deployment method you're familiar with. You create an agent in Zia Agents (define its objective, write instructions, use tools, add knowledge base) and

      • Cross Module Filtering – Use Fields from Lookup modules in Custom Views criteria and Advanced Filters

        Hello everyone, Zoho CRM now enables you to achieve deeper filtering of records in a module, using fields of a lookup, thereby enhancing your data management experience manifold. This filtering based on lookup module fields is now available in advanced

      • How can we use Loop Structures in Deluge script?

        Hi, I am using GetRecords() function to fetch records from a module in Zoho CRM,  the number of records is 800+, but GetRecords() function returns 200 records at one time,  So, I want to use loops to achieve my task, but it gives me error when i use any loop instead of For each loop. How can I perform my task? Please help Zoho community. Thanks 

      • Stock Count

        The stock count is a nice new feature, but we cannot figure out how to: 1. Use it without assigning to a person, we have a team or one of multiple do stock counts as do most any company. 2. Add any extra fields to what the "counter" sees. The most important

      • SalesIQ Operator Activity Reports in Zoho Analytics

        I'm busy building a dashboard in Zoho Analytics and I want to include SalesIQ stats in the dashboard, but I'm unable to get the statistics mentioned in the attached image. Any idea where I can get the stats for Operator Activity?

      • Multi-Select Field Option Limit Inquiry

        Hello FSM Team, We would like to inquire about the limitation of the Multi-Select field in Zoho FSM. Currently, the system allows a maximum of 10 selectable options, and we encountered the message: “Option count more than allowed count of 10.” Issue:

      • MS Teams integration

        I followed all the steps to configure the bot chanel notifications, for all events. All configuration worked fine, without issues, but I don´t recevie any notification in the Teams chanel. Must I configurate aditional permission set in MS 365 or Zoho

      • Zoho Bookings - Feature Request - Services Which Include A Resource and Consultant

        Hi Bookings Team, My feature request is to have the ability to add Consultants and Resources to Services. Use case: Your business provides first aid training and there are certain equpment you require to provide the half day training. There are only specific

      • Six important date functions every professional should know

        You probably use plenty of formulas already, but there are some that are essential for people in business roles, such as date functions. These tools help with scheduling, predicting, and tracking, and they can be useful whether you're dealing with payrolls,

      • Inactive Items - Make Less Prominent by Default

        Currently, when one marks an Item as "Inactive", it really doesn't do much of anything to hide it or get it out of the way. Search and reporting within Finance should, by default, hide inactive Items from standard reports, searches, etc. If one specifically

      • Why Contracts Should Not Be Downloaded And Sent During Negotiation

        During contract negotiation, it may seem easy to download a document, send it to the counterparty, have the counterparty make changes, and send it back. But this approach creates serious risks around security, version control, and compliance. ISO 27001:2022

      • Add Native “Create GitHub Branch” Action for Tasks and Bugs

        Hi Zoho Projects Team, I would like to submit a feature request to enhance the GitHub integration in Zoho Projects by adding the ability to initiate a GitHub branch directly from a Task or Bug. The Current Limitation: Currently, Zoho Projects lacks a

      • Super Admin Logging in as another User

        How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Moderation Update (8th Aug 2025): We are working

      • Solving the bug in Zoho Writer API for styling

        So... the Zoho Writer APIs for programatically creating a document do not respect a template's style. The result is that any document you generate via API needs to be manually, paragraph by paragraph, reformatted. That bug alone is sufficient to render

      • Is anyone else experiencing downtime on Desk?

        Desk is slow/crashing and not stable the last couple of hours. Is anyone else experiencing the same issues?

      • Push Notification for New Bookings in Zoho Bookings App

        when a someone schedules an appointment through the booking page, is there any option to receive a push notification in the mobile app?

      • Data Import into Zoho Forms

        Hi everyone, I am migrating several Google Forms into Zoho Forms. I can recreate the forms, but I also need to bring over historical response data currently stored in Google Sheets. I want to keep using that data inside Zoho for analysis, reporting, and

      • Add Native GitHub Pull Request Creation & Management from Tasks/Bugs

        Hi Zoho Projects Team, I am submitting a feature request to enhance our development lifecycle by enabling native GitHub Pull Request (PR) creation and management directly within Zoho Projects. The Current Limitation: Currently, the GitHub integration

      • Zoho Projects API requests limit question

        Hello, Regarding the API request limit of 100 requests per 2 minutes, I have implemented a control mechanism which, if the limit is reached, will wait the required amount of time before sending new requests. However, this mechanism seems to be failing,

      • What is the esacalation email for Zoho Support/ Zoho One/ Zoho Workplace ?

        Hello, My business has been stalled due to Zoho duplicating workdrive with switching on zoho one trial. There are two workdrives - one with my files mapped to workplace and one empty mapped to zoho one.-- integrationg programs are super consfused and

      • How to show Assemblies AND component items in a report

        Hi Is there any way in Analytics to create a report that shows the Composite Item AND the Component Items with mapped quantity? It seems that the component item is not exposed in any table that I can find. Also, the same question but for Stock on Hand.....this

      • How can I use the API to add a drop-shipping address to a sales order for one-time use?

        I need to be able to add a drop-shipping address for one-time use to a sales order via the API. Adding every such address to the contact (customer), then feeding the shippingaddress_id into the sales order, is not an acceptable approach; we have some

      • Mass Update Option for Changing Work Order Owner

        Hello FSM Team/Mr. Abid, We would like to inquire if there is an option to mass update or bulk change the Owner of Work Orders in Zoho FSM. Current Situation: At the moment, the Owner of a Work Order can only be changed individually, which becomes time-consuming

      • Make and receive calls from Bigin's Android app

        Hello everyone! We're happy to announce that Bigin's Android app (version 2.0.0) now supports built-in telephony, RingCentral, and Zoho Voice, all of which enable users to make and receive calls from the Bigin app. You can only configure the telephony

      • Account Watchlist: Order of accounts in the watchlist

        Is there a way we can sort the order in which accounts are shown in the accounts watchlist in Zoho Books dashboard?

      • GST composition scheme dealer - treatment for client expenses reimbursement

        Hello, I am new to GST and need your help. I am registered as a composition dealer and attract 6% gst charges. In bill of supply, there are also expenses done on behalf of client for which I seek reimbursement AT ACTUAL with NO MARKUP. As I understand,

      • Zoho Books: tax is not automatically pulled from product-data anymore - why?

        Hi, until a short time ago, you could set a default taxrate for each product/item. This taxrate automatically appeared each time the item was chosen in an invoice or quote. Why does this not work anymore? The field is still there at the product record,

      • Kaizen #237 - Zoho CRM APIs: GraphQL & COQL- When to use which?

        Hello everyone, Welcome to another week of Kaizen. This Kaizen post discusses Zoho CRM GraphQL APIs and COQL APIs and is meant to be a decision guide on selecting between them. It aims to help developers to choose the most efficient approach in different

      • Deluge Update Function

        I am struggling to get this function to work no matter what changes I make - this is the constant error (my code is 30 lines long): Data type of the argument of the function 'get' did not match the required data type of '[BIGINT]'at lineNumber 31 I am

      • Option to Convert Request to a Specific Work Order (Parent WO Linking)

        Hello FSM Team/Mr. Abid, We would like to inquire if it is possible to convert a Request into a specific existing Work Order (as a child or linked Work Order) instead of always creating a new one. Context: An inspection/emergency Work Order is completed

      • Automation of CRM Items to FSM Work Order (Parts Section)

        Hello FSM Team, We would like to inquire about the possibility of automating the transfer of item details from CRM to FSM Work Orders (Parts section), specifically for LPO WO Job type. Currently, in CRM, we have detailed item information including: 1.

      • Introducing Product Catalog in Bigin

        Greetings, I hope all of you are doing well. For many small businesses, sharing products and collecting customer interest often involves multiple tools, manual follow-ups, or even building a full ecommerce website. To address this challenge, we're excited

      • Next Page