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


      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

                                  • Posibility to add Emoticons on the Email Subject of Templates

                                    Hi I´ve tried to add Emoticons on the Subject line of Email templates, the emoticon image does show up before saving the template or if I add the Emoticon while sending an Individual email and placing it manually on the subject line. Emoticons also show
                                  • Clarity on extended contract status

                                    Clarity on “extended” status- How does Zoho “extend” a contract?  E.g. if client extends by 1 month, can the “end date” be adjusted accordingly in Zoho and tagged as “Extended” with a clear audit trail that also captures the client’s email? Note- Email
                                  • Customizing contract status

                                    Can we customize/add/remove status on Zoho contracts ourselves or does Zoho needs to do this? Context- There is a long list of status on Zoho but not all of them are relevant for us . There are few status which are missing and needs to be added. E.g-
                                  • Set Custom Business Calendars and Holidays for Global Teams

                                    Managing a project across diverse teams means accounting for more than just tasks and deadlines; it means acknowledging how and when each team actually works. Users might follow different working days or observe region-specific holidays that cannot be
                                  • [Integration edition] Deluge learning series - Integrations between Zoho apps and Third-party services with Deluge | 28 August 2025

                                    We’re excited to welcome you to the Deluge learning series: Integration edition! The Integration edition will run for three months: Session 1 – Integrating Zoho Apps with Deluge using inbuilt integration tasks Session 2 – Integrating Zoho Apps with Deluge
                                  • Critical Vulnerability in all major password manager plugins - is Zoho Vault affected?

                                    Hi Zoho, a security researcher found a critical clickjacking vulnerability in all major browser password managers: DOM-based Extension Clickjacking: Your Password Manager Data at Risk | Marek Tóth Is Zoho Vault affected as well? Apparently the Vault extension
                                  • Introducing SecureForms in Zoho Vault

                                    Hey everyone, Let’s face it—asking someone to send over a password or other sensitive data is rarely straightforward. You wait. You nudge. You follow up once, twice—maybe more. And when the information finally arrives, it shows up in the worst possible
                                  • Tables from ZohoSheets remove images when updated from source

                                    I have a few tables from a ZohoSheet in a ZohoWriter document that will remove the images in the cells when I refresh from the source. The source still has the images in the table when I go to refresh. After updating from the source, as you can see the
                                  • Change eMail Template for Event-Invitations

                                    Hello ZOHO-CRM Team How I can change the eMail Template for Event-Invitations? I work with the German Version of the Free Version. I know how I can modify eMail alerts or Signature Templates, but where I can other eMails modify you send out? Thank you for your answer. Regards, Juerg
                                  • Inventory Adjustments

                                    Hi, How to transfer the material from one head to another ? Like materials purchased for manufacturing the laptop need to transfer from consumption inventory (Quantity of raw materials reduced) to destination inventory ( Quantity of Laptop increased)
                                  • Need Your Insights

                                    Hi Zoho, I'm confused why the flow only sends to one output. setVariable15 is from a list. It doesn't consider the 2nd entry. Any thoughts?
                                  • Map Dependency Fields - How can can I limit picklist values from a multi-select Parent field?

                                    I know the "Map Dependency Fields" feature doesn't allow a multi-select parent field. However, I need the functionality. Can I do it through a deluge function, and would it still support color coding picklists? We need the color coding for quick scanning
                                  • DYK 1 - Color Palette for Enhanced Visual Identification of Status

                                    Introducing the Did You Know series of posts. The goal of this series is to familiarize users with certain features or enhancements in Zoho Projects that may not be evident at first glance. The first post in this series deals with color palettes for indicating
                                  • Invalid field in the COQL query

                                    Dear Zoho Support! I believe that you already helped me with a similar problem a few years ago. One of my clients has a custom field named "LOB" in the "Deals" Module (see the field's metadata below). The COQL query using this field: : "select id, Deal_Name,
                                  • Automating Employee Birthday Notifications in Zoho Cliq

                                    Have you ever missed a birthday and felt like the office Grinch? Fear not, the Cliq Developer Platform has got your back! With Zoho Cliq's Schedulers, you can be the office party-cipant who never forgets a single cake, balloon, or awkward rendition of
                                  • Transferring domain registration to new registrar and switching email hosting at the same time?

                                    I need to transfer an existing domain uv cure adhesive that's currently with SiteGround to Porkbun. I also need to move the existing custom email addresses from SiteGround to Zoho Mail. I'm not sure if I should transfer the domain first and then tackle
                                  • Split deposits

                                    Can Zoho do split deposits. One deposit, two checks for two separate invoices from different customers. This is one of the most common tasks I can imaging. When I mark the two invoices paid, there are two deposits in bank register. When I try to match,
                                  • Feedback: Streamlining Note Management in Zoho Notebook

                                    Dear Team/Support, I would like to share some feedback regarding the note management system that could help improve usability and accessibility for users like myself. Notebook 1 (screenshot attached): Currently, the system does not allow selecting and
                                  • Deactivate Desk Contact without Deleting Contat

                                    We have a client who has multiple tenants for regulatory purposes, and as such, has a few users that have email addresses in both tenants. They've then emailed into the ticketing system, so we have multiple contacts (no big deal, we want to keep their
                                  • Delete my store of Zoho commerce

                                    Hi Team, I want to delete my stores of commerce. Please help me asap. Looking for the positive response soon. Thanks Shubham Chauhan Mob: +91-9761872650
                                  • Ability to add VAT to Retainer Invoices

                                    Hello, I've had a telephone conversation a month ago with Dinesh on this topic and my request to allow for the addition of VAT on Retainer Invoices.  It's currently not possible to add VAT to Retainer Invoices and it was mutually agreed that there is absolutely no reason why there shouldn't be, especially as TAX LAW makes VAT mandatory on each invoice in Europe!   So basically, what i'm saying is that if you don't allow us to add VAT to Retainer Invoices, than the whole Retainer Invoices becomes
                                  • [Free Webinar] Learning Table Series - Zoho Creator for Asset Management with AI Enhancements

                                    Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. Each month highlights a specific sector, and this time our focus is
                                  • How to set different item selling prices for Zoho Commerce and Zoho Books

                                    Item selling prices for Zoho Commerce and Zoho Books are in sync. If we update the Item selling price in Books, the same will happen in commerce and vice versa. I need a separate commerce selling price for online users and a separate books selling price
                                  • Menu Building is completely broken

                                    I have been 3 hours, I have not been able to edit the menu. Either it is completely broken, very little intuitive or I do now know anything... There is no way to create a megamenu, no way to create a menu. Despite the fact I go to menu configurartion
                                  • Can you sell Subscriptions using Zoho Commerce?

                                    In addition to physical products and the apparently coming soon 'Digital Products', it is possible to sell Subscriptions using Zoho Commerce?
                                  • Kaizen #197: Frequently Asked Questions on GraphQL APIs

                                    🎊 Nearing 200th Kaizen Post – We want to hear from you! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
                                  • Multiple Languages for Product Names

                                    Hi, I use 2 languages: spanish and english. I want to have for every product a name in spanish and a name on english. I want to have to possibility of choosing one of these languages when making an invoice or a purchase order. Is there any way to do
                                  • Item with name in different languate

                                    Hello, is there a way to have an item with its name in different languages? For example: I sell an item in different markets and I'd like to have a Proposal and the Invoice with the Item Name in a specific language. Rino Bertolotto Zoho Specialist, STESA srl
                                  • Contacts with most tickets? Alarm for multiple tickets?

                                    Is it possible to see through the analytics/reports which contacts are creating the most tickets (not the most discussed ones)? Also, is there a way to set up a notification if a contact creates multiple tickets within a certain time frame?
                                  • Issue with Template Subject Line Format in Zoho CRM

                                    Hi Team, I’ve noticed that when I update the subject line of an email template in Zoho CRM, it sometimes appears in an incorrect format when used. Please see the attached screenshot for reference. Kindly look into this issue and fix this issue from backend
                                  • Two Data Labels in Bar Chart

                                    I need to create a bar chart that has both the SUM and COUNT. I've concatenated them into a formula but it converts it into a stacked bar / scattered chart. The bar chart is no longer accessible. Since i'm comparing YOY, it would be best to have it in
                                  • Disable field on subform row

                                    Hi, Is it currently possible to disable a row item on a subform? I was just trying to do something whereby until another value is entered the field is disable but for the deluge scripting interface threw up an error saying such a function is not supported on a subform. Thanks in advance for your help. Shaheed
                                  • Leads - Kanban view fit to screen

                                    Hey guys, I created a custom layout for my leads, staged by lead status. I have 10 types of status. In Kanban view I see only 4 columns/stages and need to scroll to the right to see the rest. Is there a way to make columns/stages be displayed all together?
                                  • Request to Differentiate Auto-Closed WhatsApp Conversations in SalesIQ

                                    Hi Zoho Support, I’d like to raise a request related to the way WhatsApp conversations are auto-closed in SalesIQ. Every Monday, our Sales team has to manually review each closed WhatsApp conversation from the weekend to identify which ones were automatically
                                  • Kanban View UI gets a revamp

                                    Hello everyone, In the coming week you will notice design related enhancements in Kanban View. The UI has been changed and a new option is introduced under Kanban View Settings that allows to change the color of the category headers.  Please, note that the functionality is not changed. These changes will not apply to the Activities and Visits modules. Here are the details of the changes: 1. The column widths have been fixed to 300 px. The records will have a box around them for clear distinction.
                                  • Can you stop Custom View Cadences from un-enrolling leads?

                                    I'm testing Cadences for lead nurture. I have set un-enroll properties to trigger on email bounce/unsubscribe, and do NOT have a view criteria un-enroll trigger. However, help documents say that emails are automatically un-enrolled from a Cadence when
                                  • Issue with Anchor Link on Zoho Landing Page (Mobile/Tablet View)

                                    Hi Team, I have created a landing page using Zoho Landing Page and added an anchor link to it. The anchor link is working fine on desktop view; however, it does not work properly on mobile or tablet view. I’ve tried debugging this issue in multiple ways,
                                  • Simplest way to convert XML to a map?

                                    I've reviewed the help info and some great posts on the forum here by Stephen Rhyne (srhyne). At the moment I'm using XPath to generate a list of xml nodes, iterating through that to fetch the field name/value pairs and adding them to a map (one map for each record in the data). I then convert the row map to a string and add it to a list. Here's the function: list xml.getRecordListFromXML(string xml_data, string ele_name) {     result = List();     // get list of record nodes     rec_list = input.xml_data.toXML().executeXPath("//"
                                  • Introducing Creator Simplified: An exclusive learning series to enhance your app development skills

                                    Hey Creators! Welcome to Zoho Creator's new learning series, Creator Simplified. In this series, we'll dive into real-world business use cases and explore how to translate your requirements into solutions in your Creator application. You can also expect
                                  • [Product update] Updated Data Synchronization Process for QuickBooks - Zoho Analytics Integration.

                                    Dear QuickBooks integration users, We’re making an important update in the way data is currently synced in your QuickBooks integration within Analytics workspace. What’s changing: Previously, with every data synchronization, Zoho Analytics used to fetch
                                  • Next Page