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

      • 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
      • Field value permission to set for automation to work as expected?

        I would like confirmation on the CRM software behaviour with the following configuration. A while ago I had discovered the solution by trial-and-error and now I don't remember what the conclusion was. I have a picklist field in the layout that I only
      • Default view in Email on Company Module

        Is there a way to default the view on the COMPANY module to be "Emails Associated with the Related Contact" it is extremely frustrating to have to swap it every time. This is fairly new - it used to have it defaulted differently
      • Bill Discount account and inventory valuation

        Item x rate 100 discount 30% bill net =70 but when checking the inventory value i found it 100 not 70 because the 30 ( discount) went to the expense deduction account so it will reflect in the profit, however the goods not sold yet The discount account
      • Kaizen #111 : Set default values based on Page Layouts using Client Script

        Hello everyone! Welcome back to another interesting Kaizen post. In this post, let us discuss how to set default values for fields based on different layouts using Client Script. In this Kaizen post, What are Page Layouts? Client Script is specific for
      • YET ANOTHER BUG: Client Script Flyouts no longer acting like Flyouts

        As per https://help.zoho.com/portal/en/community/topic/kaizen-157-flyouts-in-client-script one of the key benefits of a Flyout over a Popup is the ability to move it around the page. This no longer works. The "width" and "height" configuration settings
      • Translation in Zoho CRM now supports various regional languages

        Release status (Last modified on January 2, 2025): This feature is currently available for all users in enterprise and above editions, across all data centers. Hello everyone, Imagine a multinational company with teams spread across various regions, each
      • Drop down of Zoho users aka Employees

        Is there any field I can add to have an up-to-date list of current Zoho users ? Use case is for an employee to select their manager - however I don't want to have to manually populate a dropdown field every time someone joins or leaves our company. Why
      • Last Name / First Name

        Hello , My company adds contacts on a "Last Name , First Name" basis. We've noticed that when viewing accounts there is no " , " (comma). It's VERY misleading. I have set the custom view to show "last name" "first name" instead it joins them both and
      • Launching CPQ for Zoho CRM! An in-built solution for bespoke quote management

        Hello everyone, We are thrilled to announce the public release of CPQ (Configure, Price, Quote) for Zoho CRM, which is a fundamental block in sales management. NOTE: CPQ was a public early access feature from March 2023 — January 2024. Since February
      • Unable to receive emails on outlook

        I am able to send on outlook, but unable to receive. None of the settings have been changed and it was working perfectly up until a few days ago.
      • Zoho Creator User Group meetups in a city near you!

        Greetings from the Zoho Creator team! We're excited to announce that we're hosting a series of Zoho Creator meetups in various cities across Australia and New Zealand. We invite you to join us for an exciting day of learning and fun. Our meetups are a
      • How to view shared mailbox in Outlook

        How to view shared mailbox in Outlook or in another software
      • Mas de 48 horas sin correo

        Estimados, llevamos más de 48 horas sin poder recibir correo y en este periodo hemos recibido información confusa y lo mas relevante es que Zoho dice que esta todo bien y no encuentra el error. Como deben comprender el perjuicio de no contar con un correo
      • Zoho Mail Domain Verification Issue

        Hi, I'm trying to verify my domain drinkkata.com but it shows the following error: Oops! Invalid domain detected by the system. Please contact <a href=mailto:{0}>support-as@zohocorp.com </a> for further assistance Could this be fixed please? Thank y
      • Forwarding or Aliasing Deactivated Mail Account

        We have an employee who has left the company, so his Zoho account is deactivated. I would like to forward any mail coming to his account to another employee, but as it is deactivated, I can't forward it. I also tried setting the same username up as an
      • The SPF record verification fails

        I have set the SPF record for my domain correctly, according to zoho's SPF configuration guide. Also I used some tools to check my SPF record, and all showed it is correct. But the control panel still shows that I haven't finished the verification. So how to deal with it? Thanks in advance.
      • Não consigo receber e-mails de algumas instituições como por exemplo: banco

        Não consigo receber e-mails de agências, bancos e instituições. Envio normalmente, mas os e-mails enviados por eles não chegam para mim, mesmo aqueles que são respondidos no próprio e-mail enviado por mim.
      • How can I send a reply to 100 unread emails in one click using a Zoho account?

        When I select a single email, the 'Reply All' option appears, but when I select multiple emails, the 'Reply All' option does not appear.
      • Sync Gmail for Admins

        Hello. We migrated from gmail to Zoho mail a few years ago, but some users want to be able to use gmail. I have set up dual delivery in the Zoho Mail Admin console. This is working fine. I can't figure out how to sync outgoing emails. Specifically, if
      • Export Tasks From ToDo List whic are in side Zoho Mail

        Hi, I have a list of tasks in ToDo List inside Zoho Mail. How can I export these tasks to Excell sheet? check the attachment for more clarification.
      • Add blueprint buttons to listview and kanban

        Hello, just started to use the Blueprints feature - really useful. I have one suggestion to help this work even better - can there be transition buttons that appear on the top of listview & Kanban? Maybe an option as well - "Blueprint transitions appear
      • I want to cancel the zoho mail service customer number 20060087524

        On February 2nd of this year I bought the zocho mail service for myself and my family. Apart from the mail client via the zoho application, it does not work for me on the iPhone and iPad. I want to cancel, what is the procedure? klient number: 20060087524
      • Whatsapp Integration not working

        Hello. My whatsapp integration does not seem to be working. I have created templates, but whatsapp messages do not go through. They keep telling me to use a templete, even though I do so.
      • CRM Multiline Field Spacing Bug

        If the text in MultiLine field is changed through client script, the spacing isn't reset and we get a lot of empty space Screen Recording is attached that shows the problem
      • Zoho Mail

        Hi Can we use Zoho email for our business? I have a website. In this website, we can use it in the contact page and also in the DMCA page. Kindly, this topic is a bit sensitive. Please give me a detailed reply on this and thank you in advance.
      • DataPrep Export to CRM - Linking Modules

        Is it possible to export data to linking modules in Zoho CRM? If I want to do this will I have to create a custom module using functions and workflows to mimic a linking module? If this is not possible it should be added. I don't see how this is functionally
      • Printing "Reader View" email on MacBook Air

        In Reader View, clicking on the print icon leads to a blank page with just a ZOHO logo and a lock icon at the top. If I save the reader view to PDF to print from there, it only saves the portion directly on the screen, and not the entire email that I
      • Add ability to trigger task automation when a task comment is edited or deleted

        Hello, I see that there is currently the ability to trigger task automation when a comment is added to a task. However, we have a use case in which we would like to trigger automation when the comment is edited or deleted. This will enable us to update
      • Zoho Email

        Hi, it looks like Zoho Mail services is currently having issues. Please update us with the current status resolution time frame. Thanks & regards,
      • Is ASAP user authentication via SAML?

        The ASAP user authentication says to use SSO with remote authentication so that you can use JWTs. The remote authentication help page says that this features is being deprecated and to use SAML instead. Before I go through the trouble of implementing
      • email configuration - email is rejected - what is best way forward

        We started getting rejection/bounce back on email sent out of zohodesk. typically we have SMTP from our domain into zohodesk eg support@example.com our mail respones go back out as example : support@example.zohodesk.com These email bounce with error:
      • Customer Success Pipeline

        Hello all, currently, we are using Leads -> Deals Pipelines to manage our Sales. So far so good. Now, we rely heavily on activating dormant clients and nurturing active clients into ambassadors, or cross- or upsell active clients. I can't wrap my head
      • We would like to make a separate, internal-only knowledge base. Is it possible to have a public department but not display it in the help center?

        It seems like it is not possible to display/hide the knowledge base from the help center per department.  Is there a way to do this? It looks like all department knowledge bases are displayed if they are public, and there is no way to hide one from the help center while keeping it accessible via a permalink URL. For example, lets say I have one KB for Clients and one for Employees.    I want to keep my Clients KB public, and also want the Employees KB to be public, but NOT displayed in the help center.
      • Zoho Analytics - Values gets Duplicated

        In Zoho Analytics, I have two tables: one for Country-wise Sales and another for Country-wise Budget with Region. I am attempting to create a stacked bar chart to compare the Region-wise Budget and Sales Revenue. I have set up a lookup between the two
      • Marking a Desk ticket as Unread after merge

        We have a custom script that runs against every new ticket and auto-merges it with any existing ticket that matches our criteria. That works fine but there is no functionality that reverts the newly-updated ticket back to an "unread" state. I found the
      • Partial Return of Delivery Challan Items

        As per the rules set by zoho for partial return of an item given on delivery challan, atleast one item must be invoiced. what if i have given 3 items to my client on Delivery challan. They will evaluate the items and it will be returned it or will be
      • Unused credits - improper value

        When i try to get the balance statement, it gives it by reducing the unused credits. But I did not unused credits as per bills, even though it is showing like I have. Is there any way to reset the unused credits to zero.
      • Next Page