【Zoho CRM】カスタム関数：商談サブフォームのカスタム項目を見積書サブフォームに反映する方法について

【Zoho CRM】カスタム関数：商談サブフォームのカスタム項目を見積書サブフォームに反映する方法について

いつもお世話になっております。
昨日2/28のZohoワークアウトでご相談をさせていただきましたが、こちらでもあらためて投稿いたします。

【状況・やりたいこと】
弊社では、商談タブにサブフォームを設置して見積書のベースを作成し、そのデータをカスタム関数で反映して見積書データを新規に生成しています。
この仕組みを採用したのは、弊社がZoho CRMを導入した当時、見積書の標準機能では粗利を算出することができなかったためで、商談サブフォームに「仕入価格」（通貨項目）や「粗利」（販売価格と仕入価格の差額を出す数式項目）を追加することで、各商品や見積案件の粗利の妥当性を確認しています。

その後Zoho CRMの機能がアップデートされ、見積書が標準で持っているサブフォーム（見積商品）にもカスタム項目を追加できるようになったので、見積書タブ側でも粗利が確認できるように、見積書サブフォームに「仕入価格」や「粗利」のカスタム項目を作成して、商談サブフォームの同じ項目のデータをカスタム関数で引き継がれるようにしたいと考えております。

そこでカスタム関数にコードを追加したのですが、見積書サブフォームに追加したカスタム項目にデータが反映されませんでした。

ワークアウトで西尾様や松井様にコードを見ていただいたところ、商談側サブフォームのデータは正常に取得できているのに、見積書サブフォーム（見積明細）にデータが格納されていない状態ということでした。

また、Zoho CRMの帳票サブフォームは"Product_Details"という構造を使用しているという記事も拝見しておりますが、情報を取得したところ、見積書サブフォームに追加したカスタム項目は、このデータ構造に表れてこないようです。


●商談サブフォーム


●見積書サブフォーム



【質問】
商談サブフォームのカスタム項目のデータを、見積書サブフォームのカスタム項目にデータとして反映することはできますか？
また、可能な場合、どのようなカスタム関数や対応が必要になるでしょうか？

サンプルとして、テストしたカスタム関数のソースコードを添付いたします。
ご教示いただけますと幸いです。




        • Recent Topics

        • What's New in Zoho Inventory | Q2 2025

          Hello Customers, The second quarter have been exciting months for Zoho Inventory! We’ve introduced impactful new features and enhancements to help you manage inventory operations with even greater precision and control. While we have many more exciting

        • Make Packages from multiple sales order of a single customer

          Our customers sends orders to us very frequently, some times what customer wants is to ship items from 5 to 6 sales orders in a single shipment. it will be very nice if, zoho can implement this function, in which we can select items from other sales orders of the customer.

        • Print a price list or price book

          Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

        • Start Workflow from Deluge Script

          I have developed a customized process from our CRM that leverages a deluge script to create a statement of work document. Once the document has been created via the merge and store function, I would like the ability to start a workdrive review & approve

        • Show Custom Button in Portal Listview Canvas

          I have created a custom button that shows in a list view of deals (internally I can see it). I have permissions to allow this button on the portal. But it is not displaying in the canvas list? Before I do too much leg work, is this function allowed?

        • Zoho Sites "pages" management page

          I have 80 plus pages on zoho sites. When I go to the "pages" link to view and edit pages, They are not in any kind of order, so I spend lots of time searching for pages when I need to edit or create new. How can I change the view order of all my pages

        • AI feature in Zoho Desk suggesting answers based on past ticket threads

          Hi I would like to suggest something that would be very useful : instead of suggesting answers based on the Knowledge Base, I think it would be great if Zia could analyze the history of all customer and agents threads, to suggest answers in new tickets.

        • Advanced Customization of the Help Center using JavaScript

          Hello everyone, The Help Center in Zoho Desk can be customized by using HTML and CSS to provide structure and enhance the page's appearance—but what if you want to add interactive and dynamic elements? You can add these effects with JavaScript, a programming

        • Introducing Zoho POS for the Kingdom of Saudi Arabia

          Hey everyone, We are excited to kick-start December with a completely personalized edition of POS for retail businesses in Saudi Arabia to help run your operations with ease. It offers four different subscription plans—Free, Standard, Professional, and

        • Unveiling Zoho Sites 2.0 - A new dimension in website building

          Dear Zoho Sites Users, We are thrilled to announce the launch of Zoho Sites 2.0 today! This refresh represents a significant step forward in the capabilities of Zoho Sites and is crucial for creating a lasting and positive impact on our customers' businesses.

        • 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

        • Script Editor not an option

          I am trying to apply a script to a sheet and Script Editor is not an option. I don't want to go outside Sheets to do this (like Creator) if it can be done inside Sheets.

        • Zoho CRM - Writing Assistant Tone

          Hi Zoho CRM Team, Text in my emails often gets underlined in yellow because I tend to use a more informal tone with my client's, like using "I'm" instead of "I am". Is there some way for me to tell the system that this is my preferred writing tone, so

        • Not able to link email text.

          Kindly check Zoho Sites. I am unable to turn a text into a email link. The save button does not work. Kindly try yourself to see it not responding to save.

        • Migrate data from old to new account

          Hy, Have one Old Zoho Notebook Account with Data , want to migrate that whole Data to New Zoho Notebook Account which is in Zoho One . Is that possible ? If Yes then how?

        • Zoho Analytics Regex Support

          When can we expect full regex support in Zoho Analytics SQL such as REGEXP_REPLACE? Sometimes I need to clean the data and using regex functions is the easiest way to achieve this.

        • Add Custom Reports To Dashboard or Home Tab

          Hi there, I think it would be great to be able to add our custom reports to the Home Tab or Dashboards. Thanks! Chad

        • Pricing Strategies: #1 Nuances in Pricing

          When Clara first opened her digital printing shop, pricing was simple. She sold handmade greeting cards, planners, business cards, and other physical items at fixed label prices, individually and in bulk. One SKU, one price, one bill, and that's all it

        • [Free Webinar] Learning Table Series – Education Management in Zoho Creator

          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. About the Learning Table Series The Learning Table Series is a free,

        • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

          Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

        • Move attachments from one module to another with Deluge

          I have created a button that works just like the convert button for my custom modules. I would like this custom function to move any attachments in this record to the new module. I can't seem to find any documentation on how this can be accomplished.

        • Help in function code

          Hi, could someone look at the code below and tell me what 's wrong with it? After a deal creation or edition the code should find the related Account, than all open Deals for that Account and copy the field Total_Open_Deals from the Account record to

        • Automation Series: Auto-update Phase Status

          Hello Folks! You can auto-update your phase's status based on status of underlying tasks using custom functions. In this series, we will showcase how to create and run custom functions, using Deluge, with ease. Follow the steps below and automate your

        • how to add subform over sigma in the CRM

          my new module don't have any subform available any way to add this from sigma or from the crm

        • Zoho Projects - Project Details on the Project Menu

          Hi Project's team, I've helped may businesses setup and use Zoho Project and one thing I see time and time again is confusion on where to find the Project Details information. I would be much more intuitive if Project Details was on the menu before Dashboard.

        • Zoho Projects - Add Feed to Project Tabs

          Hi Projects Team, I'm working on a lightweight communications requirement for one of my customers in relation to communicating with their client users via Zoho Projects. I noticed that the Feed is only available in the Collaboration section, but you can

        • Flow - Fetch info from drop down in another module

          I am running into a road block which I thought would be a simple task. My goal - The account is assigned to a "route" which can be selected from a drop down menu and adds a tag to the account accordingly (easy enough). Now when I create a task for this

        • Show unsubscribed contacts ?

          Hello, I would like to display the unsubscribed contacts. Unfortunately, I do not have this subscription type as described in the documentation (https://help.zoho.com/portal/en/kb/marketing-automation-2-0/user-guide/contacts/contact-management/articles/subscription-type-24-1-2024#Subscription_Type_field.)

        • Zoho Developer Community Hackathon 2025 is LIVE!

          Hey developers! It’s that time of the year again — the Zoho Developer Community Hackathon 2025 is officially open for registrations! If you’ve been waiting for a chance to stretch your skills, try something new, or finally bring that idea to life, this

        • Converted Leads Not Showing in Lead Reports

          Converted leads are not showing in the Lead reports. How can I make converted leads visible in the report,

        • Text widgets in dashboards

          Having a text widget in a dashboard would help immensely. It would allow adding links to related documents, relevant CRM views, etc. It would allow adding explanations of the data displayed in the other widgets, about how to interpret them or about filtering.

        • [Webinar] Zoho Writer for content creators and publishing houses

          Managing multiple drafts, edits, and client reviews doesn't have to slow you down. Join our upcoming webinar to see how Zoho Writer helps content creators and publishing houses create, edit, and publish seamlessly—all in one place. You'll learn how to:

        • Adding Reports to Portals

          Is there a way to add Reports to portals so only the user can see report templates relevant to them?

        • How to assign one Manual to multiple Spaces?

          Hello, I have two spaces, one called tech knowledge and the other one called HR knowledge. I have a manual that is called HR tech. I want to assign this manual to HR knowledge and tech knowledge. How should I do that?

        • How can I assign courses to Spaces?

          How can I make courses show up here in this space?:

        • When will Zoho Learn be able to support SCORM files on the mobile app?

          When I click the SCORM content, I just get a message saying it's not possible yet. Yet implies that it will be coming soon. All I'm asking for is a realistic timeline so I know whether or not to invest my time in using it. If it will be soon, then I will

        • Announcing new features in Trident for Windows (v.1.35.6.0)

          Hello Community! Trident for Windows just got better with an update that makes working with your emails even more efficient. Let’s dive into what’s new! Work with PST files more efficiently. You can now do more than just view mounted PST files. You can

        • Marketing Tip #9: Track your traffic sources

          Not all marketing channels work equally well. Knowing whether your visitors come from Google, Instagram, or email helps you focus on what actually drives sales. Try this today: Check your Zoho Commerce reports or connect Zoho PageSense to see your top

        • Google Analytics import data inaccurate (as of October 11, 2025)

          We have Zoho Analytics connected to GA4 to import daily event data. This has been running without issue for a couple of years. However, a month ago we started noticing discrepancies. All data until October 10 lines up perfectly - October 11 onward is

        • E-Invoicing in Belgium with Zoho Billing

          Starting January 1, 2026, Belgium is introducing mandatory electronic invoices (e-invoicing) for all B2B transactions between VAT-registered businesses. Invoices and credits notes must be exchanged in a prescribed digital format. How E-Invoicing works

        • Next Page