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

      • single user access to the CRM suits

        I am currently using Zoho CRM Plus, where the pricing for a single user is ₹3,500 INR, and it includes access to multiple applications. However, I would like to add an additional user but restrict their access to only two specific applications within

      • Zoho Commerce / Zoho Inventory Integration

        How can I remove products in my Zoho Commerce products section? I have a big list of products here that are linked to our Zoho Inventory and some are published on our site and some aren't, but I'm wondering how we can remove these products from this list

      • Pinterest's "Claim website" requirement

        Hi, I need to get Pinterest and my Zoho website to shake-hands. For this, Pinterest needs me to 'claim my website' by adding a piece of HTML code to the <head> section. But is this the same as "Header and footer" sections in the settings? If yes, then

      • Quickly delete items in email builder?

        When deleting items in the email builder, it requires two clicks: one to hit the trash icon on the item, and then another click to confirm the delete. Is there anyway to skip the confirm deletion? Some kind of hot key like the Command button on the mac

      • Separating Inventory for Online Shop and Other Customers in Zoho Commerce & Inventory

        Hello everyone, We are using Zoho Commerce and are facing a challenge in managing our stock for different types of customers. Specifically, we want to ensure that our online shop pulls stock only from a specific warehouse, while other customers (e.g.,

      • Use of External Email Services

        Would like the ability to use an external SMTP service to send emails campaigns in Marketing Automation.  Services like SendGrid, Maligun Amazon SES, etc

      • Next Level - Turn this product into an Adobe Experience Manager Competitor

        I think Zoho Marketing Automation can best differentiate itself from the Zoho Campaigns and other Marketing related products better by tying the entire suite of marketing tools together not only in a viewable instance but in terms of developing internal

      • Quickly review loan applications for maximum efficiency | Kiosk Studio Session #5

        Looking for more ideas? Please check out our other posts! Session #1 covers how to view customers from the same industry. Session #2 covers how to build a call script kiosk. Session #3 looks at streamlining appointments. Session #4 shows how kiosks can

      • Zoho Finance Workshop 2025 is Happening Now!

        Hello everyone! 👋 We’re thrilled to announce that the Zoho Finance Workshop 2025 has officially started, and we've already wrapped up the event in Chennai, our home ground! After an amazing session, we're geared up to visit more cities in India and take

      • Canvas rules

        I see that we can create canvas rules. However, all I see is a way to define criteria that will control when a Canvas Rule is applied. However, I can't find a ways to define the settings that would be applied when the criteria are met for the Canvas Rule.

      • ZDC Hackathon 2024 Category-wise Winners – Zoho Creator

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho Creator – Product Category award for their outstanding innovations! Team 1: Wonderboy Thandanani MthiyaneTeam

      • Resubmit for Approval for Zoho Books Module in CRM

        The integration between CRM and Books is great, but it is incomplete in many areas. One of them is if an estimate/invoice/sales order is rejected, the users in CRM cannot resubmit it for approval. Let's face it, sales people will mostly be in CRM and

      • Accountant

        Hi if I have a commercial company with multiple sales outlets, sales representatives and multi currency, what is the best subscription you offer? thanks.

      • Sign

        My name is Dolores Houghton. I signed up for sign package by mistake. I can’t use the program and I want my money back. I have been sent various instructions on how to delete and ask for a refund. Nothing works. I am not able to get into settings for

      • Zoho CRM and Books integration (related list) column customization

        I was wondering if it's possible to add more cloumns (more informations) inside the related list that we get when we enable the integration. As you see we would like to be able to add more information on the invoice (or the same for PO in vendor).

      • Adding Client VAT and BRN in our Invoice

        Hi, Following request from our clients, we need to add their respective VAT and BRN in the invoice that we issue. Could you please let us know if this is something that we can do?

      • Zoho Analytics - Level on level queries

        I am facing a limitation of having too many level on level queries however some of my queries are complex and rely on multiple joins to get my desired output. How can I bypass this limitation as this is hindering my report creation.

      • Manipulate the Date Time field using deluge

        To update the DateTime field using deluge. CurrentVar = zoho.currenttime; TimeVar = zoho.currentdate + " 10:00:00"; if(CurrentVar > TimeVar.todatetime()) { CurrentNew = zoho.currenttime.toTime("yyyy-MM-dd'T'HH:mm:ss").toString("yyyy-MM-dd'T'HH:mm:ss+04:00");

      • Configure Notes Title for Blueprint Transition

        It'd be very helpful to be able to configure note titles on blueprint transitions when requiring notes. This would help tie back the history of notes to the blueprint actions. We have some approval processes in our blueprint and require notes for the

      • Website not publishing

        My website with Zoho (domain purchased on Zoho) - GilmoreGirlsGetaway.com - has been active for a few months now with no problems. I went to change the template and make modifications today, but as soon as I click "Publish" it says "Error occurred while publishing - contact support". The website preview looks fine, it just won't update. Thanks, Laura

      • ZDC Hackathon 2024 Category-wise Winners – Zoho CRM Client Script

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho CRM Client Script – Product Category award for their outstanding innovations! Team 1: Marcin Duchnowski Team

      • ZDC Hackathon 2024 Category-wise Winners – Zoho CRM Custom Function

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho CRM Custom Function – Product Category award for their outstanding innovations! Team 1: Onur Gulay Team 2: Yonathan

      • ZDC Hackathon 2024 Category-wise Winners – Catalyst

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Catalyst – Product Category award for their outstanding innovations! Team 1: Raghavan P, Santhosh Kumar K, and Jayabalan

      • ZDC Hackathon 2024 Category-wise Winners – Extensions

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Extensions – Product Category award for their outstanding innovations! Team 1: Puneet Chandhok, Parv Kumra and Akriti

      • ZDC Hackathon 2024 Category-wise Winners – Zoho SalesIQ Zobot

        Hey everyone! After rigorous evaluation by our 14 expert judges, we’re beyond excited to announce that two incredible teams have won the Zoho SalesIQ Zobot – Product Category award for their outstanding innovations! Team 1: Naveenkumar M, Tulasidhasan

      • Announcing the Zohotshots of the ZDC Hackathon 2024

        Hey everyone! After 46 days of innovation, collaboration, and intense competition, the first-ever Zoho Developer Community (ZDC) Hackathon has officially concluded! 🎉 With 1079 participants, 797 teams, and representation from 45 countries across 6 continents,

      • Retrieve separate records from multiselect lookup field

        Hi, I know there are many post on this one, but I just don't get it. I have a multiselect look-up field named Delivery containing 3 different informations like this : Montreal - Tuesday - 3 to 4 pm I need to do an IF script based on the first item in

      • Now connect your existing WhatsApp business account with SalesIQ

        We had a great response from our customers for our SalesIQ - WhatsApp channel that we released a while back. The WhatsApp channel used Twilio,  a third-party app, to connect your SalesIQ portal to WhatsApp. However, there were a few limitations, and one

      • Deluge script that creates a popup with a dropdown list of choices

        Hi, In an order form, when a portal user choose a delivery day, another field is automatically filled with a delivery location, and that field is not linked with a lookup. I have now one day of the week that has 2 delivery locations. I do not want to

      • Lookup Field Values In BulkRead

        I am pulling cases from the Zoho Case module using the BulkRead API. However, I am receiving IDs (random numbers) as field values. I later discovered that if I include column_name.Name in the returned fields, I get the actual value. However, this approach

      • CRM portal users can now log in using their mobile phone numbers

        Hello everyone! You can now invite portal users using their mobile phone numbers. These portal users will be able to log in using their mobile number and OTP. Templates for these portal-related SMS can be customized as per your needs. This enhancement

      • Menu Bar

        Hi, Please guide how to change menu bar from vertical to horizontal

      • Insert information on another form of a Zoho loginuser

        Hello, I have 2 forms that are linked, a customer form, and then a subscription form in which there will be a subscription number that I would like to transfer back in a field of the first form called "current subscription number", How do I write the

      • Kaizen #78 : How to disable clone record?

        Hello everyone! Welcome back to another interesting Kaizen post. In this post, let us discuss a workaround solution for the use case - How to disable clone record for a user. Requirement Consider that you want to disable the clone option for the Deals

      • Mass-Delete-Action over API doesn't work because of scope

        Hi all, we're currently trying to mass delete 40000 deals from our CRM, that we have already put into a custom view. I'm not that used to the API, but I managed to authenticate by https://accounts.zoho.com/oauth/v2/token with Postman and going by the

      • Can you be a Learner as well as a Contributor

        If you are the Author or a Contributor, can you also be assigned as a Learner? This is particularly relevant if you need to certify that you have taken the quiz and done the learning yourself!

      • Edit button near "x" (delete icon) for lookup fields

        Hello, What do you think about possibility to edit record, selected in lookup fields by clicking "edi"t (pen icon) located near "x" icon? You can choose in which View user will edit record You can show or hide icon programmaticaly Look here: https://drive.google.com/file/d/0ByIK2qthuUqwRWktenZFQ2czT1k/edit?usp=sharing

      • Add Serial Number Zoho CRM Subform

        Hi Guys, I need to add Serial Number in Zoho CRM Subform table. In addition of an row we can easily create in Zoho Creator. But in Zoho CRM how we can do that? Any suggestion would be very helpful. Moderation Update (10th June 2025): I'm locking this

      • Access Sales Order line Items in Deluge

        Does anyone have a Deluge snippet that shows how to access an Order_Items from a Sales_Order? Thanks in advance! Brenedn

      • Protégez et valorisez votre contenu avec un filigrane personnalisé

        Un filigrane est un élément visuel, tel qu'une image, un texte ou un motif distinctif, intégré dans un document numérique ou physique. Généralement semi-transparent, il se superpose au contenu original afin de préserver sa lisibilité tout en restant reconnaissable.

      • Next Page