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

      • Forgot password to my notebookd and notes

        Exactly what the title says. I know it sounds dumb since it's my own fault but what can I do? I'm just wondering if we can recover our password or something. I see there's no such feature but it should have right??? This is really frustrating to me because
      • Problems with email configuration and slowness in Zoho support.

        I've been having problems configuring emails since yesterday, they responded to me today, I sent a response right away and so far I haven't received a resolution to the problem. Attached are the configuration attempts that were made.
      • Ajuda! Não é possível enviar mensagem; Motivo: 554 5.1.8 E-mail enviado bloqueado

        Não estou conseguindo enviar email está aparecendo isso ai amorproprioterapias@amorproprioterapias.com.br
      • Kaizen #60 - Get Records, Search Records, Query and Bulk Read APIs

        Hi everyone.. Welcome back! In this post, we will discuss when to use Get Records, Search Records, Query, and Bulk Read APIs to fetch records. Please note that the information in the article holds true for version 3 of Zoho CRM APIs. Get Records API The
      • POP/SMTP issues with Gmail client & problem with support

        Hello! I've recently encountered an issue with POP/SMTP synchronization with my Gmail client. After issuing a ticket to Zoho support, the status shows up as "Invalid" and I haven't recieved any kind of reply. So I figured that maybe the community page
      • Contatos apagados ainda aparecem

        Olá boa noite eu apaguei os contatos que tinha salvo, porem quando clico em "para" na parte de envio de e-mail, ainda aparece os contatos la e as categorias, que tambeém foram apagadas. como apagar completamente os contatos e as categorias?
      • Issue with Receiving Emails After Domain Recovery

        Dear Zoho team My domain recently expired, but I was able to recover it after a period of bidding. While I have reconfigured the domain and can now send and receive emails from newly created addresses, I am unable to receive emails sent to the addresses
      • Connected Records are now supported in the latest version of the Bigin app

        Hello all, Connected Records are now supported in the latest version of the Bigin app on all platforms (Android v1.5.9, iOS v1.6.5, and macOS v1.4.4). The age-old challenge of ensuring a seamless flow of information across departments in businesses is
      • Workflow sync between zoho books and zoho inventory

        Hello, While the custom fields, validation rules and even custom buttons are sync'd between zoho books and zoho inventory, the workflow rules do not. Not sure if this is an intentional purpose of zoho team for some good reason or if it's in the development
      • How to automatically record Amazon FBA returns on ZOHO?

        Hello, We are currently using the beta version of FBA API with Zoho inventory. How do I ensure credit notes are being automatically being generated against returns on Amazon FBA? Where can I track that?
      • Can't download record template as PDF on mobile

        Hi, I used this to download a record template as pdf, it works on desktop but not on mobile: openUrl("https://app.zohocreator.com/" + zoho.loginuser + "/" + zoho.appname + "/record-pdf/Report_Name/" + input.ID,"same window"); Getting a message: "Error
      • Is Zoho Forms Signature field eIDAS compliant

        I would like to know if signature field is eIDAS compliant
      • How to Record Loan with interest

        I have received loans from friend he give me like 2 loans so far one is one year repayment and one short, how to properly record his payment, and repayment and give him statement  for each loan he give me 
      • Can't add Email Alias - AS101 error

        Hi, It won't let me add a alias email address on any of my domains under Admin Console,  User, add alias email address it just says AS101 error, I have never had issues creating an alias address before Please fix this
      • Darshan Hiranandani : Zoho Meetings Outlook Plugin Authentication Issue - Error When Signing In

        Hello Zoho team, I'm Darshan Hiranandani, We’ve been facing an issue with the Zoho Meetings Outlook plugin for the past two weeks. Here’s what happens: When we try to sign in through the plugin, it redirects us to the authentication webpage. After successfully
      • unable to import transactions into zoho books

        I download a csv with separate columns for deposit and withdraw. The sample has zero's in the blank spaces so I ensure mine does too. When I try to import it says the fields must have values greater than zero.
      • Incorrect Device Time

        Hi On my windows laptop I can't sign into Zoho mail due to "incorrect device time". I'm in Toronto, Canada. How can this be resolved?
      • Would like to set up the rule to auto close the ticket

        Hi, i would like to set up rule if ticket body, descrion contain text:”from: DE-2”. Postal code which start with DE -2 should be closed. Is there any symbol to replace all five digits or how to do it? Thanks.
      • Assistance Needed: Employee Not Receiving Zoho Form Email Invite

        Dear Zoho Team, I hope this email finds you well. I am reaching out to seek assistance with an issue we are facing on Zoho Forms. We recently added a new employee to Zoho Forms, but she has not received the email invite. Despite resending the invite multiple
      • "Customise Content" option not showing for drafts or "edit as new"

        Could you please fix the bug that's causing this? If I start a post, then save it as a draft, I lose the ability to customize content for each channel on that post -- the button just doesn't show up when I go back in to edit an existing draft. Same happens
      • Recipient accidentally added to ticket?

        One of my users copied email text from a client into the description of a new ticket. The ticket was intended to be for internal use only, so imagine our surprise when he received an email notification, replied, and his reply was added to the ticket!
      • How to link to/displaya png stored in workdrive in a Creator HTML snippet?

        How to link to/display png stored in workdrive in a Creator HTML snippet? I've tried it as a plain external link and as an iframe. The iframe works but is kinda slow...and I'd prefer to be able to do finer-grained positioning but referencing the png as
      • Zoho Creator Integration with QuickBooks: A Step-by-Step Guide

        Introduction: Integrating Zoho Creator with QuickBooks allows you to sync your business data between the two platforms, providing a seamless experience for managing accounting, invoicing, and financial data. This integration helps automate workflows and
      • Zoho Advanced Session audit is hogging RAM

        Hi! I've been noticing an issue with Zoho Unattended where it occasionally takes up a lot of the RAM on our computers. It's causing issues for me on PCs that are alreayd low on RAM. Does Advanced Audit have to be disabled for our entire organization to
      • Issue with Blueprints in Zoho Desk

        Hello, I’m experiencing an issue with Blueprints in Zoho Desk. I have some Blueprints that haven't been modified since July 28, 2023, but they suddenly started having issues. In some cases, it’s not possible to move to the next stage; when clicking the
      • WHMCS Integration

        Hello, I was hoping that someone might be able to help me with this one. We use Zoho Desk for support tickets for a couple of companies. One of them uses WHMCS for client billing, payments etc. One area of WHMCS that we do not wish to use is the in-built
      • INVALID_OAUTHTOKEN using Self Client Access Token (Android)

        Hi, I using the Zoho Android Demo app to try to evaluate Zoho Assist. https://github.com/zoho/Assist-Customer-Android-SDK-Demo I am successfully able to get an access token by POSTing the generated code from Self Client via POSTMAN. scope = ZohoAssist.sessionapi.ALL
      • Reorder Point trigger for custom action

        Is there a way to trigger workflows when stock on hand reaches an item's Reorder Point? Requirement: When stock on hand for an item reaches the reorder point, a Purchase Order is created with the concerned item in it, and its quantity is based on a custom
      • Introducing a Refreshed Design To Enhance Your Zoho Books Experience

        Hello users, We are excited to bring a refreshed design along with enhancements to the user interface in Zoho Books. You might have already noticed the new color themes with redesigned icons in your Zoho Books organization. Here’s everything you’d want
      • HOW CAN I ADD A PDF OR ANY FILE DOCUMENTO ON A CELL FROM MI C: DRIVE PC WITHOUT A WEB STORAGE LINK

        I want to add a PDF file reports on a ZohoSheet Cell but i dont know how. I can add images but not files. Can you help me? Thanks a lot.
      • Where can I find my documents

        I am evaluating solutions to store text documents. I once created one text document on zoho and worked on it. I came back to zoho a few weeks later. Impossible to find it again. Is there a web page containing my documents or my folders? How can I retrieve
      • way to change the interface language (e.g. to English) in the whole Zoho One ecosystem at once

        Hi everyone. I had a need to create a new Zoho One account for a new company. However, since I did it from Germany, I have defaulted to German language in Zoho One interface (in all apps). Can you please tell me if there is a way to change the interface
      • Holidays and celebrations: Unveiling SalesIQ's seasonal theme!

        The holiday season is upon us, and we are feeling all the more merrier at SalesIQ while we unveil this seasonal update. Get ready to sprinkle some holiday magic onto your websites with SalesIQ's new seasonal theme. This new festive theme will provide
      • Allocate emails to user in a shared mailbox

        Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
      • Function not working if more then 1 Record is selected

        Hi there! I have a function like this: string button.PCS_TempDruck_Rechnungen(string Modul, int ID) { //Do some stuff here return "finish" } I linked this function to a button in the List View and Mass/Multi-Action of the Quote Module. Arguments: Module
      • Assistance with Setting Default Values for Zoho Chat Custom Fields

        I am currently using the Zoho Chat JavaScript API to successfully add custom fields to the chat interface. While the implementation of these fields has been smooth, I am now looking to set default values for these custom fields. However, I couldn't find
      • Unable to delete Junk Lead and Not Qualified from the Lead Status field

        Are Junk Lead and Not Qualified default fields or something that cannot be deleted? I have gone into the Leads module and made sure there are no records using these values. Other values have a minus sign that allows me to remove them, but these two fields do not have that option.
      • Customer Happiness not clickable when using API

        Is there a way to automatically add the Customer Feedback links when generating email drafts via the API? Currently, the feedback links are only added when generating an email draft using the UI. I tried using the endpoint described in https://desk.zoho.com/DeskAPIDocument#CustomerFeedback#CustomerFeedback_Getthecustomerfeedbackplaceholderlink
      • Email Alerts for New Audit Log Entries in Zoho Desk

        Dear Zoho Desk Team, The Audit Log feature in Zoho Desk is a fantastic tool for tracking changes and ensuring transparency in the helpdesk. However, to make this tool even more effective, I’d like to request an enhancement. Currently, there is no option
      • Free user licenses across all Portal user types

        Greetings everyone, We're here with some exciting and extensive changes to the availability of free user licenses in CRM Portals. This update provides users with access to all Portal user types for free to help them diversify their user licenses and explore
      • Next Page