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 Mail not fit for business

        How are businesses using Zoho Mail? In Zoho Mail: You cannot create subfolders in a shared mailbox You cannot add a second email account eg. a non-Zoho account that could then provide the function of providing a shared mailbox with subfolders In the Trident
      • Additional step for Deleting an app

        Have an additional step for deleting an app. When the popup occurs, the user needs to write "DELETE" into a text field. This is what Google does. At the moment, it is too easy to Delete, which increases risk, and this should be easy to implement.
      • Enhancement - P&L Statement and Balance Sheet

        Hi there!   Providing an option to compare financial statements from different quarters was one of the most requested features in  the recent times . We're more than excited to have come up with a solution - a  Comparison  feature for P & L Statement and Balance Sheet.   Profit and Loss Statement and Balance Sheet provide you with  a clear picture of   the 'hows'  your company can generate more revenue or cut down on costs and what you own and owe. But, then having this year's statement compared
      • restrict access to user to create invoice

        hi team we need to restrict particular users from accounts dept to create invoice directly from invoice module in zoho books . Rather , they can only able to create invoice is by using "convert to invoice" from "Sales Order" module . pls help us to solve
      • Request to Make Cheque Printing Available as an Add-On Across All Plans

        Hi Zoho Team, I have been using Zoho Books and other Zoho products since 2019, and they have significantly streamlined my business operations. However, I believe there is room for improvement in terms of feature availability across different plans. One
      • Zoho Forms Lookups Not Accessible

        I am trying to set up a sign-in form where visitors can scan the QR code onsite, select the job from the lookup field, and it attaches to the job in the CRM. It looks like external users cannot use the lookup feature. Is this correct? It seems almost
      • Notes Filter is not working

        I am trying to filter the CRM down to specific notes that I want that'll show up all the data that has a specific keyword for example, "stocks" and it says no leads are found... Don't know how to fix. don't know if it's a system glitch. I even put a note
      • Customize the Date Format based on preference

        Hello Everyone, We have rolled-out a new field called Date Pattern in the user layout under Locale information. Note: If you notice any change in the date format after this roll-out, please select your preferred format from the settings. Previously, the format of the date was automatically set on the basis of the country locale selected by the user. Now, the user will be able to edit the format in which the date is displayed according to their preference.  The Date pattern field has around 40 patterns
      • Scheduled function not firing workdrive.uploadFile task

        I have a creator app that takes submissions from a published form. I setup a daily scheduled function to send a record template of the form, as well as 3 different uploaded files to workdrive folders. (Initially I intended for this to happen on the submission
      • E-mails to suppliers

        Hi, i want to upload a spread sheet every day and send an e-mail to our suppliers every day (or when triggering a button?) with info from the spreadsheet lines. The supplier e-mail would be on each line. Unfortunately, when creating a scheduled automation,
      • Rearrange web - hidden components

        When you have a good number of forms, reports and pages, searching for one among the hidden components to add it to the menu is simply hell. Huge amounts of time are wasted.
      • Using Insert into to transfert a date in another form

        Hi, I have an order form that creates a record in a calendar form, for managing the delivery date. My customer can change that date in the calendar form, but i need the new date to be put in the original order form. I tried the following but it doesn't
      • Migrating from Zoho to Cpanel

        I would like to migrate my few of my email accounts to Cpanel, yet keeping Zoho Mail active just in case. Is there anyway to do that? As all my mail still goes to the Zoho Account instead of Cpanel
      • Zoho books api - sales order last ordered date

        I would like to get the last ordered date for each contact in the book. How can I do this?
      • Pay Contractor Timesheets

        I have contractors that fill out a timesheet. Each hour must be assigned to a current client. I need the easiest way to get the contracts paid. They are paid on an hourly bases. How can this be done?
      • Telegram -> Zoho Creator answer via API.

        Hello! Did anyone work or established back connection from Telegram to Zoho Creator via API? I'm able to send notification from ZC to TG Bot successfully. (webhook is set) My notification consists of some information and inline buttons "yes" and "no".
      • Update a form record based on another form with same user ID

        Hi, I have 2 forms linked : Customer and Subscription When a customer fills-in a subsequent subscription form, there is a automatic subscription number created in the subscription form that I want to paste in a miroir field in the customer field. What
      • Issue Configuring SSO Integration with Cognito in Zoho Help Center

        Dear Zoho Support Team, We have been working on configuring SSO integration for our Zoho Help Center using Amazon Cognito. While the setup appears to be completed successfully, we are encountering an issue when attempting to access the Help Center. The
      • Date Time

        Hi Everyone, I would seek some help about this concern that bugs me. I'm currently working using Zoho Flow to automatically plot a calendar on the Calendar Report. Whenever a ticket from Zoho Desk Field was updated this will trigger to create a plotted
      • Introducing Bot Filtering for Accurate Email Campaign Analytics

        Update : This feature has been revamped. For the most current information and improved functionalities, please visit the updated version here. Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign
      • How can I make time entry mandatory for tickets?

        Hi guys,  I just want to make a time entry field mandatory for tickets. How can I do that? At this stage of our usage, it's not mandatory and it could be forgotten to input a time for a ticket.  Thanks in advance 
      • Zoho Workplace gets yet another security boost: The addition of Zoho Vault

        Hello Community, Passwords are often the first line of defense, yet they're also one of the most common weak points. We're thrilled to announce that Zoho Vault is now integrated with Zoho Workplace! Zoho Vault Standard is now included at no extra cost
      • inventory removal at packing list or shipment.

        currently our system is set to remove inventory at invoice. This is creating an inventory nightmare? Is it possible to change the settings to remove the item from inventory at either the packing slip stage or shipping the item.
      • Change to copy/paste functionality in Deluge code editor

        Recently there was a change to the Deluge code etidor where it now inserts backslashes into strings automatically when copying/pasting strings with double quotes, it's a nightmare to have to go delete all these. Is it possible to toggle this on or off?
      • Clear a date field?

        I've got a date field, let's call it Returned_date.  I'd like to write a script that clears the values from another date field called Expected_date upon a successful entry.  I know where to put the expression, but I'm having trouble building the expression.  Any assistance from anyone for a newb question would be appreciated.  Thanks in advance!
      • Integrating ChatGPT with Zoho Creator for Automated Report Generation: Is It Possible?

        Hi everyone, I’m currently working on an application in Zoho Creator and would like to know if it’s possible to integrate ChatGPT to automate the generation of reports based on the data captured within the application. Has anyone successfully implemented
      • There anyway to change a creator app Back to DEV thats not got a back up?

        As above, is it possible? Thanks.
      • Submit to hiring manager

        It would be benficial to be able to send assessments as part of the attachment when submitting candidates to a hiring manager. Recently i created a recruiter assessment which i complete when phone screening the candidate. I would like to send the supporting
      • Cross-Posting to a Telegram Channel

        We don't have a native way to cross-post to Telegram channels. Did anyone find a way around it? I checked Zoho Flow - but Telegram isn't there. Maybe some 3rd party integrations connecting Facebook, IG, etc., bypassing SalesIQ altogether?
      • How to connect the Squarespace website with Zoho Thrive

        Our website is created using Squarespace. To boost our sales, I planned to do the affiliate program and I thought to integrate our website store with Thrive. but I don't see the Squarespace platform. if I choose the custom build, I have to generate the
      • Chat Widget Does not appear for users

        The chat icon appears for some users, and not all. I know our integration is set up correctly because of the fact that some users can see and use it. I also cannot provide a link to our website for security purposes. But we need a resolution to this as
      • Incoming Emails Landing in my News Letter Folder

        Hello, Most email is landing in my inbox but those that come from a web form from my site are landing inside my News Letter Folder. What do I need to do to make them land inside my inbox? Thank you, Cindy
      • Possibility of Recording CookieConsent in a Hidden Field in Zoho Forms

        Dear Zoho Forms Team, We are using Zoho Forms on our website and have encountered a technical question related to GDPR compliance. Currently, we have Google Tag Manager installed, along with a script that tracks UTM parameters and GCLID. To comply with
      • Snapshot of totals

        Hi, I'm more familiar with Creator so it's taking me a while to wrap my headaround the CRM. I've been asked to produce a metric that takes a snapshot total of ceratin fields everyday when they meet certain conditions : Total Average Value for example.
      • Bulk change color of selected notes

        When I select several notes, I want to change their color, but there is no such function. I miss it.
      • Supercharge your operator productivity by leveraging the power of OpenAI in Zoho SalesIQ

        Heads-up: The OpenAI integration is currently available only for users in (US, IN EU, AU and JP region). We will be rolling it out to other regions soon. From complex neuroscience to simple note-taking, AI has seeped through every part of human lives,
      • Digest Janvier - Un résumé de ce qui s'est passé le mois dernier sur Community

        Bonjour chers utilisateurs, Le premier mois de l'année s'est écoulé à toute allure ! Découvrons ensemble comment s'est passé janvier pour Zoho Community France. Dans un monde où l’information a une valeur inestimable, la protection des données sensibles
      • Zohocliq status change automatic

        Greetings Zoho, So, i've sync my G-mail calender with zohomail, now every event i get from gmail goes thru zohocliq (WHICH is what i wanted) but the thing is that when the event is there  let's say from 11:30 til 12:30PM my current status doesn't change.
      • Workflow rule to assign new case owner sends email to customer from Original owner issue

        I have a workflow rule to assign a manually created case from a sales rep. to a customer service repr to handle. I also have a workflow rule to send an introduction email from the case owner to the customer. The Problem: The email is going out on behalf
      • Zoho Forms - Shared Forms

        I chose SHARED FORMS and noticed "Enter atleast" needs a space to be correct.
      • Next Page