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

      • Foreign currencies behaviour

        Ladies and Gentlemen, It's really good to hear that you are developing your product, which I like a lot, but honestly, I'm sure you have much simpler issues to deal with. Foreign currencies operations have a HUGE lack in your product. Transferring from
      • Difference between the 'field_read_only' and 'read_only' fields exposed by the Fields Meta Data API.

        The API documentation describes the 'field_read_only' field to indicate that a field is read-only always, implying that no user can ever get the write access for this field. The 'read_only' field's description states that its value can change depending
      • Zoho eCommerce frontend

        Questions about the Zoho eCommerce frontend 1) can different frontends (websites) be used? Zoho eCommerce is the backend with 3 or more websites. 2) how can the Zoho eCommerce frontend be customized to better fit Responsive Breackpoints? thanks best regards
      • Atualização que agora me lascou!

        Bom dia a todos! Recentemente a Zoho lançou uma atualização que permite edição do Subformulário de Itens Cotados na página de detahes do orçamento. Isso está acontecendo demais minha vida pois tenho várias funções nas quais o gatilho de funcionamento
      • Synchronize 2 google calendars in Zoho Mail/calendar ??

        I have 2 google accounts with calendars. Choose Zoho to integrate my info. But some developers have decided that I'm not allowed in my real life to have more than one Google calendar. So please answer yes or no'. can Zoho Calendar have 2 google calendar
      • How do I stop login from requesting an OTP

        I have some users that can login without a OTP request and some not. How do we disable this. Mark
      • Reporting email opens in email shots

        I checked the reports from my emial opens for the email I do every week. Until today, I had 1000+ opens in my email shot free two weeks ago and the week before. I checked today, and this is reduced to 400+. How can these reported numbers be so unreliable?
      • How to open a URL for current selected record from a button in a report.

        Hi, Can you tell me how to open a pop up window for the currently selected record when pressing a button from a row in a report? I've seen very old posts but none of the solutions seem to work for me. Also how can i access details from another report
      • Why am i finding it hard to just allow my widget send data that are inserted to the Report section i need Help from experts am new

        Am really finding it hard to send the data from my widget to the Report section can anyone Guide me Through?
      • Urgent: Assistance Required for Domain DNS Configuration (planb-hub.com)

        Dear Zoho Support Team, I hope you are doing well. I recently purchased the domain planb-hub.com through Zoho, but I am experiencing difficulties configuring its DNS settings. When I tried accessing the DNS management panel in Zoho, I could not find the
      • How to create Calendar Events using Email Alias

        I am trying to create a calendar event using alias emails i have created, but there is no way I can do that without making the alias a primary email. So everytime I need to create an event, I need to go to setting and change the alias to be primary email.
      • URGENT Need to Change/Revert the Home Currency!

        Hello, My colleagues in Germany somehow changed the home currency from US$ to Euro as they were exploring the system for their potential use. Now I have over 600 potentials from the US with data in Euros. What I could find in the help files regarding
      • Prevent subform editing on a module's detail's page

        Hi everyone, We would like to prevent any editing of the subform data in the : Create page Edit page Details page (as subform editing is now allowed by the recent UX update) We are able to prevent editing by making the subform fields read only in the
      • Zoho creator app

        I have created an asset verification application and it has been working fine the past few years on version 5. Now when I punch data or scan barcode then click send the system loads and try pulling the data information and brings it back but the submission
      • App Issue

        I have created an asset verification application and it has been working fine the past few years on version 5. Now when I punch data or scan barcode then click send the system loads and try pulling the data information and brings it back but the submission
      • Calculations in item custom field

        Dear Sirs,    Is it possible to do math inside items in Zoho Books? My item is a pack of plywood. Depending on thickness, there is certain amount of sheets in a pack and, as the result, different volume. I want to add fields like lenth, width, thickness,
      • Payment Gateway

        Hi, Im having an issue with the payment gateway, Im unable to edit/delete the details on paytabs as it mentioned it has peding transactions, although I have deleted all payment links created. See below screenshot
      • Show All Mails

        When there are multiple users working with a single contact, there can be multiple mails to/from each user (but all related to the same contact).   Currently there is no way that I can find that allows you to view all of the mail messages in a single view.   You currently have to toggle between each user in the drop-down menu.  There is one open for "Sent Emails from CRM" that shows all Sent mail messages from all users, but this does not include the inbound emails from the contact.   It would be
      • Zoho books balance vs. bank balance

        I don't know why Zoho keeps changing the Books interface.  I used to see Zoho Account Balance and Bank Balance for the auto-feeds.   Now they are gone??? this has happened a couple of times in the past  .   Please bring it back. 
      • Dark Mode for ZOHO Recruit

        Please make a dark mode for ZOHO Recruit. The white is SO BRIGHT!
      • Issue with Merging PCs in Zoho Assist

        Hi everyone, We've encountered an issue in Zoho Assist that we hope someone can help with or has experience solving. When installing Assist on two identical PCs (same model and ID but physically separate machines), they end up being merged into a single
      • Free webinar: Using Zoho Sign with Zoho Flow to streamline document workflows and signature collection

        Hello, Do you find yourself constantly switching between different apps to simply get a document signed? Attend our free webinar to learn how you can streamline and automate this process by connecting Zoho Sign, our digital signature app, with other apps
      • ZUG Meetup 2025 - India: Meet Zoho Workplace Experts in your city and learn the smart ways to go digital.

        ZUG Meetup 2025 - India Dear Zoho Mail Community, We're glad to announce that the Zoho User Group (ZUG) meetup is happening across 7 cities in India, this year. We will be travelling to these cities to meet you all in person and share our insights on
      • Multiple office locations in Zoho Recruit

        Hi, we have just started to use Zoho Recruit for our recruitment company. Im a little confussed to how we add multiple office bases for the same company name. For example, if it was company ABC, they also have an ABC Manchester, ABC Bristol and so on....
      • Invite External Users to Zoho Projects Without a Full Zoho One License

        Dear Zoho Projects Team, I hope you're doing well. We would like to request a feature that allows external users (such as freelancer developers) to be added to Zoho Projects with a more flexible access model—similar to what is available in Jira. Currently,
      • Columns language changed

        Hello, As you can see in attachment in Zoho analytics some colums of field have change from language to french and some are still in English. We have no idea why but we would like it to be in English all again. how can we do that please ? Thanks
      • Product Updates in Zoho Workplace applications | Feb 2025

        Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this February. Zoho Mail Group Tags for Shared Mailbox Within Shared Mailbox, Moderators can now create group tags, accessible
      • How to integrate Zoho Sign with Zoho CRM

        Hi, I am starting to use Zoho sign for CRM inventory template signature collection. is there any way to fetch CRM inventory template and auto send to specific mailbox by using Zoho Sign API(or other)? I know we can click "Send with Zoho sign", but we
      • POS System

        Has anyone had any luck integrating a POS system with the zoho crm? Any advice where to look for a zoho proven solution? Thanks in advance. Moderation Update: As of August 2025, Zakya (Zoho's POS solution) is officially available in India and is in early
      • Line chart customization

        Hi, is there any way to draw multiple lines on a single line chart. Now on te x-axis im displaying dates and on the y-axis dispalying total records count. I want to display multiple lines on the same chart. The sample image is attached
      • Bigin_Email Notification not being sent when a new lead is created

        I have a workflow in BIGIN set to send an email notification when a new lead is created via a webform (integrated with ZohoForm) The trigger is whenever a contact is "Create or Edit". Conditioning was applied for contacts which source is "Website" If
      • Export all Zoho desk tickets for past 3 months

        Hi I need to export ticket data from Zoho Desk. Specifically, I'm looking to: Export the last 3 months of tickets⁠ include ticket categories, timestamps, resolutions, agent responses (basically as much data as possible) the ticket content being the most
      • Zoho CRM <> Zoho Desk Account Sync

        I have had custom fields in Zoho CRM for a time and would like that data to sync to Zoho Desk. However, since the accounts are all synced to Zoho Desk already, the newly mapped fields are not updating in Zoho Desk. Is there a way to force the sync to
      • Count Function in Zoho Table

        Hi Zoho Team, Hope you're doing well. We would like to request the addition of a Count function in Zoho Table, similar to what exists in Excel, Google Sheets, and Airtable. Currently, there is no built-in way to count the occurrences of unique values
      • Configuring ZMA Webhook for Zoho Flow : Missing Key Information Error

        I'm looking to send a webhook to Zoho Flow at the end of a Marketing Automation journey in order to perform more actions that I can't do with just a journey. I have the Webhook created in Flow and set up in ZMA, however when I test it I get the error
      • Zoho Billing Record Refund vs Refund

        When looking at a paid invoice, the payment record can be viewed. In the more actions, there is a "Record Refund" option. If you click the payment referernce you see a "Refund" option. They bring up different forms. It appears as if "Record Refund" is
      • Emoticons to Slack in Zoho Flow

        When using the Slack integration in Zoho Flow, is there a way to send emoticons in the message? When I tried :emoticon: it didn't translate it to the emoticon.
      • How to set default filter to CRM integration field

        I have a products subform in my order form and I'm using the CRM integration field to connect the Products module from my CRM to this subform. I want to filter the data that is fetched to the field from the CRM based on a status field in the Products
      • How to add "Forever Free Plan" to existing mail lite plan?

        There's an offer for: "Up to five users, 5GB/User, 25MB attachment limit." I already have a mail lite plan. I really like zoho mail and would like this added but I can't seem to access it. Keeps redirecting me to my existing inbox when i click the o
      • i can't create other user with my lite plan

        hello, I have paid little plan and I have added two domains but each has its own user however zoho shows me this message You do not have enough licenses. Purchase the necessary licenses to add, invite or import users I don’t know why if I have another
      • Next Page