【Zoho CRM】数式項目に関する仕様変更

【Zoho CRM】数式項目に関する仕様変更

弊社サポートチームからの情報をもとに、Zoho CRM の最新アップデート情報をお送りします。
━━━━━━━━━━━━━━━━━━━━━━━━━━
▼ Zoho CRM の最新アップデート情報:https://zurl.co/Or8g
━━━━━━━━━━━━━━━━━━━━━━━━━━

今回は、数式項目に関する仕様変更について紹介します。
┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈
┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈┈

今回、各タブ内のレイアウトに追加できる数式項目の仕様に変更がありましたので紹介します。なお、数式項目についての基本情報は以下よりご確認ください。

■ 以前までの挙動
各タブのレイアウトで有効な数式項目をレイアウトから削除する際、項目を「使用していない項目」のセクション下に移動するか、完全に削除するかを選択することができました。



以前の仕様では、この処理を行った場合、項目がレイアウトには表示されなくなった後も、バックエンドで数式内に含まれる項目が編集/更新されるたびに計算が実行されていました。
このように、削除された数式項目の計算がバックエンドで実行されることにより、技術的な処理に問題が生じていました。

■ 今回の変更
有効な数式項目を「使用していない項目」セクション下へ移動すると、計算が停止されるようになりました。
今回の変更により「使用していない項目」に移動した数式項目をレイアウトに戻すと、削除した時点で記録されていた値をそのまま使用することができるので、予期せぬ数式項目の値の変更が起こらず、ユーザーの混乱を防ぐことができます。

(例)数式項目①が"項目②の値+項目③の値"を返す場合

レイアウトで数式項目を追加している場合は、正常に計算が実行されます。
以下の例では、数式項目①の値に、"項目②の値+項目③の値"が反映されています。



今回の変更により、数式項目①を「使用していない項目」に移動すると数式項目の計算が停止します。

また、該当の数式項目を再びレイアウトに戻した場合は、削除時に反映されていた項目の値のまま、それぞれのデータ内に表示されます。
そのため、以下の画像のように、削除された数式項目①の値をレイアウトに戻してみると、項目②の値の変更が数式項目①に反映されていません。



レイアウトに項目を戻した後に、数式に含まれる項目の値の変更を行うと、数式項目が再計算を始めます。



本件に関する留意事項については弊社サポートチームのFAQにて掲載しています。こちらの記事をご確認ください。
また、本社のフォーラムにも投稿がございます。こちらもご参照ください。

▼ Announcement: Unused formula fields are no longer computed

今回紹介した機能は以下のプランからご利用になれます。
  • 数式項目(カスタム項目):プロフェッショナルプラン
…………………………………………………………………………………………………………
Zoho Japan Communityのオンラインフォーラムのフォローをよろしくお願いします!

フォーラムをフォローすると、新着投稿やコメントの通知をメールで受け取ることができます。
また、特定のサブフォーラムの新着投稿の通知のみを受け取ることも可能です。
───────────────────────────
▼ オンラインフォーラムのフォロー方法はこちら

───────────────────────────
Zoho ユーザーによる活用のノウハウやアドバイスなど、運用やサービスの使いこなしに役立つ情報が満載です。ぜひこまめにチェックしてみてくださいね!
…………………………………………………………………………………………………………

    Access your files securely from anywhere









                          Zoho Developer Community




                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          Manage your brands on social media



                                                                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

                                                                                    • 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

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ




                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方







                                                                                                            • Recent Topics

                                                                                                            • Time entry preview for custom time entry templates.

                                                                                                              Our company needed time entries in a specific format to document our client interactions. Since we are using a custom time entry layout, we have lost the "preview" on the time entry tab. Using the default time entry layout, you get a small preview of
                                                                                                            • Able to change project on timelog entries

                                                                                                              Ability to move the timesheet entry from one project to another. When a user adds a wrong entry a manager can change/update the timesheet entry to the correct project.
                                                                                                            • Knowledge base: The nitty-gritty of SEO tags

                                                                                                              A well-optimized knowledge base with great SEO can benefit your company by allowing customers to find help articles and support resources using search engines. This enables customers to quickly and efficiently find the information they need without direct
                                                                                                            • Full Text Customization & Translation in SalesIQ Chat Widget Settings

                                                                                                              Dear Zoho SalesIQ Team, Greetings, We would like to request an important enhancement to the chat widget customization options in Zoho SalesIQ. Current Limitation: At the moment, only some of the text shown in the chat widget is editable or translatable
                                                                                                            • Introducing swipe actions in the Zoho CRM Android app

                                                                                                              Hello everyone, How much time do you spend each day on your list view? Probably quite a lot. Since it's such an important part of your work, wouldn't it be easier if you could take action directly from your list view instead of opening each record one
                                                                                                            • Content Security Policy

                                                                                                              Is there a place in ZOHO CRM to add a Content Security Policy to allow for a call to a google.com map, from inside our current app? Or, how do I resolve the issue below?? jquery.js:1 Refused to load the script 'https://maps.google.com/maps/api/js?v=3.41&libraries=places&sensor=true&key=AIzaSyAyQzKeKSbLci4LwZhn9oXvtCkbUo1Ae4g&callback=map_loader'
                                                                                                            • Option to select location?

                                                                                                              As a business coach, I meet with clients at various public locations. I have two or three pre-determined locations that I meet at. I would like the client to choose the location when booking an appointment. Is there a way to do that with a single service, or is the best way to accomplish this by creating one service for each location offered?
                                                                                                            • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

                                                                                                              Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers
                                                                                                            • Provide a standard structure to your content using article templates

                                                                                                              Hello everyone, When multiple writers work on different documents, maintaining a standard structure can be challenging as each of the writer follows a different writing style. However, when the structure, tone, and format of every document is different,
                                                                                                            • Accessibility Spotlight Series - 1

                                                                                                              Every user interacts with products differently, what feels intuitive to one may be challenging for another. Addressing this, accessibility is built into Zoho Project's design philosophy. This helps users navigate and perform actions with ease irrespective
                                                                                                            • Projects Tasks Not Showing Dependencies

                                                                                                              I'm clicking on tasks and the popup to add dependencies isn't showing. I can't disconnect the nodes either. For some reason when I slide a task backwards it says it cannot go before a predecessor, even though there is not predecessor. Double clicking
                                                                                                            • Deprecation of C4 endpoint URLs

                                                                                                              Note: This post is only for users who are still using the C4 endpoints. Hello everyone, At Zoho Creator, we're committed to continuously enhancing the security, performance, and capabilities of our platform. As part of this ongoing effort, we'll be deprecating
                                                                                                            • Introducing AWS authentication for connections in Deluge

                                                                                                              Hello everyone, We're incredibly excited to announce the all-new AWS authentication for connections in Deluge! This highly anticipated feature simplifies connecting to Amazon Web Services, opening up a world of possibilities and allowing you to seamlessly
                                                                                                            • Timeline Tracking Support for records updates via module import and bulk write api

                                                                                                              Note: This update is currently available in Early Access and will soon be rolled out across all data centers (DCs) and for all editions of Zoho CRM. The update will be available to all users within your organization, regardless of their profiles or roles.
                                                                                                            • Customize User Invites with Invitation Templates

                                                                                                              Invitation Templates help streamline the invitation process by allowing users to create customized email formats instead of sending a one-size-fits-all email. Different invitation templates can be created for portal users and client users to align with
                                                                                                            • ListObjects is recognized by VBA

                                                                                                              Sub addNewRow() Dim ws As Worksheet ' Set your worksheet name Set ws = ThisWorkbook.Sheets("Invoice") ' Set your table name (change "Table1" to your actual table name) ws.ListObjects("InvItems").ListRows.Add End Sub I am getting Unknown function: Li
                                                                                                            • KPI Widget dashboard select periods

                                                                                                              I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects
                                                                                                            • Need a way to secure Prefill URLs in Zoho Forms (hide or encrypt prefilled values)

                                                                                                              Hi everyone, I often use Zoho Forms with prefilled URLs to simplify the user experience — for example: https://forms.zohopublic.com/.../form?Name=David&Amount=300 However, the problem is that all prefilled values are visible and editable in the link.
                                                                                                            • Can’t send emails from Zoho CRM after adding a new user — verification codes not received

                                                                                                              Hi everyone, We recently added a new user to our Zoho CRM account and purchased an additional license. Since then, we haven’t been able to send any emails from Zoho CRM. Our Zoho Mail accounts are working perfectly, we can send and receive emails directly
                                                                                                            • CRM for email in Outlook: how to ignore addresses?

                                                                                                              We’re using the "Zoho CRM for email" add-in for Outlook. When opening an email, the add-in displays all email addresses from the message and allows me to add them to the CRM or shows if they’re already contacts. However, sometimes people listed in To
                                                                                                            • Scheduling Calls in CommandCenter / Blueprints

                                                                                                              I would love it if you could add a function to schedule a call in the lead's record for a future date. I know you can add a Task by going to Instant Actions > Task and completing the form: These tasks go into the lead's record under Open Actions. But
                                                                                                            • Quickly send emails and sync conversations with custom email addresses in CRM

                                                                                                              Editions: All editions DCs: All DCs Release plan: This enhancement has been released for customers in all DCs except IN and US. We will be enabling it for IN and US DC customers soon. [Update on 22 May 2024] This enhancement has been released for all
                                                                                                            • Zoho製品と生成AIツールの活用について

                                                                                                              いつもありがとうございます。 弊社では、Zoho Oneを契約し、CRMを軸として、見込み客の管理から商談、その後の受注や請求の管理、サポート業務(Desk)、業務データのレポーティング(Analytics)などを行っております。 Zohoサービス自体には、Ziaというツールが搭載されているかと存じますが、それ以外の外部の生成AIツールと連携した活用などもできるのでしょうか?具体的には、CopilotなどがZohoに登録されているデータや情報を見て、対話型で必要なデータを提示してくれたり、商談や蓄積されたメモなどを分析してユーザが知見を得られるような活用ができないか、と考えております。
                                                                                                            • Work with Contacts who use multiple Emails / Manage obsolete Email addresses without loosing Emails in Context

                                                                                                              Hello List Work with Contacts who use multiple Emails Only after 1 week in using Zoho CRM productively we have contacts which randomly use 2 different email addresses. From the concept I've understood that Zoho CRM offers two email fields which are recognized
                                                                                                            • New Field in CRM Product Module Not Visible in Zoho Creator for Mapping

                                                                                                              I created a new single-line field in the Products module in Zoho CRM. Zoho CRM and Zoho Creator are integrated, but the newly created field in CRM is not visible in Zoho Creator when I try to map fields.
                                                                                                            • Microsoft Teams now available as an online meeting provider

                                                                                                              Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings
                                                                                                            • I want to subscribe 1 professional user but the email only 250 per day?

                                                                                                              When I subscribe 1 professional user, I am only able to send 250 email per day? So less? Or is it typo, 2500 rather than 250? Any sale agent or friends can clear my doubt? Thank You
                                                                                                            • How to add a % Growth column for year-over-year comparison (2024 vs 2025)

                                                                                                              Hello, I am trying to build a monthly revenue comparison between 2024 and 2025 in Zoho CRM Analytics. My current setup is: Module: Deals (Affaires) Filter: Stage = Closed Won Date field: Closing Date Grouping: By Month Metrics: Sum of Amount for 2024,
                                                                                                            • How do you map a user picklist field to another user picklist field.

                                                                                                              In Zoho Projects, I'm trying to map a custom field (user picklist) in Task Details to a field (user picklist) in the Project Details. How do you get the two to map to each other? This is what I currently have that works for my other fields but doesn't
                                                                                                            • Explore Competitive 3D Scanner Prices at Protomont Technologies

                                                                                                              The genesis of Protomont Technologies emerged from the collaborative efforts of the founders in 2019, both the founders shoulder an enormous experience in the world of 3D Printing. Protomont Technology aims to craft your vision with creativity, empowering
                                                                                                            • New and improved API resources for Zoho Sign Developers

                                                                                                              Hello, Developers community! We know that for you, an API's real value depends on how quickly, easily, and reliably you can integrate the it with your application. That's why we're excited to talk about the recent improvements to our developer resources,
                                                                                                            • Project Approval Process Workflow

                                                                                                              Issue: When a new Project is created, there is lack of process/workflow that provides their manager a process to approve or review. Suggestion/Idea: Similar to “Workflow”, we need “Workflow” ability at Project level, where based on the criteria of the
                                                                                                            • Marketing Tip #5: Improve store speed with optimized images

                                                                                                              Slow-loading websites can turn visitors away. One of the biggest culprits? Large, uncompressed images. By optimizing your images, your store loads faster and creates a smoother shopping experience leading to higher sales. It also indirectly improves SEO.
                                                                                                            • Why can I not choose Unearned Revenue as an account on items?

                                                                                                              Hello, I do not understand why we don't have the ability to code an item to unearned revenue. It is not an uncommon situation to have in business. I understand that there is the Retainer invoice as an option, however that doesn't really work for us. Our
                                                                                                            • Form Submission Emails

                                                                                                              Is there a current delay with submission emails being sent? We've had 10-20 forms completed today but only a handful of emails.
                                                                                                            • Rules not working properly

                                                                                                              I created a rule to display certain fields on certain states. But it seems to be not working. It hides the fields even when I selected California, (which is a state that should show the fields when selected)
                                                                                                            • Notebook font size issue

                                                                                                              If I copy something from somewhere and paste it in my notebook, the font size becomes smaller.
                                                                                                            • Sign in process is beyond stupid. I'd rather plug my phone into USB and copy files than sign in to this POS.

                                                                                                              792 clicks and fields to fill in just to get into a 3rd rate app is too stupid for me.
                                                                                                            • cant use mail API

                                                                                                              I have generate Auth token from https://accounts.zoho.com/apiauthtoken/nb/create?SCOPE=ZohoMail/ZohoMailApi&EMAIL_ID=Zoho Mail Username or Email ID&PASSWORD=Your Zoho Mail Password and get the token but when i use that token on http://mail.zoho.com/api/organization/
                                                                                                            • Ampersand in URL parameter // EncodeURL does not work

                                                                                                              Hi Zoho, I have a url link with a parameter. The parameter is including ampersand in some cases (Can be "H&M" or "P&I") When trying to use %26 instead of "&"  (the result I get using EncodeURL()) I get H%26M instead of H&M in the parameter field. How can I solve this? Thanks! Ravid
                                                                                                            • Next Page