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

      • Stock (on-hand) Items not updated after using Composite items

        Hi there, I created a Composite item (consist of 3 items). After I created the Composite item, I invoiced it and shipped the items. However the actual stock on hand of the 3items didn't change at all. Have you guys encountered this? Thank you Regards,
      • Automatic feed for OCBC and DBS does not work

        I would like to post this as a warning to all Singapore users thinking of signing up for Zoho Books. STAY AWAY!!!! Go for Xero instead. I've recently signed up for Zoho Books (Paid account) as I was told by their sales rep that it would be able to link
      • Calling Flows from other flows

        Hello, I have to manage multiple flows, triggered by different webhooks. I noticed that all of them have common blocks (creating a CRM account or updating the account accordingly plus addind notes and tasks). I would like to optimize the flows. My idea
      • Important Update: Mandatory Email Domain Verification for Zoho Analytics Users

        To enhance the security and reliability of email notifications, we are implementing an important update. Starting February 1, 2025, verifying your email domain will be mandatory to continue sending email notifications via Zoho Analytics. Failure to verify
      • Problem during switching between accounts

        Hello, We have a problem during switching between "accounts" and "delegata accounts" in zoho mail desktop. Quite often while doing it, zoho mail app shows "Opps... A problem has occurred. Try again." It's quite annoying during everyday work. What can
      • Zoho Mail - Import Event from the main page (not options)

        Hello, If you need to import an event or invitation in Zoho Calendar, you need to go in the options/parameters to do the import. We would suggest to have a "import" button and pop-up on the main calendar page. It would avoid to go in the options to do
      • Syncing Fields Between Accounts AND Deals

        Please don't email me, I will check this thread for updates daily. I have a custom set of 10 fields (CFSET) in my account pages and deals pages. I want to fill them out on accounts pages per each, then when I make a new deal in an account, I want to copy
      • Getter error message Number of statement execution limit exceed Line:(216)

        Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range) displayname = "Pay Period Details" content <%{ /* Get The current Pay Period Record */ Int_Pay_Period_ID = PayPeriodID.toLong(); Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID]; Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID); /* Checking Agent
      • How to Add Portal Users in Zoho Creator's Development Environment for Testing?

        Hello, I’m working on a Creator app with a customer portal and implementing filters based on the logged-in user (customer). To test these filter functions, I'd like to simulate or add customer portal users in the development environment/database. Is there
      • 2024年度 Zoho Champion 決定のお知らせ

        ユーザーの皆さん、こんにちは。Zoho コミュニティチームです。 Zoho コミュニティでは、2024年の1年間でコミュニティに貢献し、他ユーザーの役に立つ活動・情報発信を特に積極的に行ってくださった4名の方を、 「Zoho Champion」 として表彰させていただきます! @西尾真言さん、 @Kunio さん、@岡安裕一(Yuichi)さん、@Suzuta さん ユーザー交流会の事例セッションへの登壇、フォーラムへの投稿 / 質問への回答や各活動についてのフィードバックなど多くの貢献をいただき、大変感謝しています。
      • Report support List data.

        Hi Could Report support use list data? I hope I can create a list with deluge and push to a report. It will increase efficiency .I don't need insert data to a form.
      • Unique Use Case?

        We operate a lawn care & landscaping company and are developing an instant estimator on our website based on a lot size api. Is there any way to pass a monthly subscription price onto a hosted payment iframe? Every user will have a different price so
      • Enhance Zoho Flow's Jira Integration

        Hi, I hope you're doing well. We would like to request an enhancement to the Jira integration within Zoho Flow. Currently, Zoho Flow allows us to create and fetch users in Jira, but it lacks essential functionalities related to user management within
      • Zoho Show Slide Decks Not Accessible

        Hi. Currently, my Zoho Show slide decks are not accessible. Please fix it. My Writer files are still accessible, so I'd think something Zoho Show-specific has happened. Thanks!
      • Unable to see clients/accounts from my CRM on Zoho Recruit.

        I am wanting to see my clients/accounts that are on my CRM within Zoho Recruit. CRM and Recruit seem to be integrated as I have access to all of the candidates, but there is no option to get my clients on there. I have activated the extension in marketplace
      • Auto-Create OneDrive Folder Structure Upon Lead Creation

        Hello, New to Zoho and looking for help on a critical process automation I'm looking to implement. My company currently utilizes OneDrive for file management and the folder structure is Proposals -> Client Name -> Address (where I need to initially create
      • Images uploaded onto text notes through the mobile app won't render

        When uploading am image onto a text note, exiting the note and going back in, the image is gone and shows an error icon in its place, and also won't display directly on other devices, including on the desktop version. Uploading the same image on the same
      • Internal Support and Assigning Tickets

        I want to set up an Internal Desk Support system. Here is what I need... We need our internal "Support" staff to be the Ticket Owner We need to be able to identify who the "Account Manager" is on that client and get emails as part of the ticket. I'd like
      • No table view in "All departmens" mode

        Hello, I would like to have an overview of all tickets, so I have to switch to "all departments". But here I don't have the possibility to activate the table view. But this is mandatory, so that I can see certain fields without having to open each ticket
      • Get Creator Form Record ID and Subform ID's

        Good Afternoon everyone. I have a Creator form with a on success workflow. I'm trying to get the form record ID and the subform record ID(s) but they keep coming up null. There is data in the subform I use it elsewhere. Can anyone help me pull the ID's.
      • WhatsApp and Zoho Creator Integration

        How we have integrate WhatsApp App with Zoho Creator without using external application ?
      • Ability to use Dynamic goals in Motivator

        Is there any way to create dynamic goals in Zoho Motivator? By "dynamic" I mean: not the same target every period, but varying from period to period. For example, in our organization, sales reps are supposed to target beating the same month's sales last
      • Calendar - "super compact" week view

        every time i go to my calendar i have to re-engage the "super-compact view" for the week view...is there a way to make "super-compact" a default view so I dont have to keep on setting it manually?
      • zoho calendar week view - "super compact by default"

        every time i go to my calendar i have to re-engage the "super-compact view" for the week view...is there a way to make "super-compact" a default view so I dont have to keep on setting it manually?
      • Allow submitter to type a choice in a 'Multiple Choice' field

        Is there any way to allow the person filling out a form to manually type in a choice in the 'Multiple Choice' field? So like have the option of allowing the last field to be 'Other' with an input field...
      • Instagram reset password email not getting through

        Recently joined Zoho. I have the free version. I have a domain registered with Fasthosts, without a hosting package, (no website, no email). I have sent emails to my Zoho email from Instagram to reset my password, but they are not getting through.  Can you help? PS please dont ask me to get any info from Instagram, as they only give stock answers on their help site and I cant find any way to ask them specific questions or to request data. Cress
      • Pages Limit of 5 on Zoho Sites with Zoho One Trial account

        Hello, I was building my website in Zoho Sites (I have a Zoho One Trial plan) and seems like I've reached a page limit of 5. I then checked the Zoho One limits and looks like the limit is 50 pages per website. I can't seem to find a way to correct this. Is there something you can do on your end to increase the limit on my account? The error I get is "Oh no! Your current plan does not support this feature. Upgrade your subscription to use this feature." when trying to add a new page. Kind Regards
      • How do I configure network solutions to work with zoho sites

        Hi, I have a domain with network solutions and have my zoho mail all set up and working. I cannot get zoho sites to work with my domain, I cannot change the cname to point to zhs.zohosites.com Can you please give me a walkthrough for this? Mick
      • Mapping a custom picklist to another picklist when creating a connected record with a workflow

        Hi, I have some workflows that move records between pipelines, the issue is that when setting up the workflow that creates the connected record, there is no option to map the value from a picklist in one pipeline to another. Please watch: https://www.loom.com/share/4e5fa969b21043748414154c036cdd47?sid=dca0fd16-73f2-4fe6-a9d3-7a4c0c40c2e6
      • Initiate data import using Deluge script

        Is it possible to open the screen to begin the importing of new records using Deluge? So for example, my users would click a button on a form that starts a workflow action. This action would then open the screen to "Import Data for Current User Projects".
      • Lookup field - Can I avoid using advanced search?

        I have a lookup field in my app that has surpassed 500,000 records, now basic search is disabled and I'm forced to use advanced search. That adds multiple steps to what used to be very simple. Before: Select field > Type last digits of product code and
      • Forced Tooltip on Maps View

        Please remove the forced tool tip data points and ONLY include those listed in the "Include Columns for Tooltip" area. Also, disable the tool tip if no fields in there. With a lat/lng map, it forces showing those (and color field, lat count) and will
      • Last sync date/time as a widget

        Is there any way to get the last date/time that the data shown (reports and dashboard) was last updated. For example, If I have our data being synced every 3 hours and the last was done 2 hrs ago, I would like to show date/time of update OR updated #{hrs}
      • Function #19: Associate invoice templates automatically based on branch

        Much like the custom function we shared last week, today's function also aims to facilitate the automatic association of invoice templates. When you're managing business operations across various branches, there may be a need to create and send invoices
      • Milestone

        New to Zoho and trying to get acquainted. According to PMI a milestone "anticipates what the project is supposed to achieve at a pre-set date. It should describe a desired state of affairs, a desired future situation. There are two important aspects to this. First, the concept refers to a point in time, not a period of time. Second, it looks forward to what we want to create, not how we create it." Why are Zoho milestones defined between two dates and as bins for tasks? Why would you even consider
      • 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
      • Next Page