Dependent drop-downs... how?

Dependent drop-downs... how?

Good day. I have 2 different situations where I need a dependent drop-down field. First is for a subform, where I want to show related fields for a specific customer on the main form. In my case it is a parent whose children make use of our school transport service, and the parent's form must show data from only their own child or children. Second is on a form where a school is selected in a drop-down and the hostel dropdown must show only the hostel names for that school. 
The schools and hostels are linked through their respective forms.
I have tried a filter "SchoolID  equals input.School" in the Hostel lookup properties but it returns "No match". The School drop-down displays the school name but the filter "SchoolName equals input.School" says "In Criteria left expression is of type TEXT and right expression is of type NUMBER and the operator == is not valid"
Please help!
    • Sticky Posts

    • Share your success story

      We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
    • Merge and Store v1 API depreciation

      Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
    • Zoho Creator Developer's Conference 2017 !!!

      We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders.       Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around
      • Recent Topics

      • Plug Sample #5 - Read and write values/data in a Google Sheet with Zobot

        We all know google sheets are one of the widely used spreadsheet software. It helps us to make data-driven decisions. When connecting the Zobot with sheets, the bot can display values/data from a spreadsheet, like the available stock details (Item price,
      • Changing the Super Admin in Zoho Creator

        I can change the Super Admin for all of my other applications in Zoho One very easily but the change owner button is not available for Zoho Creator. How do I go about changing the Super Admin for Creator?
      • Subscription Pricing for Zoho Creator

        How can an organization charge Project Subscription Pricing to the client for Zoho Creator? Could you clear this out? How much do they need to pay for Zoho? If the client needs only 3 users, what plan to subscribe and how much?
      • New in Zia: Identify anomalies in list views, plus best mode to contact recommendations

        Hello all, We're here with a couple of enhancements in Zia—Introducing anomaly detection in list views and the best mode to contact suggestions. So without any delay, let's get into the details one by one Anomaly detection in list view Anomaly detection
      • Items usage in Expenses function

        I'm trying to utilize the item that I have created in the expenses function, but unable to do so. But this is accessible in Bill function. Why is that so? Its common for small business to buy inventory/items by cash. I feel this should be implemented
      • Email Parser refusing to create record

        Hi there, Ive created a email parser rule with this layout which was working for a day but all of a sudden after the weekends, the rule stopped functioning and every record after kept failing to create. example of email that is rejected below is my parser
      • Stopping Scheduled Actions From Workflows

        Any idea who this can be done? Is it done automatically? I can't find anything in Zoho explaining.
      • Export CSV from published public report

        Is there a way to create a perma link to a pull the CSV or other export type for a published report?
      • Custom Function for a new Field (combination of two existing fields)

        I have a custom module Eurotax API Eurotax This module contains 2 fields: 1: EUROTAX, API Name EUROTAX, Data Type Number 2: ROK, API Name ROK, Data Type Pick List I need to add a new field (for example Field3) that will be the combination of the values
      • How to download Zoho Meeting recordings via the API?

        When I hit the /recordings.json API endpoint it responds with a JSON which also contains a downloadUrl for each recording. HOWEVER, I have not been able to figure out how to access this recording. 1. If I access the downloadUrl as is, it results in a
      • Zoho Desk iOS app update - Rich Text Editor in comments, Hyperlinked Ticket Ids and Default Comment Type

        Hello everyone! In the latest version(v2.9.4) of the Zoho Desk iOS app update, we have brought in support for the following features for the comments section: 1. Rich Text Editor 2. Hyperlinked Ticket IDs 3. Default Comment Type Rich Text Editor: You
      • Download all the Attachment From Document Section Zoho Project

        Hello Team, I hope this message finds you well. I am currently facing an issue while trying to download all the documents associated with a Zoho project. Here’s the scenario: We have more than 150 tasks in a single project. Each task may have documents
      • Edit / Modify system generated emails

        Hi, System generated emails are great and are very helpful (tasks, etc). Why not allow us the ability to edit them? add/remove/reorder/reposition fields? I'm referring to emails sent from systemgenerated@zohocrm.com BTW - There's an old thread about this
      • GetRecords.py UNABLE to PARSE DATA

        Hello, I am trying to follow the GetRecords.py sample but I am getting a Status Code: 400 Status: error Code: UNABLE_TO_PARSE_DATA_TYPE Details Message: either the request body or parameters is in wrong format Any thoughts on how to fix this?
      • Desk and FSM 2 way communication

        is it possible for a work order created in FSM under a certain category (E.G Health check and Panel Clean) to automatically create a ticket in Zoho DESK?
      • python Message: invalid external fields in header

        Hello, I am trying to follow the GetRecord.py sample and put in my record ID from my URL and I am getting this error: Status Code: 400 Status: error Code: INVALID_DATA Details Message: invalid external fields in header Thanks for any help. I've double
      • Partner

        We are an established insurance brokerage company based in Kuwait, with over 28 years of experience in the industry. As intermediaries between clients and insurance companies, we earn commissions from insurance providers. To enhance our operations, we
      • Zoho Desk - Prévenir les agents à l’expiration d'un article

        Zoho Desk propose plusieurs solutions pour automatiser les flux de travail en fonction de vos besoins. Dans cet article, nous mettons en lumière une fonctionnalité qui alerte votre équipe lorsque des articles de la base de connaissances arrivent à expiration,
      • Ability to Change Custom View After Cadence Creation

        Dear Zoho Team, I hope you are well. We would like to request an enhancement to the Cadence feature in Zoho CRM. Currently, during the creation of a Cadence, we can select a Custom View under the "Who is this for?" section. However, once the Cadence is
      • Include Refresh Custom View on custom modules

        The "Refresh Custom View" button does not appear for custom modules. This seems like a very silly thing to omit.
      • in zoho crm, client portal, how to only show the active products?

        in zoho crm, client portal, how to only show the active products?Thanks
      • Zoho CRM function invoked by REST API Key does not receive a POSTed payload from Zoho Sign's webhook feature

        Posting a payload to the URL of the API Key invokes my function, but I can't access the POSTed payload data inside my function. I have confirmed that a payload is being POSTed correctly by testing with my own hosted webhook. I have tried receiving the
      • Tip 3: How to dynamically filter reports using URL parameters

        Hi folks, As part of Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on how to use URL parameters to filter reports. You don't always have to play with filters to drill down reports. Yes, that's right. You can pass URL parameters to set filter values and view only the required data. This technique is quite useful while linking reports in an email, a document, or when bookmarking an important report that you would like to view on a regular basis. For example,
      • Find form by inline subform criteria

        Is it possible to filter down to a form using inline subform fields? For example, I have a Contact form with an inline subform "Phone_Numbers" that has a "Phone_Number" field. I'd like to be able to get contacts by their phone number, but I'm not sure
      • Disabled virtual keyboard in handheld device with barcode reader.

        Hi I created a APP try to scan barcode by barcode reader bulid in handheld device. But creator will jump virtual keyboard. Could you provide a setting to disable virtual keyboard for single line or number field in Creator android and Iphone.
      • Is it a scam or a joke?

        I've just created a Zoho account and I already cannot access the "Privacy" section because I'm not the admin of my own account. Not to mention the claim of free custom domains for small businesses which turns out to be a scam because I'm asked to buy
      • Free webinar: Simplifying small business paperwork with Bigin and Zoho Sign

        As a Zoho Sign user, you already know the value of digital signatures. But did you know you can improve your document signing and management by integrating with Bigin, the easiest CRM for your business? We're hosting a free webinar on Jan 29, 2025 (Wednesday)
      • Deluge - mobile app learning

        Hi, I am currently learning another programming language using a mobile app (Mimo), which works really well, sets out things like error handling standards, variable naming standards etc. I came into learning Deluge with some minimal history of C++ and
      • how to sync shopify orders to zoho inventory instantaneously?

        hi, Is it possible to sync shopify orders to zoho inventory sales orders instantaneously using zoho flow? if so can anyone give me a step by step guide as im not too tech savvy. currently i have set up sync at 15 min intervals but thats too long for me.
      • Connecteur Zoho vers Dolibarr

        Bonjour, Contexte : * j'utilise Crm et Campaign pour gérer ma prospection et mon pipeline. * nous venons de prendre une franchise de commercialisation de services qui nous oblige à utiliser leur Erp développé Dolibarr Besoin : Continuer à utiliser Crm
      • How to Send Interview Schedule on Email by Deluge

        Hi Zoho Users. I am vishal kumar and working as a Zoho Developer. some of the User is faces the Problem about workflow for sending the invitation to candidate interview link. like that I can help you. Step1:- Get attachment of interview when you create
      • Zoho CRM - Create Report out of a Graph

        Hello, I created two graphs that measure the weekly sales activities on the basis of messages send on LinkedIn (we are using a third party tool that saves all LinkedIn messages automatically as a note). The graphs and the corresponding settings look like
      • Zoho Books as a POS(point of sale) software

        With barcode integration and sales reporting, zoho books can be used as a point of sale software. But Zoho Books integrates with Square Register for point of sale, why that if it stanalone has all the features of a POS software?
      • POS Integration with Inventory

        Hello!  I'm looking for a good option for Point of Sale that integrates with ZOHO Books, including INVENTORY.  Or maybe a different, easier way of doing things. Currently I am using Square for POS.  While I was able to integrate the transactions (cash
      • Unattended Installer failure Error 1001

        I found by renaming the PC I was installing and trying again it work. This has happened several times when cloning and installing many pcs and forgetting to change the computer name before installing Zoho assist. Somehow I think the computer name is getting
      • Individual Ticket Color

        It would be great if we can assign color for tickets like this: or this : it will help to find tickets Thanks Regards
      • Wish to Cancel my subscription

        Hi , I wish to Cancel my subscription for Site 24X7 and i do not want Auto renewal, under User ID: 839876237. If refund applicable, i can cancel now and get my refund as well. Please advice
      • Need Help Validating Requests in Channel Pull & Push Integration

        We’re currently working on an integration that utilizes Channel Pull & Push functionality. As part of this, we need to validate incoming requests, but we’re facing some challenges in getting the validation steps to work correctly. Here’s a simplified
      • Zoho Flow - Can not reference Zoho Analytics query table in Zoho Flow

        I've created a Zoho Analytics query table and would like to add data from that table to another Zoho Analytics table on a daily basis using a Zoho Flow. It seems, when building my flow, my query table is not include in the list of available tables. Is
      • Google ads and zoho forms thank you page 2025

        We have implemented CNAME in zoho forms. Google Ads wants us to run a thank you page, and they require that thank you page be hosted on the main domain and not the sub-domain. Is there a solution to this? Called to support and they had no idea how to
      • Next Page