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

      • Include SalesIQ activity when sending Forms data to CRM as a new Lead

        Is there a way that when I get a new lead via a zoho form on my website to include the activity in CRM? I have Sales IQ integrated with the form however, most of my leads do not talk to us through the chat fuction but they do fill out a zoho form. Id
      • Subject Line Editing

        Good morning How can we change the subject line of an email?
      • Zoho Desk, call integration

        Hello All, I searched a lot but i can't find any answer. I would like to recieve phone call if I recieve a critical case or lets say a case. whatsapp call also ok. Can we do that?
      • Is there any transcription services that comes with ZOho Meeting or Webinar

        Thanks
      • Jira integration - view the attachments in ticket

        Hi, When i create a ticket in Desk with an attachment and after that i create a Jira Bug (via the Jira-Zoho integration) then my developers can not see the attachment. How to solve this? Regards Herman
      • Zoho Writer: Zoho CRM Variable issue

        Hi, I encountered an issue when using the Zoho CRM Global Variable in Zoho Writer while triggering a merge from a custom function in a button. In the document template, I'm calling the Zoho CRM Global Variable, but its value isn't being displayed at all.
      • Sharing sheet without affecting original spreadsheet

        I want to share a sheet using a password unique to the end user who will be able to enter data that will help them make a decision. I don't want or need any changes to show up to original file inside my Zoho account. I will be sharing this sheet over
      • How to give Supervisor access to all chats? Transfer and invite other operators?

        Any chat system had levels, The supervisor can control the associate chats! but here is different! I can not find how to give the supervisor accsess to this.
      • Europäische Zeichen: Komma "," anstatt Punkt "." möglich?

        In alle Betragsfelder müssen wir mit dem Punkt "." die Beträge erfassen wie 123.34 EUR. Das müssen wir nur in Zoho so machen, weil in anderen Applikationen wird in "Europa" mit dem Komma 123,34 EUR gearbeitet. Das Datumsformat kann kann in Books eingestellt
      • While importing journals in .xls file; Error notification "Duplicate entry in the Journal Date column. Ensure it contains unique values."

        Dear Community, please help with suggestions to resolve error notification "Duplicate entry in the Journal Date column. Ensure it contains unique values." Some transactions spooled from Bank Statement into the jounal.xls have the same value dates.
      • Bank feeds broken again.

        Not for the first time my bank feeds are broken, they appear to be connected but no transactions are coming through since 31st Jan. I have contacted support and await a reply. Anyone else have the same issue? I feel the route cause needs addressing.
      • Item sales account via api

        Hey everyone, I’m making an invoice using the create invoice endpoint on the api. Is it possible to set a sales account in the line_items attributes?
      • bank reconciliation screens no longer indicate what transactions you have matched to the bank statement

        I'm trying to reconcile a november bank statement. I used too be able to mark the transacions as I matched them (manually) Now it just tells me the number of matched but no indicator of which ones. Can some one please help? thank you
      • Possible to configure such that users can only delete their own records?

        I want to configure the system such that non-Admin users can only delete their own records. Is it possible to do this? I have been fiddling around with Profile settings and Data Sharing settings but the results seem to be inconsistent. I had: enabled
      • Kaizen #175 - Leverage Settings Widget for Zoho CRM Extensions

        Howdy, innovators! Welcome back to a fresh week of Kaizen. This week, we will delve into configuring a Settings widget in Zoho CRM for the effective functioning of extensions. It centralizes around key configurations that will be carried out to various
      • Records that are in the trash are counted in the reports.

        Hello community, after intensive investigation by support, we have noticed that when we relate records through a lookup field, if we delete records from the child module they will be counted when generating a report from both modules. See the case below:
      • Unable to Duplicate Zoho Application

        Dear Zoho Support Team, We are facing an issue while trying to duplicate a Zoho application. When we attempt to do so, the process does not complete and instead remains stuck on a loading interface. To help you understand the issue better, we are sharing
      • Controlling the layout view for profiles

        Is there a way to control which layout a user sees for contacts which is based on his CRM profile?
      • How to disable email notifications about new candidates?

        Hello, I'm struggling to find where I could disable getting email notifications like this one: subject: New candidate associated for [job position] Hi [name], This is to bring to your notice that the candidate[name], whose candidate ID is [ID], has been
      • Being able to send a spontaneous candidate to client or hiring manager without a job link

        Hi, Could we add the possibility to send a candidate to a client or a hiring manager even without relating the candidate to a specific job? In our reality of searching for great Talent when we find one we need to send him to our client or manager for review or meeting even if we don't have a job opening. It will happen when: We receive a spontaneous candidate's resume that doesn't correspond to any of our active jobs. OR When we are viewing a candidate associated to a specific job that we are not
      • Can't import a PDF

        Why on earth can we not import / upload a PDF? Like one of the most common formats an accessible document would be in!
      • Layout Permissions

        I have layout that I need only once role/user to access I have made sure the user does not have permission to the other layout I do not want them to see. However, they can still see all the other records. Please help I need this solved ASAP.
      • Introducing Appointment Title Customization

        Hi all, We're delighted to announce an exciting feature, Appointment Title Customization, which you can use to personalize your appointment title according to your business's specific needs and preferences. An appointment title provides a glimpse of the
      • Custom Deal Name in Lead Conversion Mapping

        I know there are ways to change the name of a Deal after conversion using a custom function, so no need to repost that information. I would like to see the CRM Improved with Deal Name Customisation and I think the Lead Conversion Mapping page would be
      • Pass page variable via ZML execute function

        I am attempting to pass page variables through the parameters field of a zml element utilizing execute function, but it does not appear the page variable is getting parsed. Am I missing something? <pc padding='25px' hAlign='left' action='ExecuteFunction'
      • Custom Modules Now available for Standard and Professional Editions with Expanded Limits across all editions

        #CRM25Q1 Hello Everyone, We are here with an exciting update to Custom Modules in Zoho CRM. Custom modules will now be available to Standard and Professional Edition users, with expanded support across all editions. The standard modules offered in Zoho
      • Zoho Books Estimate to Zoho CRM quote?

        I'm not sure why this isnt automatic, but maybe I'm missing something. When we create a quote in zoho books we have a custom function that pushes the contact into a deal within the CRM. I can not for the life of me figure out how to push an estimate from
      • How do I stop systemgenerated@zohocrm.com emails

        How can I stop Free CRM to send emails when a possible client turns into client. the emails are flooding my inbox
      • Can't insert email template

        Hi there, When I click on a contact and select Send Email, I would like to be able to insert an email template. I have created an email template in Setup> Customization> Templates however this option is not availabe when I click Insert Template. I am
      • Open a report and filter it based on my current module selection

        I am looking to take a report that I have created and use a button in my custom module to open that report and have it filter down to the data from the account selected in the custom module.
      • How to edit goals/weightage in PMS Module after the manager has already approved it ?

        How to edit goals/weightage in PMS Module after the manager has already approved it ?
      • Formula Field

        What about a formula field in Zoho Desk?
      • Formula Fields for Zoho Desk Custom Fields

        Dear Zoho Desk Team, I'm writing to request a new feature for Zoho Desk: formula fields for custom fields. This functionality would allow us to dynamically calculate values based on existing custom fields within a ticket. Current Limitations: Currently,
      • Calculated fields and Relate Fields

        Assigned from label and length, hope Zoho could also provide an option to mark a field as a calculated field and create the formula right there without having to go to workflow. Also, hope Zoho could provide a relate field that can relate to data from
      • Overwrite Option for custom modules

        Hi Team, I noticed that the overwrite option is unavailable in Zoho Books when importing data for custom modules. This limitation makes it challenging to bulk update old data, as the only option is the 'bulk update' feature, which is restricted to 25
      • Cryptocurrency acceptance

        Hi there...a suggestion for Zoho Books: We would like to accept Bitcoin / BitCoinCash / Ethereum as a payment method, and have it automatically show up as payments on invoices. Thanks!  
      • Does Zoho Sheet "Save as PDF" support Thai font?

        Hi I want to download Zoho sheet as PDF Document. In the preview it looking good but when I dowload it the font is look different. I use "Cordia New" but the result look like it swtich to "calibri". I try to use "Print" then select printing destination
      • Double Opt-In Emails Not Being Sent Across All Forms in My Zoho Forms Account

        I am experiencing a sudden issue with the Double Opt-In feature in Zoho Forms. Starting today, when I submit any form that includes an email input field, the expected confirmation email is not being sent to the entered email address. Issue Details: This
      • Public and private KBs with Zia

        I need to create an internal knowledge base and a public knowledge base for clients. Each needs to have a Zia answer bot for employees and clients to search our articles. Right now we have a KB set up in Desk, but I've seen topics mentioning multi-branding
      • Please add "Add Developer" capability to Desk sandboxes

        Just like we can invite a developer to our CRM sandbox, please give us the ability to invite a developer to our Desk sandbox. Thanks Clark
      • Next Page