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

      • How i can move the records from blueprint A (inactive) to new blueprint B (Active)

        Hi team I have a question, I just generated a clone blueprint (A) which I left active, and the original blueprint (B) deactivated it, well, I need to move the records from (A) to (B), is there any way to do it? Regards, Pablo
      • IndiaMART Integration for Zoho CRM

        If you need to get IndiaMart leads in Zoho CRM without using Extension then this solution is for you. See step by step guide to integrate IndiaMart API quickly. Create Leads in Zoho CRM - IM ENQUIRY TIME, IM PRODUCT, IM QUERY ID, IM QUERY MCAT NAME, IM
      • Tip #17: How to mandate partial payment for your appointments

        When you require partial payments during the booking process, customers can only schedule with you after paying a certain amount in advance. This deposit acts as a commitment between both parties. Apart from that, it has many more advantages. Benefits
      • Shout out Canvas!

        If anyone has not used Canvas designs, please watch this video. The canvas team have been really amazing to help us get to this result. This makes training teams so much easier! I'd much rather build a canvas design than write user guide documentation.
      • URL for job opening

        I would like to ask you to add this feature to the product: create an unique url for each job opening on Zoho Recruit, so that I can add a link to it when I post the opportunity in a mailing list or on a forum.
      • "Pinning" a Note

        It would be really helpful to have a way to "Pin" a note to the top of the notes section. This is really important when you have something important about someone and do not want the note to get buried farther and farther down the note stream. For instance:
      • Content Optimization

        Write engaging, high-quality content with a focus on user intent. Maintain a good keyword density (~1-2%). Use structured data (Schema Markup) to enhance search visibility (e.g., FAQs, reviews, events).
      • Email Alerts for Schedule Failures in Zoho CRM

        Hi, I hope this message finds you well. Currently, when a schedule fails, there is no automated way to notify us via email about the failure. This makes it difficult to promptly address the issue as it requires manual monitoring to identify and resolve
      • Enhanced Apply with SEEK: Now with JobStreet & JobsDB

        We're thrilled to introduce an enhanced Apply with SEEK feature, now supporting JobStreet and JobsDB integration. This update extends its reach across APAC countries, offering a seamless application process for candidates and greater hiring efficiency
      • Caso de Uso | Cómo Surus - Escrapalia aceleró sus operaciones con Zoho CRM Plus

        "Me quedo con Zoho seguro. Es una herramienta súper potente que comunica todos los CRM. Toda la información sale de un mismo núcleo" - María José Muñoz, Responsable de Recursos Humanos en Surus - Escrapalia. ¡Hola, Español Zoho Community! ¿Alguna vez
      • Email Numero de telefone

        Bom dia a todos. Como eu altero o numero de telefone da minha conta? Estou tentando logar minhas contas e depois do envio da OTP por email é enviado uma OTP para meu numero antigo de telefone. Atualizei meu numero e gostaria de remover o antigo e adicionar
      • Introducing Form Rules

        You can now customize your Webforms and the Candidate Application Form using the all-new Form Rules. This lets you add flexibility and control by enabling conditions and actions based on candidates' input. Why use Form Rules? Form Rules empower you to
      • Help with order importing, manual order creation, and how lookups work and Zapier integration to retrieve orders via webhooks

        Hi I've been trying to import orders from my ecommerce package. I have set up a CSV file with some sample orders and have been trying to match the fields. I created new fields - see images (also a copy of the CSV). But I am getting orders skipped because
      • Test emails are not sent

        Good evening, I've been trying to send test emails to test my campaign to a few emails. Every time, I got the message that the test campaign was sent successfully but no email is received at all. It's not even in the spam folder. I tried to change the
      • CRM workflow to trigger Zoho Sign (One)

        Hi,  We have had integration in the past with SignNow in our standard CRM. A onboard would fill out name and address and in turn this would trigger a webhook out of Zoho CRM into Zapier and to SignNow. We've recently upgraded to Zoho One and cannot find anyway to automate the Sign process from CRM to Zoho Sign, is this possible?
      • Anyone Using Gusto Payroll w/Zoho Books? What do you think?

        Its very clear from doing research that Gusto is far superior to any other payroll provider. Thinking of switching over them them. Before doing so: Anyone using Gusto and Zoho books now? If so, what do you think? Do they work well together, not work well,
      • Syncing payroll from Gusto to Zoho Books

        We use Gusto for Payroll and will not be changing that. We are new to Zoho Books. We checked before moving to Zoho and saw an integration with Gusto https://gusto.com/product/integrations/zoho-books. We assumed this would sync payroll data from Gusto
      • Zoho Books Price list associated to a cusomer

        how we can associate a price list to a costumer? pls don't send me to your FAQ section (Associating Price List to a Customer:: Knowledge Base | Zoho Inventory) nothing it's explained and there no place where we add price list to a customer
      • Attach image from Creator Subform to Deal

        Can anyone help me figure out how to attach an image from a creator subform to a Deal? I have read through all of the documentation and can't find anything for my specific scenario. Everything I have found is attached from the Creator form (not subform)
      • Getting duplicate messages saved to 'Sent' folder

        When I send a message from Android phone (K-9) imap client or when I send a message from Windows using Thunderbird, two identical copies of my outbound message are saved to Sent folder. When I send a message from zoho web mail page, I believe there is no duplicate of my outbound messages. Have I misconfigured something?  What do I need to do to fix it? thanks! Linda
      • Setting recurring tasks and reminders in tasks module are enhanced in Zoho CRM

        Hello everyone, In this post we will brief you on the enhancement in creating a recurring task and setting up reminders. Let's take a look at the what has been changed. Recurring tasks can be set using Due Date Earlier, to create a recurring task you specified the Start Date, End Date, and the appropriate Repeat Type. Now, the start date field is removed and instead you have to specify the Due Date. The task will be repeated based on the mentioned due date.   Custom repeat types can be configured
      • Populating Lead ID in Deal Record

        I’m trying to create a unique identifier to match deal and lead reports, and my plan was to use the Lead ID as the key. However, I’m having trouble figuring out how to get the Lead ID from the lead record into the deal record during the lead conversion
      • Home Page Layout Suddenly Changed; How to Remove Open Activities

        Hi, When I logged in yesterday, I noticed the Home Page layout was completely different. I'm using the Classic View. Suddenly there is a massive section of Open Activities that takes up the whole top half of my screen with My Tasks below it: Open Activities
      • Unlocking New Horizons: A Year in Review

        As we bid farewell to 2024, let's celebrate and revisit the key highlights of the year. From adding a new edition to cross-platform enhancements, here’s a roundup of all the feature updates designed to simplify accounting, optimize financial management,
      • Zoho Books | Product Updates | October 2024

        Hello users, We're back with fresh feature updates in Zoho Books. Starting from associating an applicable period for TDS taxes to minimised tab view for web tabs, discover the latest enhancements that will streamline your workflow and elevate your accounting
      • How can i get and update Multi-Select Lookup field through API?

        Hi! How can i get and update Multi-Select Lookup field through API from/in  Custom Module?
      • End of Support announcement for macOS 10.9, 10.10, 10.11, 10.12, 10.13, and 10.14

        Dear Customers, We would like to inform you of an important update regarding our support for legacy macOS operating systems with Zoho Assist. Starting May 1, 2025, we will officially end support for macOS versions 10.9, 10.10, 10.11, 10.12, 10.13, and
      • How can we find an expert in Zoho Loyalty Program Thrive?

        Hello everyone, We are looking for a Zoho expert to help us set up Zoho Loyalty Program Thrive for our e-commerce store, aiming to increase customer loyalty and encourage repeat purchases. We need someone with experience in: 🔹 Setting up and customizing
      • Tip of the week # 40 - Customize your sidebar for easier, more efficient inbox management.

        Is a cluttered sidebar slowing down your work and making it harder to focus on what’s important? Zoho TeamInbox allows you to customize your sidebar to fit your needs, making it easier to manage your shared inbox. You can temporarily hide thread views
      • INVALID_DATA Error While Setting Date Field in Client Script of Details Page

        I am trying to detect the Stage change on Details(Standard) page (with the stepper section), then update Stage_Updated_At (Date) field with today's date. Thanks to @Ishwarya SG 's direction, I found this topic and I managed the first part
      • Writer Merge and Sign OAUTH API Call error.

        Trying to send a request to the Merge and Sign API. I keep getting "Merge data not found. Please try again with proper merge data." Request is sent via JS axios call. We use the same exact data inside a CRM function and everything works. Followed the
      • Cases module mail merge

        Hi Guys  Is it possible to use fields from the cases module within the word mail merge ?  I dont see this option in the word mail merge application. Thanks  Chris 
      • Limiting Knowledgebase Access To Logged In Users

        Hello, how can I restrict access to our Knowledgebase to only logged-in users? Our KB is not meant to be accessible to anyone. However, anyone can create a ticket. Thanks! Frank
      • Time field is empty text in pivot chart report

        Hello all, I am currently trying to create a pivot chart, where the y-axis is supposed to be a total sum of time. The problem Im facing however is actually using the field, where my metric is stored. It shows up as a simple time field in the form builder.
      • Creating Packages

        Hi I am trying to create a database for my company. I need to create packages from individual products. I have added products ie item 1, item 2 and item 3 I need to create a package where Package A will have items 1 and 3 Lookup only adds one product
      • DELETE EU VAT ID FORM MY ACTUAL INVOICE ADDRESS FROM MY ACCOUNT

        WE NEED TO DELETE (NOT CHANGE) THE EU VAT ID FROM OUR INVOICE ADDRESS. WHEN WE TRY TO LEFT IT BLANNK, AGAIN SAVE THE OLD EU VAT ID. YOU ARE SENDING US FALSE INVOICES WITH FALSE DATA
      • Zohoo Flow - Cisco Webex

        Hello, Is there any integration planned between Zoho Flow and Cisco Webex. We have a lot of customers using Webex for Chat and Meeting/Calling. It would help a lot to be able to integrate it with flow. Thanks
      • How do I enforce MFA for all agents in Zoho Desk

        We use Zoho Desk. Enabling MFA is an option at the individual user level - so they can enable/choose MFA for themselves or not. We need to enforce MFA - so there is no option. How is this done?
      • Can't connect Instagram to Facebook to work in Zoho

        I'm pulling my hair out here. I know this is not a problem with Zoho, really. But since Facebook provides absolutely NO support for their own products, I was hoping someone here can provide some insight or help. I cannot for the life of me get my Instagram business page to connect to my Facebook page. I have authenticated fine, but after that, trying to connect the page to the Instagram profile never works.  I've spent hours upon hours researching and going through the steps over and over, but something
      • Twilio with Zoho CRM

        Hi! We want to integrate Twilio with Zoho CRM and Bookings. On Zoho Market Place, the only integration with Twilio that allows calls, is one made Ulgebra. Is there any other integration? Either native from Zoho or Twilio? If not, as anyone tried the one
      • Next Page