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

      • Zoho Recruit in 2025

        Hi Zoho team, Is it possible to disclose what is on the roadmap for Recruit in 2025? In comparsion to other ATS options available, Recruit is falling behind. Within the community there are endless request and suggestions from users on feature which would
      • Leave Balance

        Hi, I am new to Zoho People and currently trying to set up annual leave for all our staff. I configured the leave policy but when a request is made and approved, the leave balance doesn't reduce. Any ideas as to why this may be? Cameron
      • Pivot Chart - Zoho Creator

        In Zoho Creator, I want to enable an edit option within the Pivot Chart itself. Additionally, I want to avoid showing duplicated values for certain columns. For example, I’ve created a month-wise sales report for each product type. The form contains fields
      • Multiple workflows based on stage?

        I am trying to have multiple things happen when I close a deal. First, I would like to send a thank you/coupon email to all deals that are closed. Second, I would like to create connected records in a separate pipeline for certain projects that qualify.
      • Zoho Verification code not received

        I am a new customer trying to set up Zoho mail. I'm stuck at the phone verification stage. I have entered my mobile number but the verification code is not being delivered to my mobile. I can also confirm that I'm receiving text messages from others telephone numbers as normal. Kindly assist me as I have been at this since yesterday. 
      • Adding external users to Zoho lean course

        Hi I'm looking to send a course link to an extrenle user that is not part of the users I'm paying for zoho one,is that possible to get done? Cheers
      • Client Portal is now available in Zoho Books

        Hello Zoho Books users, We are excited to let you know the Client Portal feature available in the new version of Zoho Books.  Now, you can have your customers access a link to view their estimates and accept/decline it, view invoices and make payments to it.  You can get notifications of the activities in the portal.  Click here to know more. How can I enable the portal? 1. Switch to new interface.   2. Enable client portal for your organization under Organization Profile. 3. Set-up your portal name
      • Sharing an entire Zoho Learn space externally

        Dear Zoho Community, I am enquiring about the possibility of externally sharing an entire space via a weblink. Our objective is to utilise one of our spaces as a client-facing knowledge repository. We would like to offer clients access to this space through
      • Accounting on the Go Series-40: Simplify Payments with M-PESA Gateway Integration in Zoho Books Mobile App in Kenya Edition

        Hello everyone! As you all know, Zoho Books lets you handle your payment processes by receiving online payments for your invoices. Today, we're excited to introduce a feature that will help Kenyan business owners streamline their payment processes: M-PESA
      • how do I manage Petty Cash

        Hi I have a problem ?  1. Question ; I am the owner of the company, I withdraw money from bank for my own use and latter-on if required I pay some bills in cash. how do i mange this transaction in zoho books. 2. Question Some time I withdraw cash from bank  for my own use. But If there short of fund in the bank I deposit the cash back in bank. How do I manage this transaction in zoho  
      • Issues with completing calls using ZohoCRM and RingCentral

        My company has been a multi year customer. We have always used RingCentral for making our sales calls. In a normal call, we are presented a green button next to the phone number of either a company or contact we want to call. Lately, after a few calls,
      • Rounding off rate in quote

        Hi team, Please help me to rounding of rate amount in quote
      • GST composition scheme dealer - treatment for client expenses reimbursement

        Hello, I am new to GST and need your help. I am registered as a composition dealer and attract 6% gst charges. In bill of supply, there are also expenses done on behalf of client for which I seek reimbursement AT ACTUAL with NO MARKUP. As I understand,
      • zoho book API - Price list (create / update /delete) - Is there any documentation?

        Hi there, Is there any documentation on how to create a price list on zoho book via API? There's nothing on the API guide. Thanks in advance Claire
      • how to get Access Token & refersh Token

        https://accounts.zoho.com/oauth/v2/token?code=&client_id=1000.DP4CU4M4AT0BJBX7KT5YUMIO1PNQTE&client_secret=ca66e715e9c387711166997b44fc45924b960385fa&redirect_uri=myurl&grant_type=authorization_code this error: {"error":"invalid_client}
      • zoho feedback

        I hope you are doing well. I wanted to take a moment to express my appreciation for the Zoho ecosystem and how it has positively impacted my business. Since I started using Zoho Books in 2019, I have found it incredibly efficient in managing my operations.
      • Remove Special Characters "\" using Zoho Deluge

        Who needs this? I don't know! I did, and I sure did not find any helpful information out there, not with this keyword though. So, if you find this article because you searched the same thing as I do, then hey, you're in luck! And do note that I am not
      • CardDAV Editing Support

        I added my contacts to my Mac via CardDAV (because of lack of Exchange support). I can see my contacts show up right away in the Contacts app. I cannot edit any of the contacts details. When I click edit on the contact, it goes into edit mode, but any of the phone numbers or email addresses that are on the Contact in Zoho are just plain text and not an editable field. Anything I add does not sync back to Zoho. Is Zoho CardDAV view only?
      • Automatically add a retainer to every estimate

        Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,
      • New in WorkDrive: WorkDrive Genie, a quick-editing app for desktop (Beta)

        The WorkDrive Genie app lets you open and edit any of your WorkDrive files on the web with your default desktop applications. For example, you can open and edit files such as documents, images, and videos with Microsoft Word, CorelDRAW, and Adobe Premiere
      • Company Letter Head in Mail

        how to create a company letter head template in zoho mail?
      • Suddenly Can't Send Outgoing Mail (SMTP)

        Suddenly I can't send mail anymore from my phone mail app. I have Zoho OneAuth MFA set up and an app specific password set up. It has been working correctly for a while. Has something changed with your servers or setup for SMTP? No settings have changed
      • discount on total amount

        i want to add discount on total value of my purchase order instead of applying line by line.my customer will not accept the discount on line by line.
      • payment voucher, receipt printing feature

        Why dont ZOHO add the voucher printing feature in zoho book with authorised signatory and receiver's signature
      • Inventory asset or cost of goods sold ?

        We can only choose inventory asset for items but lots of bills for items are posted with cost of goods sold - is this all balanced correctly or should it be entered differently ?
      • Stock reservation in zoho for upcoming delivery

        Hi, Is there any option available in zoho for reserve item for a upcoming delivery. So that we can avoid the item should duplicated on another order. Means needs to deduct the item from zoho before making invoice.
      • How to search records in integration task in creator?

        How to search using integration task in creator searchString = {"zcrm_account_id:4050082000001001499"}; contactData = zoho.books.getRecords("Contacts","xxxxxx",searchString); I get an error that third argument needs to be string, I tried to convert it
      • Facebook Professional Account

        Zoho social says there is nothing to be added when I try to add my Facebook and Instagram accounts. Both are Professional profiles. How do I go about adding them? They are not Pages or Groups, they are simply Professional accounts.
      • Zoho Forms Submission URL

        Hi Zoho, It would be great to have a URL which can take us to specific form entries. For example: https://forms.zoho.eu/ACCOUNTNAME/report/FORMNAME/records/UNIQUE-REF I currently have a use case where I want to use Zoho Flow to create a module entry in
      • Building a form with Categories and multiple sub-categories

        Hello, I am completely new to Zoho and the Deluge programming language. I would like to build an easy way to lookup a set of previous orders from my order tracking sheet. What I have done so far is import my Excel order list into Zoho so it shows all
      • Zoho IP blocked by SpamCop 136.143.188.16

        Hello, I am unble to send any single email during the whole time due to the Zoho IP 136.143.188.16 being blolced by SpamCop.net Please help on this. RROR CODE :550 - spamcop.mimecast.org Blocked - see https://www.spamcop.net/bl.shtml?136.143.188.16. -
      • Can't sign in to Zoho using Google account

        Just checking if anyone else has an issue signing into Zoho with a Google account at the moment? (Have tried Zoho Books in the app on mobile and Chrome and Firefox on Windows 10 - doesn't work for the forums either). Error message appears as attache
      • unable to send message email outgoing blocked 554.5.1.8

        Hi good day to you, After migrating to a new hosting, I cannot send outgoing email, with an error message as below : unable to send message email outgoing blocked 554.5.1.8 Please kindly unblock my account, as I am in a rush to use it to work & communicate
      • Zoho CRM - COQL query failing with no reason

        Hi I'm trying to execute a COQL query but it's returning an error. Unfortunately I cannot understand where I'm wrong The query is the following;: URL: POST https://www.zohoapis.com/crm/v2.1/coql Body: { "select_query": "select id,Adjustment,Billing_City,Billing_Code,Billing_State,Billing_Street,Buyer_PO_Number,Delivery_Date,Delivery_Method,Due_Date,Grand_Total,Invoice_
      • SMTP Authentication error with django backend

        Hello I have e zoho mail id info@mindbrewers.in But when i use it for smtp it gives 535 authentication error in django website . EMAIL_USE_SSL = False EMAIL_USE_TLS = True EMAIL_HOST = "smtp.zoho.com" EMAIL_PORT = 587 EMAIL_HOST_USER = "info@mindbrewers.in"
      • No recibo correo en en mi bandeja de entrada

        Hola, no puedo recibir correos en mi bandeja, tengo una pagina web y puse el correo en un formulario y cuando meto los datos y los envio no me llegan , pero si pongo otra ya sea gmail, outlook si los recibo, tiene que ver con mis dns?
      • Zoho SMTP IP Addresses

        We are using Zoho Mail for a domain and need to whitelist some STMP IP from your service for a redirection. You can provide IP address list for Zohomail SMTP servers?
      • Emails being duplicated in sent items folder

        Since this morning, emails I send are appearing in my sent items twice (it wasn't happening before this morning) This appears to be a bug with zoho mail ... I can't see any other reason why they would appear twice.
      • Restrict SalesIQ Account Notifications to Admins

        Dear Zoho SalesIQ Team, We appreciate the continuous improvements in SalesIQ. However, we have noticed that all users, including employees who do not have admin privileges, receive certain account-related notifications—such as the recent splash screen
      • Email client fails to connect to IMAP & POP EU Servers for ALL users

        For the last couple of days, all users on my account are failing to connect to the Zoho EU mails servers. This is using mobile app on various phones & desktop mail clients on different computers. Everything works fine when using webmail & email is still
      • Next Page