【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 Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      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 Campaigns 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

                                • Getting error during inserting a record in form of zoho people using zoho api

                                  import requests import json # Set your access token and Zoho People API base URL access_token = '1000.XXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXX' api_base_url = 'https://people.zoho.in/people/api/' # Set the form name and data to be inserted form_link_name
                                • Display your zoho contact name when they call your mobile number

                                  As per the title If a contact calls the office number, the contacts name shows on mobile as long as I have their contact details registered in my crm. Is there a way that if the contact calls my mobile, their name can be displayed? Currently just their number shows when they call.
                                • Change script to add fields

                                  Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs
                                • 1 API to all channel

                                  hi zoho team: I am the product manager of anywheel, we are planning to integrate zoho, we want to integrate multiple channels through 1 API, please can you send me the integration document and guideline?
                                • 🎄 Jingle, Mingle, and Automate: Spread Christmas Cheer with Zoho Desk Auto-Replies! 🎄

                                  Hello Everyone! Welcome to this week's episode of the Community Learning Series. Christmas is in the air, and I’m sure we can all feel the jingle and the mingle of the season! The folks at Zylker Techfix are no exception—they’re busy with holiday plans
                                • Macro Email to be determined by a ticket field

                                  Hi, we are a commercial energy brokerage and are implementing Desk as our helpdesk tool to replace manual emails, personal whataspp and telephone. We have setup a macro rule when we can trigger an email, update ticket status and trigger a task.... but
                                • Custom Profile Agents Unable to Update Mandatory Phone Number in tickets under Zoho Desk

                                  Hi, While working in the Ticket module in Zoho Desk, agents with a custom profile are unable to update the Phone Number field (which is mandatory) under Account Information. The agents need to enter values such as "NA" or "Nil" in the field to close the
                                • Revamped Print in Zoho Sheet—customized for paper

                                  The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
                                • Adding Bluesky channel

                                  Hello, Is Bluesky (AT protocol) soon added on Social ? Bluesky is being developped and is now open to anyone (no more invitation) Thank you
                                • How Can i put a form in Zobot

                                  Hi,how can i integrate a form which has a multiple options to choose from.the form should be opened or displayed by zobot after it meets a requirement in the conversation. Thanks in advance !
                                • Query table pull last 12 months

                                  I am tying to pull the following criteria and the date is always what causes me the issue. I want to pull people (pco_id) who have entries of "event_id" being these 2 events and whos "kind" is Regular or Guest and where the event_starts_at (date column)
                                • Unified customer portal login

                                  As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is that
                                • Response Violation - Zoho Desk

                                  Hi Team, I just need an information regarding the zoho desk - Response Violation and how can we avoid the tickets from getting the tickets response violated.
                                • message on click of button

                                  Hi, i added insert task on 'Quick view' below  'Action'  of report just below 'Delete' button,  so i am trying to add a message on click of button that, "This item is now added into Pending Request" like this .... So, how can i achieve this ; because
                                • Is it possible to disable Chat Waiting Time, or to make it indefinite?

                                  We have used many online chat services over the years. However, Zoho's SalesIQ appears to be the only one we've tried that has a mandatory time limit where we must respond to new customer queries. We are a small business so we have no dedicated staff
                                • Access CRM Variables from Formula field

                                  Is it possible to use a CRM variable (defined in Developer Space -> CRM Variables) in a formula field for calculations ?
                                • Client Script: $Client.refresh({ triggerOnLoad: true }); not triggering onLoad Client Scripts

                                  Hey friends! I'm trying to store a temporary var, refresh the page for the user, then check that temporary var and do some actions. Theoretically using the title's code: $Client.refresh({ triggerOnLoad: true }); should refresh the page and trigger on
                                • Super Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard

                                  Hi Zoho Team, I need help with an issue I've encountered. Despite using the Super Admin login to delete certain folders and passwords and clearing the trash folder, they are still appearing on my dashboard. I would like to understand why this is happening
                                • Pulling Specific Products from Sales Orders in Books to a CRM Record

                                  We currently process orders directly through our website (woocommerce) as well as through manual sales orders in zoho books. When an order comes through the website, all of the individual products from that order show up in the CRM record of that customer.
                                • Automatically add a retainer to every estimate

                                  Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,
                                • Clear String field based on the value of other field

                                  Hello everyone, We would like to be able to clear a string field (delete whatever has been written and make it empty) when another field (picklist) is changed to a specific value. While I can empty other types of fields, I noticed that I can't do this
                                • Custom Deal Name in Lead Conversion Mapping

                                  I know there are ways to change the name of a Deal after conversion using a custom function, so no need to repost that information. I would like to see the CRM Improved with Deal Name Customisation and I think the Lead Conversion Mapping page would be
                                • Within the Basic KPI component in Analytics, it is impossible to set "next" day range as a filter

                                  Hi there, I am currently setting up a deal dashboard for the Sales team. While it is possible to filter deal records to show records that were created LAST X days only, it looks like a NEXT X days Closing date filter is not available. Would it be possible
                                • Invoice status on write-off is "Paid" - how do I change this to "Written off"

                                  HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way
                                • For each loop with available time slots

                                  I am very new to Deluge, and this question was unable to be answered by Zoho Creator tech support upon request. Task at hand: I have a Form with 4 fields: - Date Start - Date End - Dropdown: Time Start: contains time slots (12:00PM, 12:15PM, etc) - Dropdown:
                                • Can we have Backorder Management ?

                                  Can we have Backorder Management ?
                                • Converting Amazon Sales Order to Invoice

                                  Hi there, We need  advice on the Amazon integration with Zoho Inventory. Now, we want to convert all the Sales orders synced from Amazon to Invoices. We want also to include and record the Amazon fees associated with the sales (Amazon fees, FBA fees, Cost of Advertising etc.) However, Sales order only captures the sales proceeds (Gross Sales) in Zoho Inventory. Does anyone currently work with Amazon and can suggest how to correctly process the sales and Amazon payments through Zoho Inventory and
                                • Zoho Inventory | Can't uncheck/turn off Advance Tracking

                                  Hi, I wanted to know if there's a way to turn off Advanced Tracking (such as Serial Number or Batch Tracking) for an item in Zoho Inventory. I’ve read that you might need to delete associated transactions and clear the opening stock to disable these features.
                                • No Hope for Zoho Meeting

                                  Zoho Meeting is just the poorest meeting app I've come across in a long time. The support sucks too. I called to see if there was anything that could be done on the backend and while I was on a test meeting with support the video was lagging and freezing
                                • Landed Cost application to Vendor Bills from dropship Purchase Orders

                                  When trying to apply a Landed Cost to a Vendor Bill generated from a dropship Purchase Order, the Landed Cost pop-up window generates a message that "Landed Cost cannot be applied to Bills from dropship Purchase Orders" when trying to save the landed
                                • Condition-based data sharing rules are now available in CRM

                                  Dear All,   We are excited to introduce a much awaited feature: condition-based data sharing rules. We'd love to explain more about this enhancement.   Specify record conditions in data sharing rules Data sharing rules enable you to share all the CRM
                                • 2 serial numbers for 1 item (Mac address and Serial number)

                                  There is a way to track 2 serial number type for 1 Item. Ex: Some electronic devices have a MAC address and a serial number. I need to track those 2 numbers
                                • Zoho Projects Roadshow, USA - 2024

                                  Dear Users, We are happy to announce the Zoho Projects Roadshows 2024 in USA. This is an excellent opportunity to learn more about Zoho Projects and gain in-depth knowledge of the advanced features. Our team will also discuss industry specific solutions
                                • [Zoho Writer Webinar] Tips on collaboration control in Writer

                                  Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for the month of October 2023: Tips on collaboration control in Writer. This webinar will help you understand the various features available in Writer to control collaboration. We'll
                                • [Zoho Writer Webinar] Working with tables in Zoho Writer

                                  Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for the month of September 2023: Working with tables. This webinar will help you understand the various ways you can use tables to meet your specific needs. The webinar will take
                                • [Zoho Writer Webinar] Customize Writer to suit your business process

                                  Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for the month of August 2023: Customize Writer to suit your business process. This webinar will cover the various ways to customize Writer to streamline business processes and improve
                                • Why is Zoho Meeting quality so poor?

                                  I've just moved from Office 365 to Zoho Workplace and have been generally really positive about the new platform -- nicely integrated, nice GUI, good and easy-to-understand control and customisation, and at a reasonable price. However, what is going on
                                • Is there a way to print the dashboard?

                                  I would like the capability of printing the dashboard - is that possible?
                                • Workflows for Timesheet

                                  Good day, Any way to have timesheet as triggers? I looked into Zoho Flow and into Zoho Project automation but no where can I have timesheet as a trigger. Basically, I would like to trigger something upon timesheet approval. Right now, the only way to
                                • Linkedin - Recruiter System Connect

                                  Hi there! Does anyone here know how to connect Zoho Recruit to Linkedin Recruiter via Recruiter System Connect?
                                • Next Page