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

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

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

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

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

 


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

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


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

  

  

利用時の制限

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

 補足     

以前は関連する商談での連絡先フィルタリングのみ可能でしたが、関連取引先の項目でも絞り込めるようになりました。

今回の機能アップデートに関する該当動画(英語)は、こちらをご確認ください。     

 

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

https://zurl.co/jKTM

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

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

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

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

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


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • Emails Failing with “Relaying Issues – Mail Sending Blocked” in ZeptoMail

                                    Hello ZeptoMail Support Team, We are facing an email delivery issue in our ZeptoMail account where emails are failing with the status “Process failed” and the reason “Relaying issues – Mail sending blocked.” Issue Details Agent Name: mail_agent_iwwa From
                                  • How does Zoho handle support operations for our EU users?

                                    Dear Zoho users, We have some news and reminders about how we handle support operations for Zoho users in the EU Data Center. This is part of our broader commitment to ensuring GDPR compliance and providing secure data handling for all users. We'd like
                                  • Layout Adjustment.

                                    Hello Latha, Hope you are doing well. I wanted to check with you about adjusting the layout columns in the Service Report from the backend, as currently there is no capability for us to customize the layout from our end. Below is the output that I am
                                  • Anyone in Australia using Zoho Books AND has their account with NAB?

                                    Hi I have an account with both NAB and Suncorp. Suncorp transaction come in the next day however NAB transactions take 4-5 business days to appear. eg: A deposit made today in my Suncorp will be imported into Zoho tomorrow. A deposit made today to the NAB account will be imported maybe Saturday (Friday overnight). I have contacted both Zoho and NAB but noone seems to know why. I was just wondering if anyone else in Australia uses NAB and has this issue (or doesn't) maybe we could compare notes and
                                  • Zoho Often Lag

                                    Desk Team, We've noticed that Desk, Creator & other apps seems to lag more these days. We often refresh multiple times.
                                  • Offer 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've
                                  • Importing into the 'file upload' field

                                    Can you import attachments into the file upload field. I would expect it to work the same way as attachments do, But can't seem to get it to work. Moderation Update: The option to import into File Upload and Image Upload fields has been supported. Read
                                  • Layout Rules Don't Apply To Blueprints

                                    Hi Zoho the conditional layout rules for fields and making fields required don't work well with with Blueprints if those same fields are called DURING a Blueprint. Example. I have field A that is used in layout rule. If value of field A is "1" it is supposed to show and make required field B. If the value to field A is "2" it is supposed to show and make required field C. Now I have a Blueprint that says when last stage moves to "Closed," during the transition, the agent must fill out field A. Now
                                  • Why is the ability Customize Calls module so limited?

                                    Why can't I add additional sections? why can't I add other field types than the very limited subset that zoho allows? Why can I only add fields to the outbound/inbound call sections and not to the Call Information section?
                                  • Zoho Desk blank screen

                                    opened a ticket from my email, zoho desk comes up blank, nothing loads. our receptionist also gets the same thing under her login on her computer. our sales rep also gets same thing on zoho desk at his home on a different computer. I tried clearing cache/history/cookies,
                                  • Optimum CRM setup for new B2B business

                                    Can some advise the most common way to setup Zoho CRM to handle sales for a B2B company? Specifically in how to handle inbound/outbound emails. I have spent hours researching online and can't seem to find an accepted approach, or even a tutorial. I have
                                  • filter on sheets mobile (iOS, iPadOS) does not work

                                    I have this issue on every spreadsheet, whether imported or created natively in Zoho Sheets. I can use on desktop without issue: desktop screenshot on iOS the filter dropdowns are not there and there is no way to add them mobile iPadOS looks the same
                                  • 【Zoho CRM】商談タブへのデータインポート

                                    Zoho使用前にエクセルで管理していた商談情報を、Zoho一括管理のため、商談タブにインポートしたいのですが、お客さまの氏名だけが紐づけられませんでした。 「Zoho CRMにインポートする項目を関連付ける」のところが画像のようになっています。 (弊社では、「姓」を「★個人データ名」という項目名に変更し、フルネームを入れて使用しています。) どのようにしたら氏名をインポートできるかご存じの方がいらっしゃいましたら、ご教示いただきたく、よろしくお願いいたします。 (投稿先が間違っていましたらご指
                                  • Canva Integration

                                    Hello! As many marketing departments are streamlining their teams, many have begun utilizing Canva for all design mockups and approvals prior to its integration into Marketing automation software. While Zoho Social has this integration already accomplished,
                                  • Can't edit Segments

                                    Happening with 2 different Zoho One environments, in different browsers. Please fix.
                                  • Zoho Sheet for Desktop

                                    Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?
                                  • Transfer ownership of files and folders in My Folders

                                    People work together as a team to achieve organizational goals and objectives. In an organization, there may be situations when someone leaves unexpectedly or is no longer available. This can put their team in a difficult position, especially if there
                                  • Consumer Financing

                                    Does Zoho currently have a payment gateway (such as Stripe, Square, etc) which offers financing for customers? So, let's say the estimate we give the customer is greater than what they can afford at the time, but we can sell the service now, letting them
                                  • Subform edits don't appear in parent record timeline?

                                    Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user
                                  • Zoho CRM - Option to create Follow-Up Task

                                    When completing a Zoho CRM Task, it would be very helpful if there was an option to "Complete and Create Follow-Up Task" in the pop-up which appears. It could clone the task you are closing and then show it on the screen in edit mode, all the user would
                                  • Deluge function to copy parent record file upload field to child record file upload field

                                    I'm stuck trying to write a deluge function that is triggered via automation in child record "Appointments," confirms if a file is in file upload "Report" field of parent "Contacts" record via Contacts lookup field "Contact_Name". If no file is in parent
                                  • Zoho Books Sandbox environment

                                    Hello. Is there a free sandbox environment for the developers using Zoho Books API? I am working on the Zoho Books add-on and currently not ready to buy a premium service - maybe later when my add-on will start to bring money. Right now I just need a
                                  • Make panel configuration interface wider

                                    Hi there, The same way you changed the custom function editor's interface wider, it would be nice to be able to edit panels in pages using the full width of the screen rather than the currently max-width: 1368px. Is there a reason for having the configuration panel not taking the full width? Its impossible at this width to edit panels that have a lot of elements. Please change it to 100% so we can better edit the layouts. Thanks! B.
                                  • Image Compression Options

                                    Much better if we have level of options to compress the image [20%, 40%...] We are dealing with service reports daily that has before and after photos (image field)- the file size too large and one thing, the current limit is 10mb or 15mb for report
                                  • Cannot get code to work with v2.mergeAndStore!

                                    Please can someone help me pass subform items into a repeating mail merge table row using v2.mergeAndStore? I have a mail merge template created in Writer and stored in Workdrive. This template is referenced by a custom CRM function which merges all of
                                  • How to hide or archive a blog post temporarily in Zoho commerce website builder?

                                    I would like to temporarily hide or archive a blog post in zoho commerce website builder so that it doesnt appear on my website till I enable it again. I tried to look for this option but could not find it.  It only allows me to permanently delete a blog
                                  • Founders using Zoho — are you leveraging Zoho Campaigns + Zoho Social for thought leadership… or just sending emails?

                                    I’ve noticed something interesting in the Zoho ecosystem. Many founders use Zoho Campaigns and Zoho Social for basic marketing—newsletters, scheduled posts, and announcements. But very few are using these tools strategically to: • Position themselves
                                  • How to mix different types of inputs (such as dropdown list and textbox)

                                    Hi, I'm creating a form called "Room Reservations" for a company. I created a "table" using "Matrix Choice". I created "Room 1", "Room 2" and "Room 3" with the "Questions". I would then like to create two columns with the "Answers", one called "Department"
                                  • Reply to Email for SO/PO

                                    Hello, We are new to Zoho Books and running into an issue. Our support@ email is our integration user. When our team is sending out PO/SO's we are updating the sender email, but for some reason many of our responses are coming back to our support@ email
                                  • How to Convert NSF to PST Format Effortlessly? - SYSessential

                                    It is highly recommended to obtain the error-free solution of the SYSessential NSF to PST converter to convert NSF files from Lotus Notes. Using this professional software, it becomes easier to convert all NSF database items, including emails, journals,
                                  • Zoho Commerce - Poor Features Set for Blogging

                                    Hi Zoho Commerce team, I'm sure you will have noticed that I have been asking many questions about the Blogs feature in Commerce. I thought that it would be useful if I share my feedback in a constructive way, to highlight the areas which I feel need
                                  • Pass shipping info to payment gateway Zoho Books to Authorize.net

                                    For some reason the integration from Zoho books to Authorize.net does not pass the shipping address. Authorize.net is ready to receive it, but zoho books does not send it
                                  • Massive Zoho Books failure

                                    We have not received any communication or notification from Zoho, but we have detected that Zoho Books is not working for all our users. We cannot access or use Zoho Books. This is critical. We are trying to contact Zoho on the Spain telephone number,
                                  • Does the Customer “Company Name” field appear anywhere in the Zoho Books UI outside of PDFs?

                                    Hi everyone, I’m trying to understand how the Company Name field is actually used in Zoho Books. There is a Company Name field on the customer record, but when viewing transactions like a Sales Order in the normal UI (non-PDF view), that field doesn’t
                                  • Email outbox is now available in the sandbox

                                    Hello all! Testing emails without visibility has always been a blind spot in the sandbox. With the new Outbox, that gap is closed. You can now view and verify every email triggered from your sandbox, whether it’s through workflows, approvals, or mass
                                  • Looking For Recruit Developer

                                    Hi everyone, I am looking for a Zoho Certified Developer to assist with a development project for MetalXpert. We are building a software system designed to bridge the gap between a candidate mobile app and an employer web portal using Zoho Recruit as
                                  • sales IQ issue on website

                                    i integrated the zoho sales IQ code on the website but it is comming in distroted form i am sharing the screenshot below the website is bulit in wix platform
                                  • Multi-currency and Products

                                    One of the main reasons I have gone down the Zoho route is because I need multi-currency support. However, I find that products can only be priced in the home currency, We sell to the US and UK. However, we maintain different price lists for each. There
                                  • Deprecation of the Zoho OAuth connector

                                    Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector
                                  • I need to know the IP address of ZOHO CRM.

                                    The link below is the IP address for Analytics, do you have CRM's? IP address for Analytics I would like to know the IP address of ZOHO CRM to allow communication as the API server I am developing is also run from CRM. Moderation Update: The post below
                                  • Next Page