Prepopulating Fields

Prepopulating Fields

Hello,

 

I have a form (Assets) with 2 lookup fields:

  1. Client (from Clients)
  2. Site (from Client Sites)

 

I modified the code (highlighted in red below), so the Site dropdown shows the list of sites related to the Client.

  1.               must have Client_Site

                  (

                                 type = picklist   

                                 displayname = "Client Site"

                                 values  = sites[Customer_Name == input.Customer].ID

                  bidirectional = Site_Assets

                  displayformat = [Site_Name]

                                 sortorder = ascending

                               row = 1

                               column = 1  

                                 width = medium

                  )

 

 

This change works fine when I open the ASSET form and select a client from the dropdown list.

The Sites then gets filtered by the client's ID:



The form was also added to the Client's detail view and the Site's detail view as related block.


I would like to add the following functionality when adding a new asset from the client's detail view or the site's detail view:


  1. When opening the Asset form from within a client’s detail view, I would like the sites dropdown to be filtered to show the sites associated with the client (currently it shows no sites because of the code I added in deluge):



2. When adding an asset from the site's detail view, I would like to prepopulate the client's ID in the asset with the same client ID from the site. 



It looks like the Asset form, when opened from a detail view (rather than from the menu) is being customized on the fly but I can't seem to find the code. I hope this is not hard-coded functionality in Creator.

Any help would be greatly appreciated

Thanks,

Eyal. K

    Nederlandse Hulpbronnen


      • Recent Topics

      • Translated country names in Address field not sorted alphabetically

        Hello. I have a form with an address field that includes the country dropdown. The primary form language is English (as is the Zoho Forms account language). The form has been translated into German from the form's Settings > Translation functionality.
      • Zoho Commerce Microstore to bypass customer portal on spesific items

        Hi everyone, I’m currently testing the Microstore feature in Zoho Commerce and trying to understand how it behaves with access restrictions. My goal is the following: Even though the customer portal is enabled (and the main store requires users to sign
      • Calendar Attachments in iOS Mail App

        It appears that viewing or accessing attachments to a calendar event is not possible in the iOS mail app. Is this correct? The ability to view calendar attachments in the mobile app is vital for me. Is this just a setting I'm missing somewhere?
      • Grey border on inserted Sheet on Write document

        When inserting a Sheet on a Write document, it show an ugly gray border. How to get rid of it?
      • Send workflow alerts as a single mass email to all recipients

        Managing workflow notifications becomes easier when everyone needs visibility into who received an alert. With this enhancement, workflow email alerts can now be sent as a single email to all recipients, giving recipients visibility into the other users
      • Kaizen #253 : Custom Validation for Blueprint to Enforce Mandatory File Uploads and File Extension Compliance Using Client Script

        Welcome to another exciting Kaizen post on Client Script! Have you ever wanted more control over what gets uploaded to a File or Image field in Zoho CRM, like restricting file types, validating file names, or showing a custom error before an inappropriate
      • WORK DRIVE CUSTOMIZATION

        WORK DRIVE CUSTOMIZATION Create folder for every Case by “Contact Name “in Work Drive under Associate Deals Folder Directory: User Work Drive Accounts: Route Directory Associate Cases Case Name, Case Number Client Upload- Shared with contact (for collaboration)
      • How do I migrate from Office 365 to Zoho Mail?

        Check out Advik Email Migration Wizard, this software is specially developed to move mailboxes from Office 365 to Zoho Webmail. In addition you can migrate from Gmail, Yahoo, Rediffmail and 80+ webmail servers to ZOHO MAIL. Isn't it amazing? This is an all in one email migration solution. Steps to export emails from Office 365 to Zoho Webmail are as follows; Run Advik Email Migration Tool in your system. Select Office 365 as source and enter its login credentials. Select mailbox folders and choose
      • 【続々公開】Zoholics Japan 2026 セッション情報を更新しました!

        ユーザーの皆さま、こんにちは! Zoholics Japan 2026のセッション情報を続々と公開しています! 今年は3つのトラックで、Zohoの最新情報やAI活用、製品アップデート、 活用事例など、多彩なセッションをお届けします。 現在公開中のセッション(一部) ・Zoho CRM 製品アップデート ・Zoho CRM Plus 製品アップデート ・Zoho Community セッション ・Zoho Desk セッション ・中堅・成長企業の人事DX ~AI時代に何から始めるべきか?~ ・Zoho
      • Zoho Forms integration Google Sheets

        Hi, quick one. I wonder if you can help. I have a Zoho Form integrated to a Google Sheet. The fields are showing across the top, but no records are there. I have checked in Zoho Forms to see if there have been any failed integrations, but there are none.
      • What's New in Zoho POS - August 2026

        Hello everyone, Welcome to Zoho POS’s monthly update, where we share our latest feature updates, enhancements, events, and more. Let’s take a look at how August went. Boost your customer loyalty with loyalty points In a retail business, keeping a customer
      • Zoho ERP | Product updates | June 2026

        Hello users, We launched Zoho ERP on January 23, and since then, our goal has been to help businesses streamline and manage their operations with greater efficiency, flexibility, and control. Since the launch, we've continued to enhance the platform every
      • 3 numbers after comma in discount field

        Hi, i need to make discount like: ex. 34,345% it's possible? Thank you.
      • ZOHO Campaigns in ZOHO Analytics - Campaigns vs Contacts Table

        There seems to be information in the Zoho Campaigns table such as Unique Opens and Unique Clicks that can't be found in the Campaigns vs Contacts table where only Opens and Clicks are shown on a per contact level. Is there a way to bring Unique Opens
      • Canva Integration

        Hello! As many marketing departments are streamlining their teams, many have begun utilizing Canva for all design mockups and approvals prior to its integration into Marketing automation software. While Zoho Social has this integration already accomplished,
      • Time Zone is incorrect

        Time zone is not working properly...I've checked it twice. I'm eastern U.S. time it's currently 12:22 pm EST. CRM shows 3:22 pm EST.
      • Default Country list suggestions on CRM is different then on Book; how do/did others address this?

        So I already have a support ticket in for this and waiting for a response but figured I'd ask the community also to see if others experienced the same problems and/or how they went about addressing it because sometimes I feel like I'm going crazy with
      • Vehicle Tracking

        we have GPS devices that installed on our vehicles, and we would like to know if it's possible to  get vehicle live location data from the GPS device To Zoho Creator App.   Thank You
      • Check out the new Checkbox in Zoho Sheet

        Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
      • Custom Calendar View for a Custom Module in Zoho CRM

        Hello everyone, I’m looking to create a calendar view (monthly grid, similar to Google Calendar) for a custom module in Zoho CRM, based on a date field within that module. The goal is to have a highly customized visual layout — colors depending on the
      • Enhancements related to emails

        Dear All, We hope you're well! We talked about the new email configuration in our previous announcement. In line with that, we're here with a few enhancements related to emails in Zoho CRM to improve how users view their emails and attachments from within
      • Project Change Orders and Additions

        We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure out
      • How Can I Recover My Website After the August Spam Update?

        Hi everyone, My website was hit quite badly during the August spam update 2026, and I'm trying to understand what I should do to recover it. My traffic and search visibility have dropped, but I'm not sure what exactly caused the problem. I have already
      • Assembly Reporting in Composite Item View - Add 'Per-Unit Cost' Column

        When a user in the UI goes to a Composite Item, looks under Transactions, and selects Assemblies, the screen below is shown. This is all good information, but one piece of very important data is missing... the per-unit cost. I realize that for those on
      • Zoho Deluge Outage

        Hello Enterprise Support Community, We wanted to make you aware that we are currently experiencing an outage affecting Zoho Deluge. Our developers are actively investigating the issue and working to restore service as quickly as possible. We apologize
      • Impact/Best Practices when "US Zoho Services Availability - Incident, Zoho Deluge is down"

        I've been seeing this more recently and I've been wondering exactly what that means/affects and how to best address it when it does. I can check for function failures, but are all function calls when this happens logged a failure, or are errors silently
      • Day 2: Wait, where did everything go?

        You log in the next morning, and the setup you finished yesterday is nowhere to be found. You are having a hard time finding your data. Here is where to look. In this post I logged in, and my data is gone. Where is it? I set things up, but I am looking
      • Estimates or quotes in Inventory

        Our pottery wholesale business is heavily inventory based. We are planning to switch from Quickbooks to Zoho Inventory which will be a great improvement on the "sales" side for in-house sales and salesreps. The only thing we are missing in Zoho Inventory
      • CLIENT PORTAL (If clients can place orders directly on the portal)

        Zoho client portal is excellent. Everything is there except one thing. Client should be able to place orders directly on the portal. This would enhance the portal and end users will be extremely happy. This suggestion infact came from one of our client.
      • Deal win rate

        Hi,  I would like to know something very simple, yet very important. Wath is the winning rate of the deals I've created. For exemple, what percentage of the deal i've close the last month where wins.  Would seems easy to find... but can see a report for that...  Help please. 
      • Create Flexible Layouts with Layout Rules

        In a project, when a work moves from planning to execution, the information teams need can change at every stage. A project can need one set of details, a phase can need another, and a custom process may require an entirely different set of information.
      • Zoho Team Inbox - roadmap

        Hi, would be good to understand the Teaminbox roadmap, in particular: 1. API / Zoho Deluge connections. We have a process where the each email needs to be either tagged or assigned daily. It would be great if we could automate a 5pm alert for any exemptions
      • Conditional branching in Zoho Desk with Automation Studio

        Hello everyone, We are introducing conditional branching that will allow businesses to manage complex, multi-condition workflows for customer service processes using Automation Studio. The primary goal is to create multi-branched logic in a single rule.
      • Custom Function to increment a value by one

        Hi, I'm trying to find a solution to set up a counter on CRM records that tracks how many times certain actions have taken place. As a specific example: We have a field on Deals called "Times Close Updated". This starts at 0 on record creation. I'd like
      • Guide customers to the right booking page with routing forms

        Greetings from the Zoho Bookings team! We're excited to introduce Routing Forms in Zoho Bookings. Routing forms let you collect information from customers before they schedule an appointment and automatically direct them to the most appropriate booking
      • One flow for fulfillment exceptions across CRM, Inventory, and Desk | Kiosk Studio Session #11

        Hello folks, Some orders get flagged in the fulfillment stage. One is short by six units, with nothing from the warehouse explaining why. Another shipped in full three days ago and still reads as pending, because the carrier never posted a scan. A third
      • Zoho CRM Community Digest - August 2026 | Part 2

        Hello everyone! August's second half brought a strong set of updates to Zoho CRM. The Functions experience gets a complete redesign, Incentives brings commission management natively inside the platform, and Dashboards pick up four focused improvements.
      • Spam Control in Zoho Mail: Manage and Filter Incoming Emails for Your Organization

        Unwanted emails are a common challenge for organizations of all sizes. Without a structured spam control system, spam emails can flood user inboxes, expose sensitive data, and disrupt communication. Zoho Mail's Spam Control feature gives administrators
      • [Webinar] Automating document review and approval workflows

        Live webinar on September 10, 2026 | Time: 2 PM IST | 2 PM EDT Hi, Still juggling multiple tools, chasing approvers manually, and losing visibility into where your documents stand? Join our live webinar to learn how Zoho Writer's built-in workflow engine
      • Version Control and Git Integration for Zoho Creator Applications

        As Zoho Creator applications grow in complexity, managing code changes, tracking history, and collaborating across developers becomes increasingly difficult. Currently there is no native way to: Track what changed, when, and by whom across Deluge functions,
      • Next Page