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

      • Reusable Variables

        I’d like to know if there’s a way to store variables in Zoho Analytics that I can use in metrics or calculations. For example, I have a Currencies table that stores the value of different currencies over time. I’d like to use the value of the US dollar
      • HTML Code + Writer Documents

        Hello, I am in the process of writing a couple of documents in Writer. Both document will have 2 versions each. One version being a freebee that perspective clients can download from my website. The other version will be a paid version, and additional
      • Audit Log: Detailed View and Export for Better Tracking

        Audit log tracks all the events or actions performed by the users and displays them in a sequential order. By default, all users who have admin access can view the audit log. We have added new features to the audit log that will enhance the user experience
      • Display All Admin Roles in Zoho One Admin Panel

        Hi Zoho One Team, I hope you're doing well. Currently, in the Zoho One Admin Panel, we can see Org Admins and Service Admins assigned to specific applications. However, admins assigned at the organization level for various Zoho apps (such as Mail, Cliq,
      • Enable users to create and edit presentations in your web app using Zoho Office Integrator

        Hi users, Did you know that your users can create, edit, and collaborate on presentations from within your web app? With Zoho Office Integrator's embeddable presentation editor, you can easily add these capabilities. Here are the highlights: Create presentations:
      • I can buy a Domine

        I need assistance with an issue I'm experiencing. Whenever I attempt to purchase a domain, I receive a message that says, "We ran into some trouble. Please try again later." I would greatly appreciate any help you can provide. Thank you. Please refer
      • Zoho Customer Statements open item and NOT balance brought forward

        How do I set my customer statements to open item and NOT just the balance brought forward. I would like the customer to see all the invoices outstanding
      • Free Webinar! From click to doorstep delivery | Enhance your ecommerce fulfillment process

        Free Webinar! From click to doorstep delivery | Enhance your ecommerce fulfillment process April 24, 2025, 12 p.m. EDT As your business grows into the ecommerce sector, so do the complexities of fulfillment. From managing real-time inventory to handling
      • Zoho Books Invoice Enable Payment Gateway with Deluge

        I am using this to create an invoice record in zoho books from zoho crm invoices. I want to add the ability to enable online payment gateway for "stripe".  I can not seem to find one article online on how to do this.  Can someone help? invoice = zoho.crm.getRecordById("Invoices",id);
      • Calculating Project Margins and Revenue per Hour in Zoho Analytics Using Data from Zoho Projects and Zoho Expense

        Hello, I would like to know if it's possible to use Zoho Analytics to calculate taxes and margins for the projects available in Zoho Projects, while also including the expenses recorded in Zoho Expense. I’m looking to build a dashboard that calculates
      • Having issue adding email account

        Hi Sir/Madam, I having an issue adding an email account (user and group). We have two organization but I am getting an error while adding the account in both User and group. Yet the account is not there. See attached.
      • UNEXPECTED RESPONSE CODE: 400"

        Getting this on all new flows created with a Zoho Campaigns connection
      • Suburb Categorisation/value

        Hi All, I have a list of suburbs that my company services, they are categorised by value to the business using a letter grade (A,B,C,D). When a lead is created I want the workflow to check the project suburb and then assign the related grade to a new
      • Add Custom Text Fields as a component in Dashboards

        Hi Team Idea: Adding custom text fields as components in dashboards. This will allow those of us creating the dashboards to better segment the dashboard into sections allowing a better front user experience where we are showing different categories of
      • FSM API ERROR Code "OAUTH_SCOPE_MISMATCH"

        I am trying to create a contact via the ZOHO FSM API https://fsm.zoho.com/fsm/v1/Contacts I have followed the instructions of the API documentation to Authenticate and Create a contact but I cant figure out what I am doing wrong. Bellow are the steps
      • TaskList at Bottom from API

        When I create a taskList from API the TaskList is always At the Top, I need it to be at the bottom. How can I achieve that?
      • Linkthread domain names - none available

        Hi I am trying to add our domain names but they do not seem to be available but I am pretty sure they would not be taken as yet. Does Linkthread recognise .com.au or .org.au domains?
      • Setting default values in CardScanner app

        We use the Zoho Cardscanner app. Is it possible to set default values. For instance for "Lead source" to set the default value to "Exhibition". Now we have to manually select that for every card we scan.
      • Custom Fields like Discount

        Hi, Is it possible to make a custom field that acts like the discount field in quotes? I would like the option to have the field pop up exactly like Discount but instead of subtracting money it adds money (shipping cost in this case). I would like it
      • "Unable To Join Group Call"

        When trying to join a group call within Trident on macOS, I get a popup that says "Unable To Join Group Call". No other explanation is given. Anyone invited to a call should be able to join at all times, even if the organizer has not joined the call.
      • Effective project development with integration of Zoho Desk and MS Azure

        Dear partners, We are happy to announce that you can now integrate your Zoho Desk account with Microsoft Azure DevOps. This integration provides an effective way to: Manage feature requests Collaborate with teams Streamline development processes Dispatch
      • No-reply email account without taking up a user license?

        I just upgraded our zoho mail account to the paid tier and purchases 7 licenses. When setting up our new users I can't add the 7th one because I have a no-reply email account created to be able to send automated emails from our server. How do I go about having an account like that without taking up a user slot? All it needs is outgoing mail, no receiving or anything else.
      • ¿Por qué no te puedes perder los Workshops de Zoholics 2025?

        Cada año, Zoholics reúne a cientos de profesionales, emprendedores y entusiastas de la tecnología para compartir ideas, aprender unos de otros y descubrir todo lo que el ecosistema de Zoho puede ofrecer. Pero si hay una parte del evento que realmente
      • Fetch Project's Task by Name

        Why is there no way to fetch a projects task by name? https://www.zoho.com/projects/help/rest-api/tasks-api.html#alink1 I have looked in the documentation but didn't find a way to fetch tasks by Task Name Am I missing something?
      • Error when adding an existing user to Zoho Project

        In the Zoho Projects Flow if an existing user is added to the project it results in an error There should be a way to automatically skip adding the user if it already exist in the Project instead of halting the whole Flow
      • Cannot Trigger Purchase Receive Flow from Both Books and Inventory

        I have created a flow for Zoho Inventory Purchase Receive Normally the purchase receive is created in Inventory, but sometimes the Purchase Receives gets created in the Books the the flow doesn't trigger Is there a way to trigger the flow whether the
      • New VAT Rate for South Africa

        Hi, When will the new VAT Rate be implemented as it is from 1 May 2025, and how will updates etc happen. Will there be a global update function. Thanks
      • South Africa VAT increase from 1 May 2025

        Hi Will Zoho Books automatically update the VAT settings from 15% to 15.5% or must it be done manually? The VAT rate is increasing to 15.5% on 1 May 2025, and supposedly to 16% in 2026. Regards Uwe
      • Power of Automation :: SLA for Tasks

        Hello Everyone, In this 'Power of Automation' series, we are focusing on the feature "Time-Based Workflow Rules for Tasks." Workflow rules help project managers organize tasks in a project by setting criteria and actions that meet the project requirements.
      • Widgets in People 5

        I'm trying to add a button widget in one of our test sites, created using the Zet-CLI Tool. When I host the Widget externally it runs fine, making a call to a UK Government API and downloading some json and displaying a table of data. If I try to host
      • Convert a message on Cliq into a task on Zoho Connect

        Message actions in Cliq are a great way to transform messages in a conversation into actionable work items. In this post, we'll see how to build a custom message action that'll let you add a message as a task to board on Zoho Connect. If you haven't created
      • Zoho mail not working after Domain expiration and renewal

        Need help getting email working after an accidental domain expiration. Domain has since been renewed.
      • eway Bill - Import (Good / Material)

        As we Importer of goods , for That first we Generate PO then , Payment, then after We create Bill of Entry  After Bill of Entry Anywhere (99%) cases material that arrived to port that comes to warehouse / factory for that Eway bill , we have to create
      • In zoho creator I have Category form it has category name field Once Enter category name , category code want to Auo create on submit of the form

        In zoho creator I have Category form it has category name field Once Enter category name , category code want to Auo create on submit of the form Code Create Format first letter of product with number of product on this category Example: I have one use
      • Let's Talk Recruit: Meet Zia, your all-in-one AI assistant

        Welcome back to our Let's Talk Recruit series! Today, we are going to meet Zia, your all-in-one AI assistant. Let's delve into Zia's capabilities and explore how it takes tedious, time-consuming tasks off your plate. What is Zia? Zia is your AI companion
      • Zoho ONE Inventory and Zoho FSM

        Zoho ONE Inventory sees a warehouse just as a warehouse. You have to be a ZOHO ONE usher for example to use a warehouse like counting stock while you have to buy a warehouse as an Add one separately from ZOHO ONE Inventory to use it for ZOHO FSM In ZOHO
      • How to Mass Delete 26K leads ?

        Hi, can anyone tell me how I can mass delete 26K leads please? Thanks Colin
      • 【Zoho CRM】サブフォームのアップデート

        ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中からサブフォームのアップデートをご紹介します。 サブフォームは、複数の行項目をまとめて管理できる副次的なフォーム/表です。例えば、営業チームがCRMのサブフォームを使って顧客の注文を管理する場合、商品名・価格・納期などの情報をまとめて入力できます。 ただし、このサブフォームのリスト自体が長くなると、スクロールが必要になり、画面上で確認する際に情報を把握しづらくなることがあります。 この課題を解決するため、サブフォームの列で「複数列のピン留め」と「項目列の幅の調整」の2つの新オプションの使用が可能になりました。
      • Is there a way to Prefill A Subform in Zoho Forms?

        By The Grace Of G-d. Hi, Is there any way to prefill a subform? Using URL Parameters or something else?
      • Updating Auto Numbers

        I'm removing a suffix from my auto number that's related to my customer record. I would like it removed from all existing customer records but I don't want to change the number before the suffix. If I tell it to update existing records, will it overwrite
      • Next Page