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

      • Mass Update Status of Job Openings

        It'd be incredibly useful to be able to mass update the statuses of job openings. I've just been told six jobs are on hold with the same client, so at the moment I need to update all of them individually. Cheers
      • How do you manage sales forecasts by deal when you're a SaaS (subscription) provider?

        Hello, I was wondering how you forecast revenue as a SaaS? Because my LTV moves all the time and I was thinking of updating the amount of each deal in the pipeline according to my LTV stripe, but is it possible?
      • Zoho CRM - Conditional Assessment for Blueprint Automatic Transition

        Hi, Currently, in Zoho CRM’s Blueprint process, the Automatic Transition feature does not allow for conditional assessments before execution. This limitation significantly impacts workflows where a transition should only occur when certain predefined
      • Pending Dispatch Status on Transfer Order TO

        Hello, when our branches request stock, we initiate a TO which puts the item into a "In Transit" status otherwise someone else may try to sell that item, which could be problematic if the item has limited quantities. The problem is that if the item has
      • Zoho Desk's ASAP announcement | Time to embrace the enhanced JWT Authentication Mechanism for ASAP | Dec'23

        Hi All, We are eager to introduce the enhanced JWT authentication mechanism for accessing your ASAP add-ons. Effective December 25th, 2023, the ASAP's old JWT authentication mechanism will be deprecated. This means that the option to switch to the new
      • Trying to copy Active Leads to a Custom Module called Dead Leads

        Hi, I am trying to code when the "Active Lead Status" field is changed to "Dead", a copy of the record should be created in the "Dead Leads" module while keeping the original lead in "Active Leads." I am using the following code but I keep getting the
      • Zoho Desk add OIDC federation for 3rd party IDP

        Please consider adding the ability to use OIDC/OAuth compliant Identity Providers to Zoho Desk. You currently have Zoho, Microsoft, LinkedIn, Google and Facebook. But if you added the ability to use ANY OIDC compliant provider, you would add compatibility
      • how to create a company without an assigned owner

        In my company we are reassigning accounts and we need to leave some companies without an owner to review their potential and then assign them, but the options that appear in owner require that they be assigned to a seller, how to leave them without an
      • Matrix dropdown

        Is there a way to create a matrix question with dropdown answers but 1 row correlates to 1 column? So really I want to combine 4 dropdown questions into 1 matrix but each question has a single, and different, dropdown for answers.
      • Managing Rental Inventory in Zoho

        Can Zoho Inventory manage rental inventory efficiently, or is there another Zoho app that would be better suited for this kind of operation? Looking for advice on the best approach. Thanks in advance.
      • Code API récupération enquêtes et documents

        Bonjour peut-on générer des codes API avec Zoho Survey ou Forms afin de récupérer des questionnaires existants sur nos autres outils ? Comment procéder ? Faut-il disposer d'un abonnement particulier ?
      • Field Updated based off Call Status

        I'm trying to create a Field Update where: When Call Status is Completed Lead/Contact/Account Description field with the information in the "Outcome Of Outgoing Call" Description field. Once our sales team finishes their calls and they add a description
      • User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

        Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.
      • Mass Action Button Script

        Hi all, I've been trying to search a lot of places for a solution on how to do a button placed at the "Mass Action Menu" and thus only updating multiple CHOSEN records at once. After finding no success whatsoever, I decided to just run and test whatever
      • Time Zone Sending in Marketing Automation

        Good day...can anyone share if they have been able to get sending via Time Zones to actually work? Our data is 99% perfect, with all the time zone criteria met, yet the results are completely off target when we try to use it. We've had varied results
      • Which are the IP addresses to use for 'split delivery' with Office 365? (Zoho mail inbound gateway)

        Hi, I'm trying to set up 'split delivery' (email routing) with Office 365. I'm following the instructions to set up Office 365 as the primary server (https://www.zoho.com/mail/help/adminconsole/coexistence-with-office365.html) One of the prerequisites
      • Round robin not processing backlog tickets

        We set up a round-robin for one of our departments which initially worked, but something seems to have broken during the 'tweaking' process as it will no longer assign backlogged tickets of any kind. (I've included images of the settings.) Based on the
      • when I open my sheet ,it always start at "A1" despite I left it at "N234"

        when I open my sheet ,it always start at "A1" despite I left it at "N234"  Is it possible to make the sheet open where I left it? 
      • Why is this an Invalid Collection String Error?

        Here's the code snippet: Enddate = EventEnd.toDate("yyyy-MM-dd"); EventCollection = Collection(); EventCollection = zoho.crm.searchRecords("Events", "(End_DateTime:starts_with:"+Enddate+")"); for each eventday in EventCollection { //create a list of events
      • Firebase Functions integration

        Hello Zoho Team, Please advise how I can configure SMTP in my account to facilitate Firebase-triggered email functions. Please note that I desire to send an email with a JSON object collected from Firebase Firestore and included in my mail to forward
      • How to provide recommended KB articles in the welcome message

        I'm new to Zoho and am looking to replicate something I did for a previous employer. I want all newly created tickets to receive an automated welcome message that includes a few recommended articles from our knowledge base. Ideally there would be a way
      • Join us at the Canada ZUG Meetup: What’s New in Zoho CRM

        Hello Zoho Community! Start your year with fresh insights into Zoho CRM’s latest updates and tools. Whether you're a CRM beginner or a experienced user, this meetup is crafted to help you optimise your processes and leverage new features. Explore practical
      • So many tools...

        As a low- to no-code user and no funds to budget, there are so many options to choose to get my work done and when I start thinking about workflows for people other than myself, I get confused about the most streamlined way to move forward if I can get
      • Zoho Creator to Zoho Books

        Hi, I use Zoho Creator and Zoho Books. I use Creator to produce and send invoices (for specific reasons) but want to create a corresponding invoice in Books. Has anyone done this and if so, how? I have the following documentation but can't make sense
      • Subform Zoho Form to Creator

        Hi, I would like to be able to retrieve the values of a Zoho Form subform to create an entry for each in Zoho Creator. To send from Form to Creator, I use Zoho Flow. I have a custom function, which should normally retrieve each field value then create
      • Doesn't Catch Duplicate Accounts

        Zoho is very bad at catching duplicate accounts. If we have an account in Zoho, and we import the same account but with "Inc." or "LLC", it doesn't catch it, it just duplicates it. When importing from another app (like ZoomInfo) I set it to catch duplicates
      • Building a dynamic scheduling assistant with Zobot!

        We received requirement for a bot that can dynamically generate date-time slots which do not overlap existing event timings in Google Calendar ie., if a slot is booked then it will fade away from the time-slot widget. Bot Requirements:     A bot that can:   Construct dynamic non overlapping date-time slots   Exclude a specific date or week days while generating the slots  What does this Zobot do ?   When a visitor lands on the site, the bot displays a welcome message and asks for the visitor's name
      • Créer un second centre d'aide dans Desk

        Bonjour, je souhaiterai pouvoir créer un second centre d'aide dans Desk afin d'avoir un service complètement indépendant du premier. Le premier fonctionne bien, il est pour notre service client. Mais j'aimerai maintenant pouvoir créer un nouveau service
      • Email Campaigns overview page is missing SENT DATE and # people sent to!

        I would like to see the date the email campaign was sent, so I can understand and track when each email campaign was sent. Right now, unless you go to a contact who received a campaign, you cannot see when the campaign was sent (!!!!!!). So, if my boss
      • Create an event from mail

        From mail I can create a task but I cannot create an event.  What am I missing?
      • How to customize Check Out form, process & design

        Hi Just set up my first shop and changed the design quite a bit. Like it so far! However, did not manage to change either Design, nor Content, nor Process of the Check Out. Where can I change this? E.g. - change the font of the check out forms - change
      • Issue with bulk importing into commerce (updating existing products)

        Hello All, I'm struggling to bulk update my existing products within my shop. I have exported all the products and appended the image url (copied from another product within the file) and then important back into commerce. The file is accepted but flags
      • Coupons are not being accepted. (Saying expired)

        I am putting together a coupon for our company's store. When I went to test it, I received a notification that the coupon is expired. (the date range should be fine though) I've tested different options for the coupon along with one of my other colleagues
      • Issues with Agent Forwarding Card in Zobot

        I implemented an Agent Forwarding Card in a Zobot that I created. There are a few issues with the way the card functions in an actual chat. The way it is designed right now is not easy to use and is not intuitive. Here are a few of the issues I have with
      • Drop Shipping

        We have manufacturers drop ship all of the items in our ecommerce store. that means that each item needs to have its own unique zip code to acquire real time shipping rates from that zip code. and then the manufacturer of that item gets an automatic email
      • apple pay

        if a customer is accessing via an iphone etc and we are taking payments via stripe would they be able to use apple pay?
      • is Zoho eCommerce dead?

        Hello, we have Zoho eCommerce in our Zoho One Suite. After a year's break, we took a look at Zoho eCommerce this week. Very little has been developed. The normal eCommerce 2023 standard features are missing. Ok, Zoho eCommerce cannot be compared with
      • Issue with Cart API Implementation - Products Not Being Added to Cart

        I am writing to report an issue I'm experiencing with the Cart API implementation. I have tried multiple approaches to add products to a customer's cart programmatically, but I'm encountering difficulties. API Request Approach I am making a POST request
      • wishlist

        I need to know where to find the wishlist function in Zoho Commerce
      • 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
      • Next Page