get value of a field from a field in another module

get value of a field from a field in another module

Dear all,
we love Zoho and we enjoy working with it, up to a certain extent. We are all not programmers but the simple way to add fields, customise fields, create workflows and events are easy, simple and quick to do, up to a certain complexity.
Now I am having a question:

- In the module deals, i have a custom field (DueDiligence)
- I have the same field (DueDilligence) in Accounts module
- Whenever a deal is created or edited, the value (failed, passed, pending), which is to be found in the Accounts module, should be displayed in that very filed in the Deals module

This should be such an easy function, but I really tried everything and I cannot get there.
I was studying one on one and one to many dependancies, i created events, workflows and field updates, nothing seem to be able to help me with such a simple request then doing so coding, which I don't know how to!

So if anybody can help me here with some idea on how to do this in a simple way, that would be much appreciated!

    Access your files securely from anywhere







                            Zoho Developer Community





                                                  Use cases

                                                  Make the most of Zoho Desk with the use cases.

                                                   
                                                    

                                                  eBooks

                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                                   
                                                    

                                                  Videos

                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                                   
                                                    

                                                  Webinar

                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                   
                                                    
                                                  • Desk Community Learning Series


                                                  • Meetups


                                                  • Ask the Experts


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner






                                                            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 Writer

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ






                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                            • Recent Topics

                                                                                                            • Asking for implementation roadmap or step-by-step guidelines

                                                                                                              Hello everyone, I'm a freelancer who's been hired to implement Zoho CRM for a client, and I want to make sure I approach this correctly. Could someone kindly share a comprehensive implementation roadmap or step-by-step guide that covers all the essential
                                                                                                            • Approval Workflow for Purchase Orders Abrir

                                                                                                              The requirement is , that all purchase orders greater than or equal to 5000 go through an approval process from certain people, but within books I only see that the approvers can be by levels or any approver but we cannot enter a rule like these. Can
                                                                                                            • Multiple subforms from same existing form

                                                                                                              Hello, In an Order form, I have a subform for Line items. But my items have 5 distinct product categories. To make it pleasant and easy to use, I want to repeat the subform 5 times in the same parent form, to separate my 5 categories of product. But I
                                                                                                            • Announcement: Zoho DataPrep 1.0 will be deprecated on October 31,2025

                                                                                                              We'd like to inform you that the Zoho DataPrep 1.0 version will be officially deprecated as of October 31, 2025. This aligns with our efforts to streamline and improve your overall experience with Zoho DataPrep 2.0 which was released in Sep 2024 . To
                                                                                                            • Discussions from Ask the Experts 19 : Inside Zoho Desk Spring Release 2025

                                                                                                              Hello Everyone, We appreciate the engaging discussions during the Ask the Experts 19 session on the Spring Release. It was a pleasure connecting with you. Our team is actively working towards your requests to deliver an improved experience. In this post,
                                                                                                            • Optimisez la gestion des bots et la conformité à Apple MPP

                                                                                                              Filtrage des bots : une nécessité pour des données marketing fiables Les indicateurs de performance sont au cœur de toute stratégie marketing. Cependant, l’augmentation du trafic généré par des bots ainsi que l’adoption croissante de fonctionnalités comme
                                                                                                            • One time batch workflow to repair omission of data

                                                                                                              Hi, I created a parent form (Product) and another form (Prices) that is used as subform in the parent form. In the parent form I have a field Category that must appear in the subform, but I forgot to create the field at first in the subform and now I
                                                                                                            • Changing a Single-Line Text field into a Multi-line Field without losing data

                                                                                                              Is it possible to change a Single-Line Text field into a Multi-line Field without losing data. I have a module with data for which I would like to change a single-line field into a multi-line field but I'm worried it might delete the pre-existing da
                                                                                                            • Advance Your Churn Predictions with Zia's Usage Data Feature: Event Mapping

                                                                                                              Greetings all, This is an important and exciting update about feeding usage data into Zoho CRM. To expand the scope of how usage data can be used by Zia, we are introducing a new section called Usage Data under Zia. Users can now easily import, edit,
                                                                                                            • Web-To-Quote form would be awesome

                                                                                                              It would be awesome to be able to embed a quote form on a website and have that filter in to Zoho CRM. Account Number to match the Account in Zoho Email address could match the Contact. Product Code could be required to match the product. Not sure about quantity? I am sure this all could probably be done via the API and maybe some middleman interaction with Creator, but it would be nice if it was as easy as the Web-to-Case form. Something like this could lead to further integration with CMS and Shops
                                                                                                            • Published Sheet - Share option to show "Save copy to WorkDrive"

                                                                                                              Hi Sheets Team, I'm currently working on a Zoho Sheet which I want to share with other Zoho users outside of my organisation. Normally I would do this with Google Sheets but I'm trying to make better use of my Zoho tools. When I share a Google Sheet publicly
                                                                                                            • Bills vs. Expenses

                                                                                                              Hi eveyone, Can somebody explain me a little bit better of how can I use Bills and Expenses in my business? I don’t understand their differences to be honest.
                                                                                                            • Integration to LinkedIn Recruiter

                                                                                                              We'd like you to support Recruiter System Connect to sync our LinkedIn Recruiter candidates to the Zoho Recruit ATS. How can we do this?
                                                                                                            • List View just got a makeover!

                                                                                                              Hello everyone, The new list view is being rolled out in phases and will be available to all our users by the end of January 2021. We are excited to announce that the list view in modules is set to get a new look. The new list view is sleek, contextual,
                                                                                                            • Using IMAP configuration for shared email inboxes

                                                                                                              Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure
                                                                                                            • Add Video block needs improvement

                                                                                                              I regularly send out links to videos in my campaigns and I find that built in video block is never good enough to use in my campaigns, so I have to make a thumbnail in Canva and upload it or screenshot the actual video on YouTube. The concept of the video
                                                                                                            • Profile cannot add tasks, calls or meetings

                                                                                                              Good morning, I have a Profile of users that's called "Standard2" and their module permissions are set as follows: Despite this, one of my users on the Standard2 profile gets this when they try to add a call: Any idea how to fix this? If i bump them up
                                                                                                            • Zoho Developer Community Monthly Digest – April 2025

                                                                                                              Hello everyone, Welcome to this month’s Zoho Developer Community Digest! We’ve lined up an exciting series of technical sessions, product deep-dives, and community conversations to keep you informed and inspired. Don’t forget to check out our resource
                                                                                                            • Dataprep est-ce que zoho est sérieux ??

                                                                                                              Nous venons encore de passer plus de 2 heures avec le support zoho qui est incapable de résoudre le problème rencontré dans la mise en place d'un pipeline de données entre le C>>RM et DataPrep Celà fait 5 mois que nous essayons de faire fonctionner le
                                                                                                            • STOCK COUNT - How is this even possible

                                                                                                              Dear Zoho One, We have a lot of products from Zoho but I really don't understand this. We mainly use ZOHO FSM with ZOHO INVENTORY because we are in service and maintenance for electric charging stations for cars All employees of Zoho FSM have their own
                                                                                                            • Changing sequence of buttons

                                                                                                              How can I change the sequence of these buttons? I want the 'Versturen referral campagne' to be displayed as the default button
                                                                                                            • Unapproved Articles for Review?

                                                                                                              What is this feature and how do I use it? I'm not seeing any option to mark articles as unapproved and needing review.
                                                                                                            • Trying to fetch related list data from deals module

                                                                                                              I need to fetch stage history data which comes in related list in deals module using coql. How can I achieve that? { "select_query": "SELECT Technical_Survey_Date as system_order_confirmation_date, Stage,Created_By, Latest_Quote_Creation_Date,Originating_Source,
                                                                                                            • Stage-Probability Mapping

                                                                                                              How do I answer this question in analytics? What is the Closed-Won percentage of all Deals that reach a given stage? Another way: Of all Deals that reach a given stage (eg. Artwork/Price Quote), what percentage of them become Closed-Won? I want to populate
                                                                                                            • Follow-up Sequences

                                                                                                              For following up with leads based on open/click status.
                                                                                                            • How do I change the sort order of items in the User Filter?

                                                                                                              I have a chart for which I have set a custom sort order for a field. I noticed that in the user filter for this field, the order is shown as alphabetical. It does not reflect the custom sorting that I configured. I even tried selecting the checkbox "Make
                                                                                                            • Automate Zoho Projects Task Data Export and Email Delivery (for Non-Users)

                                                                                                              In many real-world scenarios, we need to share Zoho Projects task updates with clients or team members who don’t use Zoho or don’t have access to the platform. Since there’s no built-in way to export and email tasks directly within Zoho Projects, I put
                                                                                                            • Bulk Add notes

                                                                                                              I think that it's an absolute need and basic feature to add. I know we can import notes from an xls spreasheet, but that's not what I'm talking about. We should be able the same way that we can bulk send email, bulk add activities, we should be able to
                                                                                                            • How to use CRM custom button and client script?

                                                                                                              Here's what I need. I know how to handle each step in isolation. I do not understand how to intercept a Button interaction, pass it to the client-script for the user prompt, and remainder of the processing. User Clicks Button on Details Page Client-Side
                                                                                                            • Match one bank transaction to multiple customer with TDS dedcuction

                                                                                                              Hi team, Just wanted to know. How can i match one bank entry to multiple customer invoices with tds.
                                                                                                            • Zoho Product Sync between Books and CRM is a mess

                                                                                                              The syncing of products between Zoho Books and CRM is completely broken. Why is ZOHO CRM the center of all products? Surely it should be Books or Inventory that is the central focal point of all things to do with a business backend (i.e. not marketing
                                                                                                            • How can i resend a campaign to only one of the recipients on the original campaign

                                                                                                              How can i resend a campaign to only one of the recipients on the original campaign ? Sincererly, Mike
                                                                                                            • Transferring CRM Attachments to Workdrive

                                                                                                              relatedrecords = zoho.crm.getRelatedRecords("Attachments","Conditions",conId); attachid = List(); for each ele in relatedrecords { attachementId = ele.get("id"); attachid.add(attachementId); } for each ele in attachid { counter = 1; downloadFile = invokeurl [ url: "https://www.zohoapis.com/crm/v2/Conditions/" + conId + "/Attachments/" + ele type: GET connection : "work_drive" ]; resp2 = zoho.crm.attachFile("Deals",dealId,downloadFile); resp3 = zoho.workdrive.uploadFile(downloadFile, dealWD, "PlaceHolder"+counter+"",
                                                                                                            • Zoho Campaign low open rate

                                                                                                              I have been using Zoho One, Zoho CRM and Zoho Campaign to make my web application, but since I started using zoho campaign to send emails, it has low open rate (actually zero for the latest campaign for 2 days) For people who have more experience or know
                                                                                                            • More Workflow Triggers

                                                                                                              We utilize a lot of workflows in our organization. Recently we've identified two use cases where we would like a workflow to run a function. Upon further checking, the workflow trigger wasn't available, or the only option was to run the workflow more
                                                                                                            • サブフォームアップデート 静的サブフォームについて

                                                                                                              昨年のアップデートにある「静的サブフォーム」の詳細についてご存じの方はおられませんでしょうか? Zoho CRM - 2024年10月〜12月のアップデート https://www.zoho.com/jp/crm/blog/q4-2024-update.html 画像をみると項目を固定できるようですが、2025年5月現在、こちらの USデータセンター環境では設定箇所がみあたりません。 設定方法や設定箇所などご存じの方おられましたら共有いただけると幸いです。
                                                                                                            • IP Address List > Sigma

                                                                                                              We have developed a ZohoCRM extension that utilizes API calls to our server from Deluge scripts and Widgets. Our API server has IP restrictions in place. To ensure successful communication, we require a list of IP addresses utilized by Zoho's platform
                                                                                                            • Contacts per department

                                                                                                              Hello, Is it possible to limit Contacts to a Department? Thanks
                                                                                                            • Have One Custom Function Run After Another Custom Function Finishes - ZoHo Desk

                                                                                                              Hello, From what I'm seeing in ZoHo Desk. If there are multiple custom functions that run when a ticket is initially created, the custom functions seem to run simultaneously. Is there a way to have one custom function finish before starting another custom
                                                                                                            • email templates are a mess with fonts

                                                                                                              Any time I edit a template or adjust the content of an email while using it the fonts change. Previewing does no good as it appears one way but is sent another. for example .. this was made using Tomaha 2nd size with NO BOLDING. and this is what my client
                                                                                                            • Next Page