Map fields from module X to a lookup field in subform in module Y

Map fields from module X to a lookup field in subform in module Y

Hi there

In the 1st screenshot attached, you can see a subform in myLeads module. You can see that there is a number already filled there - that is the 'Property ID' and it is a single line field. It is the 'Property ID' of an entry I have in another module - The 'Properties' module - take a look at the 2nd screenshot. In this second attached image, you can see the fields 'Property code' - this is basically the number that is mapped in the 'Property ID' field in the subform in the Leads layout. We also have the 'Property name' field. Both of these are once again single line fields.

What needs to be accomplished here is that in the Leads module, Property Interest subform, specifically the 'Property name' field next to the 'Property ID' field, needs to be mapped / populated with the corresponding Property name. For example, in the case, the Property name according to the Property ID - is the one that is shown in the second screenshot, under the name "Studio in Athens, Greece".

Important note however, the 'Property name' field inside the subform, is a Lookup field. 

So I would really appreciate some assistance in terms of writing a function that will automatically execute once the Property ID field is not empty - to then populate the right Property name in the lookup field discussed accordingly. The name shall remain as a lookup field and it's very important to stay so. 

Thank you
    • Sticky Posts

    • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

      Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such
    • Custom Function : Automatically send the Quote to the related contact

      Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow
    • Function #50: Schedule Calls to records

      Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM
    • Function #37: Create a Purchase Order from a Quote

      Welcome back everyone! Last week, we learnt how to calculate the total number of activities for a lead and further take note of the activity count for particular dates. For instance, from the period of Demo to Negotiation. This week, let's look at a function that lets you create a Purchase Order instantly from a Quote. Business scenario: In any form of business, one of the most important things to do is to document the transactions. Naturally, negotiation, signing an agreement, placing an order,
    • Function-2: Round-Robin assignment of records

      Welcome back folks! Last week, we saw how to update sales commission in quotes using a custom function. This week, let's see an interesting use case asked by many of you - auto-assignment records by round-robin method. Business scenario: Right now, the solution allows you to auto-assign leads from web form and imported lists. Let us look at a need where you want to auto-assign leads from in-bound calls in a round-robin method, across modules. Prerequisite: You must create a permanent record in the
      • Recent Topics

      • Create Ticket from Chat with Rest API

        Hi to everyone, is possible to create a ticket from Chat with Rest API? In user interface is possible by clicking on the button "Convert chat as a ticket". Anyone know how to do that? Thanks
      • Free webinar: ‌Zoho Vault in 2024—A live Q&A with our experts

        Hi everyone! 2024 has been a pivotal year for us, taking our journey from a basic team password manager in 2013 to a full-featured security platform offering password management, single sign-on (SSO), and soon, passkey management. Our team has been tirelessly
      • Kaizen #167 - Configuration and Initialization of Zoho CRM Python SDK (V7) for different client types

        Hello everyone! Welcome back to another week of Kaizen! Zoho CRM Python SDK allows developers to integrate Python applications with Zoho CRM. In today's Kaizen post, we will explore how to initialize and configure the SDK for both self-clients and server-based
      • Zoho Forms - Dynamic Prefill Setup Question

        Hello, I'm very excited about this feature. So much I'm learning about webhooks. However, it seems that the webhooks I can obtain from Zoho Flow and Zoho CRM come with already parts in the URL that are put as invalid by the GET Webhook URL. Do I need
      • How to get a list of Team Folders associated to a Project from the API?

        I've tried the below, based on another article and was unsuccessful. response = invokeurl [ url :"https://projectsapi.zoho.com/api/v3/portal/" + _portalID + "/projects/" + _projectResID + "/folders" type :GET connection:"zohoprojects" ]; info response;
      • Email Alert attachments unavailable for Vendor Payments

        I have several vendors with country specific compliance requirements to support the payment of their invoices. I've created Vendor Payment templates to meet their requirements and I setup an automation workflow that gets triggered when the invoice is
      • How to create Sepa Direct Debit XML file: solution and code

        Even though Books provides a payment integration for Stripe and Gocardless (in Europe) there are customers that want to use the Sepa services of their own bank. Mainly because Stripe and Gocardless are quite expensive. In that case they would need a Sepa
      • Exporting Project Tasks

        I can export the gantt chart to a nice PDF in colour, but we want just the task list in a nice colour layout. Is there a way to export it to PDF without the gantt? It would be perfect to give to clients.
      • bug reporting with the count of linked Desk tickets

        I am aware that when viewing an individual bug, you are able to see a count of the Desk tickets that are linked to the bug on the right hand side. However, I cannot see a way of reporting this figure from a list of bugs. Our use case is that we would
      • Unable to send e-mails to an specific address

        Hello. I'm having problems sending e-mails to my shipping company. user@shippingcompanydomain.com INVALID_ADDRESS, ERROR_CODE :550, ERROR_CODE :5.1.1 <user@shippingcompanydomain.com>: Recipient address rejected: User unknown in virtual mailbox table Reporting-MTA:
      • Blueprint transition help needed

        I have 5 approvers. For a stage to be passed to the next stage, I require any 3 out of these 5 approvers to make the approval. There is no particular sequence of approval, at any one time, any one can approve. As long as 3 approvers approve, the stage
      • Year-End Wrap: Out-of-Office Made Easy with Zoho Mail

        As we wrap up 2024, now is the perfect moment to take control of your email routine and gear up yourself for a productive and successful new year. We have curated a series of weekly tips to help you master your email management starting today. Watch out
      • Creator Simplified #9: Automatically Sending Uploaded Files as Email Attachments

        Hey Creators, Welcome back to the Creator Simplified series! Today, we’ll explore how to automate file uploads as email attachments in Zoho Creator—a handy feature that saves time and reduces manual effort in your business processes. Use Case: In a typical
      • Zoho Books Community Meetup: Learn, Grow, Network!

        Hello users! We are excited to announce a series of upcoming Zoho User Group meetups and would love for you to join us! This is a great opportunity for you to connect with other users, share experiences, and learn more about how to make the most of our
      • Bar chart from Deal Stage Snapshot table not showing right amounts

        Hi, since we needed to track the changes of our deal pipeline over time, I added a new data source and selected 'Snapshots' to start the sync. At first I thought it was working just fine, after a few days I realized that something was wrong with the amounts
      • How to Display Territory Field on Deal Object

        I am assigning Territories to Deals. I am able to use the Territory field as a column in my list view but cannot figure out how to enable it to be visible when viewing a Deal record directly. Can you advise on how to display the territory assignment as
      • Power of Automation::Automate the process of creating Tasks from Task template on project status update.

        Hello Everyone, Here we are again to share another requirement that has been accomplished through the implementation of custom functions. A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed
      • Im Stuck in an EDIT ONLY WITH WIZARD issue

        So I found Wizards to be a really helpful tool in minimizing the exposure of redundant, superfluous fields to staff that would never otherwise have to edit those fields. My issue is, that when the record (in this case a lead) is created with a wizard,
      • Mass Update in Zoho CRM

        Hello, I want to update my past update records by using deluge on some conditions. anyone can please tell me how can I do it.
      • LinkedIn Followers not correct

        It looks like Zoho Analytics only counts followers from the day it was connected to our LinkedIn-page. The Total Followers Count in Analytics only displays 549 followers, while in reality we have 1,036 followers. The information is correct in Zoho Social,
      • [API] How to get Contact's funnel?

        Hi everyone! I am trying to use the API to get a Contact funnel's (step, name.. anything). Can anyone help me? This information is not available in the API response... I need to retrieve and change my Contacts between funnels dynamically according to
      • Task created from Email Alias

        When forwarding multiple emails to project email alias, it will create a task as internal which makes a lot of "General" Task List as I've created automation to set the flag as external. Is there any way to set up the task list created from email alias
      • Automation#24: Auto-Update custom field from Accounts to Tickets

        Hello Everyone! Welcome back to the Community Learning Series! This episode dives into how Zylker Techfix streamlines account-related ticket references. Previously, employees had to manually check account details to retrieve specific customer information,
      • How do I add an email to tasks in Trident?

        Hi, I'm trialling Trident to see if it works better for me than the browser version. It's a nice idea and looks quite refined, so I'd like to be able to use it. My first question is: how can I add and email to a task? I can't find any obvious way, but
      • Project template after project creation

        How can I apply a project template AFTER the project has been created?
      • Creating Email template that attaches file uploaded in specific field.

        If there's a way to do this using Zoho CRM's built-in features, then this has eluded me! I'm looking to create a workflow that automatically sends an email upon execution, and that email includes an attachment uploaded in a specific field. Email templates
      • How to create a Field with answers as Yes, No> Further if no is selected a new field to be visible to give details

        Dear All, I am creating a feedback form in HR Letter. The question is were you satisfied with the work allotted. Expected answer to this is Yes, No. Further if the response is no, then a field to be give to fill more details as to why no was selected.
      • Filter Tabs in a Dashboard

        I have multiple tabs in a dashboard one of which is aimed at a different audience, is it possible to filter out this tab for a group of users?
      • How do I set up Contact Scoring for my existing contacts

        I'm trying to set up Contact Scoring for my subscribers, 9 months after creating the database. I've added the Campaign Activities, but none of the contacts have a score. How can I update all the contacts so they show a score? My goal is to ultimately
      • ZOHO PEOPLE

        HOW CAN I DELETE LEAVE HISTORIES IN ZOHO PEOPLE?
      • Kiosk Studio: Function FIX for Date/Time Field (Keep getting wrong format error)

        I am using the foillowing function in my Kiosk Studio to update the previously entered Date/Time field from previous screen to update that to the same date/time field in Lead Record. Every time I 'Save & Execute' I get a Success but with 'Date/time Format
      • Zoho CRM Web To Lead Form: Radio Buttons/Pulll Down Menus?

        Hi is there a way to set up radio buttons, check boxes or pull down menus in the web to lead form? We often ask additional lead qualifiers or demographics information and in some cases radio buttons or pull down menus are necessary or more efficient to
      • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (10/31)

        ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 10月開催のZoho ワークアウトについてお知らせします。 ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは? Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。 Zoho サービスで完了させたい設定やカスタマイズ、環境の整備など……各自で決めた目標達成に向け、 他の参加者と同じ空間で作業を行うイベントです。先輩ユーザーや他の参加者と意見交換をしながら集中して作業に取り組むことが可能です。
      • Zoho Meetings - Scheduling sucks

        I wanted to try this out for our little meeting group. I scheduled the meetings for Tuesdays, Thursdays and Fridays. No matter what I did, the meetings all showed on FRIDAY. I changed the date and hit save. Still friday. Terrible system. Back to Zoo
      • This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

        Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved.  Thank you
      • Brand New and have some questions

        Hi everyone. I am brand new to Zoho and have some questions I need help with. 1. I just imported a bunch of contacts and most of them don't have any association with an account. However, an account is required to add them to pipelines it seems. Can I
      • Zoho very poor support!

        More then 1.5 week ago I've contacted Zoho support by email and STILL no reply. What kind of business are you people running? I'm a paying customer and I demand support. Your email service is blocking valid emails from my business partner because of  "we generally do not accept emails from dynamic IP bla bla bla" I, NOT YOU, decide which emails I want to receive. I don't need your crap email protection. If I want spam protection I'll implement it myself. I've put his domain on the whitelist and STILL
      • Immediate action required by Notification SMS users

        Attention dear customers, This announcement seeks immediate action by CRM Notification SMS users to update their telemarketer aggregator for notification SMS compliance. We would like to bring to your attention an important update in the Telecom Regulatory
      • Import subform entries conveniently in CRM

        Dear All,   Subforms have always been crucial for associating additional data with CRM records. You can easily associate line items with parent records and keep track of various details related to your records. We're pleased to announce that we've introduced
      • Pay milage expense with undepositied cash

        Hello When I add millage, the only probable option to "pay through" is Owner's Equity. I pay for the fuel using undeposited cash but I can set "paid through" to undeposited funds while entering mileage. I do not have employees and this is the mileage
      • Next Page