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 to send mail with js SDK

        Hell o I'm using https://live.zwidgets.com/js-sdk/1.2/ZohoEmbededAppSDK.min.js, for my widget in CRM (built with sigma) Is it possible to send email from js file, I try ti use that ZOHO.CRM.API.sendMail({ "Entity": "Accounts", "RecordID": sharedVariableEntityId,
      • Report to see committed stock vs quantities on order with suppliers

        Hello Zoho Community, I am looking for a report in Zoho Books / Inventory that will show the committed stock from sales orders, and show what quantities of the same part are on order from purchase orders. I have found the committed stock details report,
      • Zoho Projects Currency fields in Deluge script

        I have several functions I've written in Zoho Projects that take one or more currency fields as input parameters (arguments). These functions have been working just fine for months, and I made no changes to any of them. Today (Jan 21, 2025) I noticed
      • Kaizen #174 : Client Script Commands

        Hello everyone! Client Script Commands feature is a highly anticipated functionality that enables users to trigger Client Scripts anywhere within Zoho CRM, extending the scope of client script beyond standard pages and events. In this Kaizen post, we'll
      • Zoho CRM - Zoho Creator - NFC Tag

        Hi, I'm looking for support for Zoho Creator and NFC. I have read the existing knowledge base, however not all is clear. We have Zoho CRM with custom module 'Equipment' where we have around 1000 records. Our idea is to attach physical NFC tags to the
      • Transformez vos interactions événementielles avec l’intégration WhatsApp dans Zoho Backstage

        Un des plus grands défis de l'organisation d'événements est de garder les participants informés et engagés tout au long de l'événement. L'intégration de WhatsApp dans Zoho Backstage permet aux organisateurs de communiquer directement avec les participants,
      • Getting the Record Id to appeal in the Deals Module

        Hi, I am looking to get the record ID to appear on a deal record. I need to get recrod ID to appear on a document so when they are returned they can be match up with the record we hold in a seperate case management system. The record ID is uploaded to
      • Sandbox for consultants who are helping me develop a report

        Hi. I occasionally need to hire someone who has a Zoho skill I don't have and I need to give them access to my account so they can work. It makes me a bit nervous, but I need them to get a work product done. I set their access as "User" and it turns out
      • I there any way to use a digital pen with a digital desk like Wacom to take notes in Zoho Notebook?

        Hey, guys. I wonder if there's any way to handwrite something and it pull down on Zoho's notebook as a readible image or something like that. Imagine the situation: I don't want to write with a keyboard, but with the digital desk, and I want to the text
      • What's New in Zoho Analytics - December 2024

        Hello Users! We’re excited to bring you a roundup of the latest features and improvements in Zoho Analytics. These updates are designed to elevate your data analytics experience, making it more powerful, interactive, and seamless. Let’s dive in! Expanded
      • Task templates under a project

        Under a project, we might have numerous task lists and these might be for all sorts of things so typically, if a task is created under a task list, it should contain the fields relevant for that particular purpose. However, if I create a task template,
      • Transfer contact to a lead.

        Is there a way to transfer a contact from CRM to a lead without having to re enter everything. Moderation Update: I'm locking this post as we have provided a possible workaround to achieve this case: transferring contacts back to leads. continfo = zoho.crm.getRecordById("Contacts",
      • Increasing column width in Zoho CRM search result

        My company names are long, and when I search them in the Zoho CRM search, I'm not able to view the entire full name which makes it hard to select the correct item quickly. I tried reducing the amount of columns to just 1, but still the company name column
      • Recording inventory purchase as an expense

        Hi, Currently Zoho only allows you to enter inventory purchase as a bill and make a payment for that bill. This is a two-step process which can end up taking quite a long time to record entries. As opposed to this, QuickBooks has a feature that allows
      • Zoho Survey | Get Signature as Image/PDF

        Hi All, Is there a way to get the signature as image/pdf, we currently have the Zoho Survey connect to Zapier as webhook, but the signature question field doesn't return an image/pdf value. Is there a workaround for this?
      • Automation steps defined by embedded quiz or survey answers.

        I'd like to define a user's automation workflow based on how they interact with an embedded ZOHO quiz or survey in the first email. While I can easily define steps based on users clicking a link in an email I feel like I'm missing something more robust
      • Formula to calculate working days

        How can this formula that calculates working days from ANYDATEFIELD to TODAY() be adjusted to Zoho CRM formula functions? CASE(MOD( ANYDATEFIELD - DATE(1985,6,24),7), 0 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,4,5,4,6,4,0), 1 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,3,4,3,5,3,6,4,0), 2 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,2,3,2,4,2,5,3,6,4,0), 3 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,1,2,1,3,1,4,2,5,3,6,4,0), 4 , CASE( MOD( TODAY() - ANYDATEFIELD ,7),1,0,2,0,3,1,4,2,5,3,6,4,0),
      • Zoho Desk : Field for 'Layout'

        I have many different layouts on my helpdesks and I want to be able to identify the stats for each one, however I can not find the field in the raw data from the Zoho Desk datasource. I thought it might be in the "Tickets" table but there is nothing.
      • Possible for "Specify URL Criteria" in URL/Permalink settings to be assigned to a variable?

        I want to embed a Zoho Analytics chart view as a Related List item in the Zoho CRM Accounts module, such that when one is viewing a CRM Accounts module record for an Account, the user will see the chart for that specific company. Is it possible to set
      • proceed with ssl certificate to use my domain

        hi there i have completed the steps of creating and editing CNAME i want to use my domain.
      • Report inaccuracies

        I just generated an Expense by Category report in Zoho Books, expecting to get the expenses as reported in the Profit & Loss statement. No so! Specific expense categories that I had added in the chart of accounts were not included in the report, and some Cost of Goods Sold categories that should not have appeared were included. The Profit & Loss statement appears to be correctly reflecting all expenses, and the Expense by Category report is not. it is all over the place! From what I can tell, the
      • Assistance with Survey Consent and Anonymization

        Hello, I am conducting a survey that requires both the minor’s consent and their parent’s consent prior to participation. As part of the consent process, I am required to collect the names of both the participant and their parent. I want to ensure that
      • Execution failure when fetching a Name field from another app

        In creator I have one app [Employee Directory] with a form [Employees]. One of the fields is a name field called [Name]. Here is a sample that works, if executed from the Employees app: test_Employee = Employees[Name.first_name == "Alex"]; info test_Employee.Name;
      • Countries and Towns - Lookup Multi Select

        Hi, Sorry I'm new with Zoho Creator and Deluge. ---------------------------- Form A = Countries Form B = Countries and Towns (with relation) in a Form C, i have a lookup field "Country" and after user input, i would like to auto populate the lookup multi
      • Software Integration

        Good day, I trust this message finds you well. I would like to find out how I can integrate Zoho Expense, Zoho inventory, email and collaboration, Human Resources and marketing onto our current plan with Zoho Books.
      • Zoho Survey - Respondent User Portal - RealTime & Response Access

        Hello everyone, I have two questions which I would appreciate your guidence on. 1. I have written to Zoho and they tell me no REAL TIME API access is available against completed surveys. From what I gather the only way to get these in real time is to
      • Search bar in portals

        Is there a way to add a search bar in portals for finding Contacts or Deals in the list?
      • Approval Processes Issue

        Hello, I have a significant issue that could potentially cause serious problems for our company. We have developed a new module that we use as a payment request module. In short, payment requests are made through this module and are approved by different
      • Associate Potential with Purchase Order

        Dear Zoho Team I'm looking at associating a Potential with the various Purchase Orders that are issued to Vendors for that specific Potential.  This would be of tremendous use at a later stage.  Is this possible? I have tried looking at mapping dependency fields, but couldn't find a solution.  Please advise.
      • PRICE INCLUSIVE OR EXCLUSIVE IN ITEM MASTER CHECK BOX

        please provide checkbox or tick box to specify price mentioned in item master is inclusive or exclusive of taxes for better information. The feature is available in odoo and its very helpful.
      • Zoho Books - Organize view in sections

        Hello, Is it possible to organize the basic or custom fields in Zoho Books (estimates, invoices...) views ? Did not find a way to do it. With many fields you obtain a long list of unstructured/unorganized fields. If it is not possible, is it planned please
      • Zoho Books - Cloud file picker storage solution order

        Hello, Is it possible to determine the order of the 3rd party storage solutions in the cloud file picker. We use Workdrive and the first one is Zoho Docs. It forces us to click every time on the Workdrive icon to reach the files. We'd like to position
      • Zoho Applications - What's New Alerts

        Hello, Sorry if I haven't checked enough, but is there a way to have email alerts on the "What's new" pages of each application please ? Correct me if I'm wrong, but today you have to go every day on each what's new page to know what has changed. By the
      • ASAP widget broken?

        Hello, i've only just recently signed up and finding the whole set up a bit of a minefield. I've created and embedded the ASAP widget onto my website and a couple of things seem to be broken. 1. The launcher icon is missing 2. The form to submit tickets
      • Tickets associated with my service contract are not subtracted from the pool of hours configured in contracts in Zoho Desk

        Hello community, I hope you can help me with this query. I have set up contracts in Zoho Desk, and it is associated with a client that has a quota of 30 requests per month. In my client I have 4 email accounts associated that can make requests and these
      • I am unable to view a client's related information within their account, a lock appears in Zoho Desk

        Hello community, I have a problem that I can't solve, I have a client with a related contract and I can't see their associated tickets, it tells me that I don't have permissions, I've already checked the permissions everywhere, but I can't fix the problem.
      • How to Map SalesIQ Visit Data to a Custom Module (Job Seekers) in Zoho CRM?

        My Company’s Current Workflow For my company, when a SalesIQ session is completed: SalesIQ searches the Contacts and the Leads modules for a matching record (based on the visitor’s email or other identifiers). If a match is found: The Visit Summary is
      • Issues hosting Zoho Desk Web Form on SharePoint and/or Power BI

        Zoho Desk onboarding support has no experience with embedding their web form in either SharePoint or Power BI. Microsoft states that SharePoint and Power BI only support iframe HTML. And unfortunately, the web form embed code that Zoho generates is not
      • Send email to customer in blueprint and show it in thread

        Hi there, We have a blueprint that sends an email to the ticket contact whenever the ticket changes status. On every transition, "after" the transition an email alert is sent to the customer. The problem is, that the email is not shown in the ticket thread,
      • How do I add page breaks to Sales Order templates?

        I would like our Terms and Conditions to start on a new page of the resulting PDF. How do I do this? I tried adding <div style="break-after:page"></div>, but this did not work.
      • Next Page