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

      • CRM Hack #2: Automate sending of birthday greetings to your customers.

          Hello everyone! What sets you apart as a sales person is your ability to add that personal touch to your business relationship with your customers. Sending a gift on a special day, or leaving a note wishing them on their birthdays, are small, yet significant actions that show your customers that you care. And these are actions done without any expectations :) You must be engaging with a lot of customers and it is highly unlikely that they all are your friends on Facebook or some social channel,
      • Restrict Announcement Pop-ups to Administrators in Zoho Desk

        Dear Zoho Desk Support Team, We are writing to request a feature enhancement that would allow organizations to restrict announcement pop-ups to administrators only. Currently, announcement pop-ups are sent to all users within a Zoho Desk organization,
      • Contact info for the sales team

        Hi, My employer is currently going through a merger, as part of the process, we need to decide which service we go for, for use as our IT ticketing system. As my team already use Zoho Desk and are familiar with using it, I'd like to carry this over into
      • Add StatusIQ Tab to Zoho Desk for Seamless Incident Management

        Hi Zoho Desk Team, I hope you're doing well. We would like to request the addition of a StatusIQ tab within Zoho Desk, allowing support agents to seamlessly view and, with the appropriate permissions, manage incidents in Zoho StatusIQ directly from Desk.
      • Linking an email to a Contact when the email is sent in deluge via sendmail

        The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that
      • Live Chat API

        Is your Live Chat available through API. For instance am I able to use your API to grab a Live Chat so I can configure my PBX to call that API and allow the Live Chat to ring to our phone system ?
      • Zoho Learn

        Hi Support I can not seem to be able to load media on Zoho Learn it keeps buffering and not responding. Please assist.
      • Announcement integration between Zoho People and Zoho Connect

        As we're using these 2 products, there're areas of overlapping especially in the Announcement. When there's a new announcement in Zoho People, can it push to the company wall in Zoho Connect?
      • Internal Notification Email contact fields

        Whenever a new customer is added in Books we add the contact to Campaigns. This is easy to do via sync. We need to send an internal email when the contact is added in Campaigns. This is also easy to do with "Internal Notification Email" automation. Question
      • zoho account

        we are unable to log tickets to IT due to our zoho account we unable to open
      • WhatsApp

        Hola quiero saber cómo puedo integrar WhatsApp y Zoho desk
      • Auto CC is Off but still sends email

        Hi, I often forward an email from my work address into the ticket system using my custom support@xxxxx.zohodesk.com email. Even though I have the Auto CC email replies to my support box Off (image attached), It still includes that when I reply. And if
      • How to change the pdf title of invoice

         Hi! When we generate an invoice in pdf format, the title of the document still appear in English, for example Invoice-XXX How we can customize the title of the invoice generated?
      • Paypal Payaments Pro not available in our live account.

        We have a test environment set up and one of hte payment gateways is paypal payments pro. This option is not avaiable in our live account and the regular paypal gateway says auto-charge not available. Why does paypal payments pro not appear in our live
      • Displaying Inactive Customers & Vendors

        Can we please have this choice in general settings, it's a pain showing hundreds of inactive records. A simple search clears the "Active records" filter ! A simple message showing "Inactive records match your search criteria but have been omitted, would
      • Ticket rápido e simples

        Boa tarde pessoal! Tudo bem? Me chame de gustavo! Estou em busca de um sistema simples, prático e rápido!,sendo o seguinte caso: Como possuimos um serviço de endereço fiscal, onde os clientes criam endereço fiscal conosco, ao longo do tempo nós recebemos
      • "sudo" for Zoho Creator

        There should be a way to allow for the developer/owner account to switch user to any one.  I need to be able to test the roles of all my users of my app and because logging off and back on is way too ridiculous, I've had to code in my own pseudo-sudo app.  It really slows down the app.  There should be a built-in way for me to just be able to assume the identity of any user at any point in time during the use of the app.
      • Adding Attachment to Desk Ticket via Deluge

        Hello, My team has a process where some people are entering information into a workbook in Zoho Sheet, and we need to get a copy of workbook into a ticket in Desk. We currently have a 'Submit' button on the Sheet that triggers a webhook to Flow, and from
      • Enhancing self-service capabilities with AI-based Zia Answer Bot

        Hello All, Zia Answer Bot is available with better accuracy to enhance the self-service capabilities of the platform and to empower the users to resolve queries independently. By leveraging knowledge base (KB) resources, the Answer Bot provides accurate
      • Custom module in Portals won't edit

        I have a custom module but Portals access users can't edit it. They can create and delete though. In the Portals settings I have Create, Edit and Delete set turned on. Anyone know what this could be?
      • Multiple email accounts in MacOS mail app

        Hey, I am facing a problem while using Zoho mail app on macos. The clear description of the problem: I am managing multiple Zoho accounts and each of them have some custom email addresses. address1@domain1.com is my main account, address2@domain2.com
      • Convert Leads to Deals in Portals?

        Is there a way to convert leads to deals, like the main program does? It doesn't seem to do it in portals. It seems a bit pointless having it.
      • Need Marketing specialist for Zoho client

        HI, I am looking for someone to help a client with their social media marketing. I have set up Zoho for them, but they want to start various social media campaigns and are looking for a referral. This is for a marketing person who is familiar with Zoho
      • Error: Invalid login: 535 Authentication Failed 0|server | at file:///var/www/html/AHFits/Controllers/mailer.js:70:35 0|server | at process.processTicksAndRejections (node:internal/process/task_queues

        I tried every thing anable 2 factor auth, generate app specific password, add MX,SPK,DKIM everything i can do but still I am unable to user email through nodemailer. I work on development but when it Runs on production(VPS) I got 535 Authentication Failed
      • Not Receiving Incoming Mails

        Today I had successfully verified and configured the Zoho Business Mail setup for my domain "weturn.ae" But the Business mail ID i had created not receiving the incoming mails but I can send them. So Please help me with the issue
      • Private Tickets

        Sometimes we want to be able to create a ticket for a customer that they cannot see either in email or in their help center. Sometimes we see an issue on their account or something odd, or our analytics show something proactively needs to be addressed
      • Determine which Notebook a Card is in?

        How can I find out which Notebook a Card is in? I.e. I search on "septic" and find that there is a Card named "Septic Status" but I need to know which Notebook it is in because I want to move it to a particular one.
      • spark sync problem with iphone

        Hello, I am using the spark application on iphone 15 pro max and 16 pro max. After several days of installing the account on spark i dont get notifications on new emails, i have to open the app in order to receive the new emails. After sending email to
      • Problems with receiving mail

        Здравствуйте! На сайте exmo.com пришлите мне письма, но на мою почту .... @ zohh.com они не приходят. Что может быть неправильным?
      • info, hr, support, ... etc.

        Hello, I want to have a dedicated inbox email as info@mydomain.com, hr@mydomain.com, support@mydomain.com ... etc. , and be able to use these email inboxes inside Zoho applications like using the info with my CRM Email configuration, the email used for
      • How to add curly quotation marks and apostrophes in Zoho Mail

        Is there a way to set up Zoho Mail so that, when I compose email messages, my quotation marks and apostrophes are curly rather than straight? I read a couple of 12-year-old conversations about this topic but specific to Zoho Writer and there was no
      • Zoho task approaching due date notification on Cliq.

        Hello, Currently is possible to set reminders on each task to send an email to the task owner on x days before the due date. I'd like to propose a configuration that you can set in a way that sends cliq messages to the task owner when the due date of an task is approaching (like 3, 5, 7 days before, it's supposed to be configurable). Would be nice to have this kind of notification. I've integrated my Projects with Cliq Extension and it does not have this function (as far as I know) Does somebody
      • Addition of RE: to Every Reply Email

        Hi, In Zoho mail every time I reply to an email it puts a RE: in the subject line. So after a few replies on same email the subject line looks like RE: RE: RE: RE:RE: RE: RE: Order Details Can I stop Zoho mail from doing this bug? Thanks, Grant
      • Operation not permitted

        I'm trying to set up email for this site - pawsathome.uk - and when I go to: Admin Console>Domains>Add> I keep getting error - 'Operation not permitted' - See attachment. WHY??
      • In this zoho email option ₹700 /user /year what is the storage space provided?

        In this zoho email option ₹700 /user /year what is the storage space provided?
      • Zoho Mail Setup for New Domain ModZbig.com

        Respected Zoho Support Community, I have this account as my personal account, I bought a new domain https://modzbig.com/ and I need to know can I setup free Email Setup with this account for my new domain. My new website is about to provide latest mod
      • Consigo excluir um e-mail que enviei errado?

        Olá, enviei um email para um cliente e escrevi coisas erradas, como posso excluir este email enviado da caixa do cliente? existe essa possibilidade de cancelar e-mails que foram enviados? Obrigada
      • Unable to send message;Reason:553

        Can Receive email, but Not sending. Please check & let me know the possible solution.  zb14340497 Thanks
      • Power-up your app with spreadsheet editing using Zoho Office Integrator!

        Hello users, Did you know that you can create and edit spreadsheets right in your web app? With Zoho Office Integrator's embeddable spreadsheet editors, you can easily add the capability to create and edit spreadsheets collaboratively in your app. With
      • Time Based Workflow Rules for Projects and Tasks

        Project managers spend a significant amount of time manually monitoring task deadlines, notifications, and follow ups. Zoho projects' Workflow Rules help automate these repetitive processes and save valuable time. Workflow rules are a set of actions that
      • Next Page