【Zoho CRM】カスタム関数：商談サブフォームのカスタム項目を見積書サブフォームに反映する方法について
いつもお世話になっております。
昨日2/28のZohoワークアウトでご相談をさせていただきましたが、こちらでもあらためて投稿いたします。
【状況・やりたいこと】
弊社では、商談タブにサブフォームを設置して見積書のベースを作成し、そのデータをカスタム関数で反映して見積書データを新規に生成しています。
この仕組みを採用したのは、弊社がZoho CRMを導入した当時、見積書の標準機能では粗利を算出することができなかったためで、商談サブフォームに「仕入価格」（通貨項目）や「粗利」（販売価格と仕入価格の差額を出す数式項目）を追加することで、各商品や見積案件の粗利の妥当性を確認しています。
その後Zoho CRMの機能がアップデートされ、見積書が標準で持っているサブフォーム（見積商品）にもカスタム項目を追加できるようになったので、見積書タブ側でも粗利が確認できるように、見積書サブフォームに「仕入価格」や「粗利」のカスタム項目を作成して、商談サブフォームの同じ項目のデータをカスタム関数で引き継がれるようにしたいと考えております。
そこでカスタム関数にコードを追加したのですが、見積書サブフォームに追加したカスタム項目にデータが反映されませんでした。
ワークアウトで西尾様や松井様にコードを見ていただいたところ、商談側サブフォームのデータは正常に取得できているのに、見積書サブフォーム（見積明細）にデータが格納されていない状態ということでした。
また、Zoho CRMの帳票サブフォームは"Product_Details"という構造を使用しているという記事も拝見しておりますが、情報を取得したところ、見積書サブフォームに追加したカスタム項目は、このデータ構造に表れてこないようです。
●商談サブフォーム
●見積書サブフォーム
【質問】
商談サブフォームのカスタム項目のデータを、見積書サブフォームのカスタム項目にデータとして反映することはできますか？
また、可能な場合、どのようなカスタム関数や対応が必要になるでしょうか？
サンプルとして、テストしたカスタム関数のソースコードを添付いたします。
ご教示いただけますと幸いです。
Topic Participants
Aki Ohara
岡安裕一（Yuichi）
Recent Topics
Problem when forwarding emails
When I want to forward an email received through Zoho, the layout changes: Buttons are cut Pictures change size Text changes alignment (left/right/center) Is this a common problem in Zoho? Thank you, SuzannahView Audit Trail field
The Audit Trail feature is great, but its data is only available to admin users. It would be really great to have a system field "Audit trail" that we can add to the detailed view of a record. This would allow supervisors, directors and etc. to quickly track what changes have been done by whom for each record. It is a current feature from a client of mine and while it's probably possible to hard code it, since this data is already available in Zoho, I would be surprised to hear how hard it wouldRecuring bills payments
I've entered recuring bills that are auto drafted from my account monthly. Can I set up the recuring payment or do I continue to manually do it monthly?Automatically assign Contact Roles to a Deal
Hi guys, Is there a way to assign multiple Contact Roles to a Deal via a workflow or similar? ThanksMake record entry more organized with the Sections component in Wizards
Hello everyone! Wizards in Zoho CRM have always helped you break long record-detail pages or large sets of fields into multiple screens, making data entry smoother and more user-friendly. Now, we’re taking a major step forward with a new Sections component—givingInteractions Tab in Zoho CRM: A 360° Omnichannel View of Every Customer Touchpoint
Hello Everyone, Hope you are well! We are here today with yet another announcement in our series for the revamped Zoho CRM. Today, we introduce Interactions Tab a new way to view all customer interactions from one place inside your CRM account. CustomersImap Support?
Does Zoho Books support IMAP? I have enabled outlook integration from settings in Zoho Books Yet the emails I send from Zoho Books for example if I email a purchase order or an invoice I dont see them in it in my sent box in outlook Is there a problemHow to handle this process need using a Blueprint?
See one minute screen recording: https://workdrive.zohoexternal.com/external/eb743d2f4cde414c715224fc557aaefeb84f12268f7f3859a7de821bcc4fbe15on submit of creator form then record is create in Zoho crm purchase module then on automatically task want to create in the crm
on submit of creator form then record is create in Zoho crm purchase module then on automatically task want to create in the crmZoho CRM Webinar – Automate everything across Customer Journeys in CommandCenter 2.0
How efficient is your current CRM automation setup? As customer journeys become more dynamic, it's common for data and actions to get scattered across teams and modules. This leads to broken processes and inconsistent customer experiences—especially acrossChanging employees email address
How do I change an employee's email address? I am an administrator on the account but it says that I am "not allowed" to do it?MULTI-SELECT LOOKUP - MAIL TEMPLATE
Dear all how are you? We need to insert data from MULTI-SELECT LOOKUP in a email template, but I can't do that, when I'm creating the template I can't find the field to insert it. is there any solution? PVUChanging the owner of a call
Am I correct in my conclusion that I cannot change the owner of a call in Zoho? The field does not show up in the screen, nor can I make it show up as the systems does not give me that option. I cannot "mass update" it either. I tried it, but Zoho refuses to change the name of the owner. Please help out: how do I change the owner of a call.Enhanced Candidate Portal: Now Featuring Federated Login, Passwordless Access & MFA
You can now enhance your Candidate Portal experience with Federated Login, Password less Sign-in and Multi-Factor Authentication (MFA). These features offer greater flexibility and control—allowing seamless sign-ins through trusted platforms and addingHow to store API keys in zoho?
Hi everyone, I'm currently building an integration using Zoho Flow and I need to securely store several API keys that will be used to make external service calls from my flows. I would not like to hardcode the values in the code of custom function. What'sRelated Lists filter
I have Contacts showing in our Accounts module. I customized the Contacts module with an Employment Status field, with the following picklist options: "Primary Contact", "Secondary Contact", "Active Staff(not a main contact)", and "No longer employed".Global Fields
Just like Global Sets for Picklists, we would like to have global fields for any kind of field. Three things that should be saved globally: 1. The Existence of the field 2. The Name and 3. Association with a module should be set up in a respective placeIntroducing Screen Share with Audio
Share your entire screen or just the chrome tab with audio for more engaging presentations. Your audience will hear sound just like you do, whether it's a video, demo or any other content. This is ideal for training sessions, team meetings, and clientNeed Help Preventing Overselling in Zoho Inventory
Hi fellow Zoho Inventory users, I'm reaching out for advice on managing inventory control in our growing business. We've recently encountered situations where sales orders get confirmed despite insufficient stock, creating operational challenges. OurZoho fsm scheduled maintenance dispatch
Hi, I'm reaching out regarding an issue I'm encountering with the Scheduled Maintenance feature in Zoho FSM. I’m trying to configure it so that it automatically dispatches all maintenance jobs scheduled within the next 150 days, starting from today. However,Tip #53: Populate and search values from tables using Table Lookup
Qntrl supports tables to store organization-related data and access it easily. Data stored here can be populated and displayed in orchestration using Table Lookups. This helps organizations list sizeable data in dropdown or multiselect dropdown fieldsMass Print Attachments from Selected Records in Custom Module
Dear Zoho CRM Team, We’d like to request a feature enhancement regarding the handling of attachments. Use Case: We have a custom module that stores invoices uploaded by our affiliates. Currently, we need to open each record individually to print theseCRM 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 filesIntroducing more AES digital signature options in Zoho Sign
Greetings! Zoho Sign has continually strived to partner with trust service providers across the globe to give you complete security and confidence, so you can e-sign documents no matter where you are. We've recently partnered with IgniSign, a qualifiedShuffling between one note to the next
I usually start all my notes per interaction with a contact with the date and then a little detail. But when I search for it it only see a small portion of the note and can't immediately tell which contact its associated with. can we make the note content🇺🇸 🇨🇦 🇲🇽 Ask the Experts: A Live Q&A Session
We’re back with another exciting edition of the Ask the Experts series—this time exclusively for our Zoho Recruit users from the USA, Canada, and Mexico! Whether you're trying to configure your account better, have burning questions about customization,Important Update: TRAI Mandates New SMS Header Format
Hello everyone, We have an announcement regarding a new regulation by the Telephone Regulatory Authority of India (TRAI) that affects all application-to-person (A2P) SMS services. Starting on May 6, 2025, TRAI has mandated that telecom service providersPreview generation in progress for days
I uploaded a video file to Zoho webinar. The file has been showing Preview generation in progress for days. Pls help, why is not approved?Again about the backlighting of the search query when searching in a client for Linux
Some time passed, I installed a client for Linux version 3.4.0, but I still did not receive the promised search with the backlighting of the search query how it was implemented in the client for android. In the previous topic, you told me that this functionCRM Custom function updating a module record shows the Super Admin user as the record modifier
Dear Zoho CRM Team, Is there any way to update this so that when a custom function has updated a record the Super Admin user doesn't become the modifier? This happens on the record as a modifier and shows up in the audit logs. It would be more usefulWorkdrive Upload Notification
Is there a way to be notified when someone externally has uploaded files to a folder? The "Unread" tab is really worthless because it shows all files from every directory on the system. I just need an email (or bell at worst) that says "someone has uploaded into <foldername>".Zoho Mail not working. Constant OTP
Firstly, my emails have been playing up for over a year. They are struggling to send and I have to press Send a few time to make them going. They mostly hover with a loading note saying Sending. I emailed Zoho and they got it working, but now it is doingMulti-Department Approval for a Single Bill in Zoho Books
Hello everyone, Hope you're all doing well. I’d like to ask if anyone has found a good workaround for the following scenario in Zoho Books: Let’s say a corporate credit card bill or vendor invoice covers multiple purchases across different projects orWorkflow for "Expenses" module?
Hi there, over the last 2 years, Zoho Expense has seen tremendous growth and we are happy with it. But, sometimes it is frustrating to see things are being implemented halfheartedly, or so it seems. For example, There is the possibility to create workflows2 Ideas, Clone timesheet entry from monthly view and Notes in Weekly view
While i love timekeeping I am finding some things slow me down. Slow to the point of considering writing my own API call to do this. It would be so useful to be able to clone a timesheet entry from the monthly view. It is somewhat painful to have toAllow Mapping of Zoho Desk Knowledge Base Categories to Multiple Departments in Zoho SalesIQ
Hello Zoho Team, We hope you're doing well. We would like to request an enhancement to the Zoho SalesIQ integration with Zoho Desk, specifically regarding the way Knowledge Base (KB) articles are mapped and displayed across departments. Current LimitationIntroducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether youCustomer Parent Account or Sub-Customer Account
Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, theyRecurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps
We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurring[Important announcement] Zoho Writer will mandate DKIM configuration for automation users
Hi all, Effective Dec. 31, 2024, configuring DKIM for From addresses will be mandatory to send emails via Zoho Writer. DKIM configuration allows recipient email servers to identify your emails as valid and not spam. Emails sent from domains without DKIMNext Page