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

      • How to export Subform Data from a record?

        How can we export the subform data from a record? Currently we can import data, but I found no way to export data from one record I need a simple button to export the current subform data to an excel file, why can we import subform data but cannot export
      • Trident: please make right widget column re-sizable

        I'm really enjoying using Trident and think Zoho is doing a great job developing it and adding features without cluttering the interface. However, the one thing that keeps irritating me in daily use is that the right side widget column is too narrow to
      • Does Client Script work on Zoho CRM Portal?

        Hi ! I create a new module to use at customer portal. But Client Script looks not work. Please help me clarify, thank you!
      • Unattended Sessions - Groups and Access

        I would like to see Groups to organize Unattended Computers (what is currently labeled "My Computers") and a way to restrict access to individual users to specific groups.
      • Need help in search with formula culums in reports

        Hello, I do not know where to start with this one : I have a customer report with all that was bought and paid by my customers. It can be many records for one specific customer. Ex. Customer A has 1 record for a purchase of 1000 $, and 2 records of payments
      • Genie baked into Truesync

        Shouldn't the functionality of genie be baked into truesync? This is how google drive's desktop app works. It's minor but annoying to have 2 things loaded when it seems it should all just be one app. Just an idea.
      • File attachments adding date and time to name when uploading?

        I have set up a function that uses the mail merger api to get a lead and fill in the details, it is basic but was just using to test will fill in all the details later, It works perfectly fine the only issue i have is that when it uploads the file into
      • Optimizing Zoho CRM & Xero Workflow – Advice Neede

        Hi everyone, We’ve been using Zoho for all CRM functions and Xero for all accounting, but the workflow between the two has become difficult to manage. The business does not want to move from Xero, as it's the accountants’ preferred system, but we need
      • Open word documents directly within zoho writer without converting

        There was an article in the help page that said that there would be a feature where zoho writer can directly open MS Word files without the need to convert those files to zoho format. It was said that it would be available by Q1 2023. Here is the article
      • Not receiving email at Outlook

        Hi, I've set up the account and can do everything except receiving email at Outlook. Please find print screen below parameters configured and advise what could went wrong. I can send email from both Webmail and Outlook. I could, however, receive email
      • To unblock , ensure atleast 5% free space of your total mailbox size exists after email deletion.

        Bom dia, Já deletei todos os e-mails , mas ainda não consigo desbloquear o e-mail comercial@hidrotecnicauberlandia.com.br. Já faz dias que deletei, mas ainda não desbloqueia quando sigo os passos de UNLOCKED ME. Por favor me ajudem.
      • Zoho does not send invitation email if meeting is created in calendar

        Problem: I create a meeting in calendar and add attendees. After "Save" button it asks me if I want to send email to all ettendees, I click Send. But none emails are sent. I did try that over outlook (connected thru active sync) or in zoho web mail. Nothing
      • Accepted meeting invites not showing on calendar

        I can receive a calendar invite to a meeting, I confirm I can attend and hit accept. I then check my calendar and it doesn't show. 30 seconds later, it does show up but it is delayed leaving the feeling something didn't work correctly. Can this be improved,
      • No fue posible enviar el mensaje;Motivo:553 Relaying disallowed. Invalid Domain - admin@laboratoriosantarosa.org

        Hola Renovamos después del tiempo el dominio, y luego de eso se cayó el servicio de correo. Seguimos las indicaciones que se indican en este articulo, sin embargo, hasta el momento solo podemos recibir correos pero no enviar. Hemos actualizado los registros
      • No Hope for Zoho Meeting

        Zoho Meeting is just the poorest meeting app I've come across in a long time. The support sucks too. I called to see if there was anything that could be done on the backend and while I was on a test meeting with support the video was lagging and freezing
      • Client reminders

        Hi Is there anyway to send automatic client reminders when we are pending a response from them? For instance, in a blueprint, say you have a transition that asks them for some additional information... They may take a while to reply, so is there a way
      • Blueprints: Create Global Transitions

        Dear Zoho Team, it would be nice we could create global transitions for blueprints. The use case would be the following: We have 4 different processes with the same transitions in different orders. We could create 4 different blueprints, but whenever
      • AS101

        I'm having issue while adding email alies to an email. Please help.
      • Adding fields to campaign members

        Is it possible to add fields to campaign members? I want to be able to insert a date that certain actions happened as we progress a client, but can't see where or how I might be able to do that
      • Remove Zoho contract upsell at customer sign completion page

        Hello, I am going through testing for a zoho contract for my organization and I noticed that after the customer signs the contract they are forwarded to a completion page that tries to sell them on using zoho contracts. I find that very unprofessional
      • Retain Jira Ticket When Merging Tickets in Zoho Desk

        Hi, We would like to request a feature enhancement for Zoho Desk's ticket merging process regarding Jira ticket retention. Current Behavior: When merging two tickets (manually via the interface or through the API), we can select the "master" ticket into
      • Zoho Signing embedded with iframe is moved out of view when navigating to focus signature on mobile devices

        Dear Zoho team, I'm having difficulty embedding the signing url into a website for users to sign on their phones, it's not working perfectly. The problem occurs after the user accepts and continues to sign, or the user clicks to redirect to any of the
      • How to hide tax Rate in the Sales invoice print-out

        Hello everyone, Can I get an enlightment for my issue that relate to the tax rate in the Sales invoice print-out?
      • Created delayed alerts

        We have a custom alert & rule that notifies our service alerts email address when new tickets are created but these alerts are sent out immediately when a ticket is created, is there a way to set the alerts to be sent out 15 minutes after the ticket is
      • [Resolved] Add rows in subform with Excel / Sheet datas

        Hi! I'm trying to build an application where I can choose an Excel / Sheet file from a Workdrive folder, and for each data in the file, I create a row of a subform. But I can't do it, here is the code I have: inputString = input.choose_xls_file; separatorIndex
      • zoho vault api create secret need crypto files and documentation

        Hi zoho vault api - I am trying to create secret.But the documentation i snot complete.Can you please help with the crypto files for encrypting decrytping the scecrets and also make password policies/category..Appreciate your help Thank you Subin Ba
      • Having a Secure website instead of HTTP it is HTTPS

        I just purchased a website address, but when I am on the site, it says my website is not secure. How can I get my site secure?
      • Unable to send message; Reason:553 Relaying disallowed.

        Domain name kiblaf.vn . I can't send email. help me
      • UCEPROTECT-Level2 Listing

        mx.zoho.com, mx2.zoho.com and mx3.zoho.com IP ranges are all in the UCEPROTECT-Level2 range. Can you please request a delisting, and also add the specific IP addresses within the range to the whitelist at whitelisted.org
      • How create to the same email address in Zoho?

        Hi All! I connected my domain bluefieldpainting.com with zoho and then create an email info@bluefieldpainting.com, by mistake i deleted all the records of that email that zoho gave me to put in your DNS server! now that email is no longer to receive emails!
      • event_VbFeVEcfasxiBpmGm8SBeMdT Response: Zoho: Invalid login: 554 5.7.8 Access Restricted. For more details, check this announcement: https://help.zoho.com/portal/en/community/topic/zoho-mail-server-d

        I just received and Email from EmailJS service may have stopped working or is unstable. It failed to send the email at least three times in a row. To analyze the cause of the issue, please visit the Event page in the dashboard or press the button below.
      • Zoho Developer Community Monthly Digest – February 2025

        Hello everyone, First of all, an apology is in order—our January digest got swept away by a whirlwind of hackathon madness. But fear not, February's digest is here to make up for lost time! We’ve got everything from upcoming events like the Zoho Developer
      • Unable to Receive Emails – Address Not Found

        Dear Zoho Support Team, I am experiencing an issue with my Zoho Mail account where I am able to send emails, but I am not receiving any emails from external senders. When someone tries to send an email to my Zoho Mail address, they receive a "Address
      • can't connect to smtp server

        I keep getting an authentication error when I try to establish a connection with smtppro.zoho.com. I'm using port 465 and I've double and triple checked my credentials. Any way to resolve this issue? Thanks.
      • Finding inactive Zoho Mail users

        As an admin, is there any way for me to find out which of the 75 users/mailboxes on my account are totally inactive? I.e., accounts that are neither checking mail through mail.zoho.com nor using IMAP, POP and/or SMTP to access or send messages? Account
      • Getting error for invalid session on zoho mail

        Since yesterday I am getting following error when I am trying to log in on zoho mail your session is invalid. you will be logged out in 3 seconds!! Can someone please help me how to fix this? Thanks Manoj
      • The Zoho Meeting Video Quality Crisis

        I'm evaluating Zoho One for my business in Switzerland, and I must address a critical concern that threatens our potential adoption of the platform—the persistently poor performance of Zoho Meeting's video conferencing capabilities. In today's digital-first
      • Add LinkedIn Triggers and Actions in Zoho Flow

        Hi, We would like to request an enhancement in Zoho Flow to support LinkedIn triggers and actions. Why LinkedIn Integration is Important LinkedIn is a crucial platform for businesses, providing a professional space for networking, brand visibility, lead
      • Default date format

        What is the default date format in DataPrep? When I hover over a date column it says "yyyy-dd-MM" which is incorrect. That is not the standard date format when working with data and my raw data is correctly formatted as "yyyy-MM-dd". So why is DataPrep
      • Announcing new features in Trident for Windows (v.1.22.3.0)

        Hello Community, Trident for Windows is here with exciting new features to elevate your workflow and take workplace communication to the next level. Let’s dive into what’s new! Zoho Voice integration. You can now easily manage business calls with the
      • Next Page