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 link Custom Fields in Ticket view

        Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making
      • How can I delete Customer Portal User?

        Hi, I have added two portal user. Now I want to delete these users (setup->customer portal->users), but I can only activate, deactivate and re-invite user. Before adding these users in customer portal, I have added them in contacts and after that I have deleted them. I  have added theses two user with my 2 different email id. The reason behind is before going live I wanted to test my invitation mail, how its looks in template and its embedded link to accept the invitation, whether acceptance link
      • Notify on new comment

        I would like to notify users when a new comment is added to ticket/request? So if someone is following request they would get email or text saying that comment has been added to this request. Or request/ticket owner get notified. Thanks Luis
      • Allow users to display columns dynamically

        I have a table with 50 users in Column A and the dates 1 Jan to 31 Dec along Row 1. I want users to be able to add data to the cells but would like to make it easier by allowing users to select a date and display that. So if the user wants to add data
      • Date Range Field

        Hi Guys Does anyone know how I can create a date range field on a form? Cheers Chris
      • Stopped getting zoho notifications in Email for Customer response to support tickets

        Hello , I stopped receiving Notifications from customer response in my company with attached to this account.
      • Creating QR Code from sales order for each line item

        Hi there, process for QR is to receiving goods/item/equipment from our clients.. and service them and return back to clients. so upon receiving we have the following entries (item details, with serial number and accessories details and service details)
      • Evergreen email sequences in Zoho Campaigns

        Dear Zoho Campaigns Team, I’d like to propose a new feature for Zoho Campaigns called Evergreen Email Sequences, building upon the existing Autoresponders functionality. This addition would empower email marketers to create and manage long-term, sustainable
      • Zoho Flow reads record Tag as number instead of text string. How do I change it?

        I have experience with flow and have a number of them working. This flow is supposed to add a record in a custom module when a Contact record is edited or created with a specific tag. Trigger criteria is "Tag contains 'Athlete' ". However, the flow does
      • Lookup Field in Zoho Forms <> Zoho CRM Integration

        Hello, We use Zoho CRM to manage our products, create quotes, etc. I want to use Zoho Form to configure a simple form that allows customers to request quotes on our website. I completed the form and used a subform for the "Add items to your quote" part
      • ChatGPT

        Hola, sabéis si además de tener la licencia de chat GPT Plus hay que comprar créditos para usar chat GPT en zoho social? Gracias
      • zappsusercontent.com refused to connect.

        I have added a widget to bigin and when i try to access the widget it indicates "a0bfe442-8e0d-4646-a350-5b1b74d6ea3b.zappsusercontent.com refused to connect."
      • ERROR

        I deleted a contact card, I want to add it again but it says that the contact already exists. I searched the records and it is not there, and I even deleted it in the trash. The email is this one:xxxxx. Please help!!
      • Chroniques de l'année 2024 Zoho France : avec vous, pour vous !

        Nous vous adressons nos vœux les plus chaleureux pour une année 2025 exceptionnelle et pleine de réussites ! Fidèle à son habitude, Zoho France vous réserve chaque année de nombreuses mises à jour, des événements marquants, des activités diversifiées
      • Kaizen #173: A Comparison of Zoho CRM REST APIs and GraphQL APIs

        Hello everyone! Welcome back to another week of Kaizen! Zoho CRM offers two API architectures for its users: REST API and GraphQL API. Each of these API architectures has its own strengths and ideal use cases. In this post, we will discuss the difference
      • How to preview a locked note? Or just lock one?

        Once a note is locked there is no preview, just a blur (good). But, if there are a lot of notes, wouldn't it be good to have the title show up and blur the rest? Or am I just being dumb - do they all unlock and lock at the same time?
      • Linkedin Plugin

        H, Is there a plugin to allow the connection to LinkedIn and simplify editing? I've looked at a few, but they all seem to be outdated and not working... What do you use or can you recommend?
      • !! URGENT My sent mail goes to spam

        I tested a few times and every time I send mail out it goes the recipients spam box.  Why is it marking my mail as spam? please help me ! thanks
      • Zoho VPN

        Hi,  I'd like to know if Zoho offers VPN. If yes, can you tell me how to access using VPN. If not, any VPN recommendation that I should use? Thanks. 
      • Difference between Admin, Team leader/Manager, Clinets/user profile and roles in Zoho Project

        I've been wondering to find out the difference between the key feature of Admin,Manager, and client/user in Zoho Project. I am student and trying to learn about the Zoho Project. I could not find the roles and profiles difference between this 3 users
      • Missing Modules such as RFQ, Purchase request and Store room

        Hi, I wonder why zoho doesn't add Purchase requests module e.g. ( a lower level staff wants to request for provision of something) which can be approved or rejected by his/her manager. In case of approval, same request can be converted into RFQ. Secondly
      • Important updates to Zoho CRM's email deliverability

        Last modified on: Jul 24, 2024 These enhancements are released for all users across all data centers. Modified on: Oct 30, 2023 Organisations that are in the Enterprise and above editions of Zoho CRM, and have not authenticated their email-sending domains
      • Zoho expense linked with Campaign instead of customers

        Hi, Is there a development planned for linked an expense or a report to a zoho campaign? Indeed, suppose I created a campain in which I add different clients (for example a trip to a foreign country where I meet 3 different clients), I would like this campaign to be linked to the expenses I have. Say I have a plane ticket, taxis and 1 hotel night, I would like those expenses to be linked to the 3 clients. With Zoho expense, it is not possible at the time (or maybe it is but I do not know how!). thanks
      • Introducing 'Dynamic display' in the latest version of the Bigin Android mobile app.

        Hello everyone! In the latest version of the Bigin Mobile Android app (1.6.0), we have introduced support for Dynamic Display, which transforms the List View into a powerful and customizable visual interface. Dynamic Display: This feature allows users
      • CRM - Copy data from Single Line to Lookup Field

        Hello, I need help to create a workflow with a custom function in order to copy value from a single value field to a Lookup Field. Module : Shipment Single value field API name : Customer_ID Lookup field API name : Account_ID WOuld be great to have some
      • How to Parse XML Data Returned by API?

        I have several APIs integrated with my CRM and they work great. I am having some trouble though parsing data out of a large string/array in Funtions? I need to be able to pull the DeviceId and the WebSiteDeviceName from each PanelDevice. I would appreciate
      • Lead Owner not importing all users only main user

        I have set up 3 users, 1 CEO, 2 Managers, all users have been verified. I'm using the Free ZOHO version. When I go to import Leads my Excel file has these 3 users listed as the Lead Owner. However when the import completes only 1 user is displayed as
      • Automating leave alerts in Zoho Cliq

        The constant ebb and flow of employee absences can disrupt projects and hinder productivity. With Zoho Cliq's leave alert automation, you can easily keep your team informed. Real-time notifications can be sent to team chats, ensuring that everyone stays
      • How to increase number of contacts shown in CRM Campaign ?

        Hello Everybody, I can't find a way of increase the number of contacts displayed per campaign. It is limited to 10 contacts which is very distressing when I need to update the status of several contacts. What a huge waste of time and energy Is there a
      • Key Highlights of 2024: Recalling a Year of Progress and Advancements!

        As we step into 2025, we’re excited to share the progress and developments we’ve made to simplify and streamline your travel and expense management in the past year. Let’s take a look back at some of the key updates and enhancements that have helped us
      • No longer get Cliq notifications on phone if app not started

        On Android, I used to get notifications on my phone whether I was in the app, or it was started. Then about a month ago, I stopped seeing notifications on my phone UNLESS I had already started the app. So if I reboot my phone, and never start the app,
      • CUSTOMER RUNNING BALANCE WHILE PRINTING RETAIL INVOICE IN ZOHO BOOKS

        This is basic problem in zoho books where at the time of printing retail invoice, we can't add customer running balance. Kindly provide this feature as every other accounting software has customer credit balance option at the time of invoice printin
      • MORE BUGS: Client Script, Deluge and Widget JS SDK don't work as expected when trying to retrieve a record that has been "rejected" as part of an approval process.

        Client Script $Page.record is null when accessing a record that has entered an approval process (or been "rejected"). Deluge zoho.crm.getRecordById(moduleName, recordId) returns {"status":"failure"} when recordId is a valid, but rejected record. OK...
      • Mandatory verification of custom domains in portal

        Hello all, Happy New Year! Wishing you a successful and fruitful year ahead. We are committed to ensuring a safe and secure experience for all users of Zoho Creator users. As part of this commitment, we regularly introduce updates to ensure our platform
      • Lost all my notes, help :(

        The thumbnails correctly preview the text, the file info correctly shows the amount of characters, but all of my notes just get stuck at this screen when I open them. :( ... I have so many projects in here, I don't know what to do, is there any way to
      • Zoho CRM Workflow Merge Tag For a File Upload

        Hello, is there anyway to add a merge tag for a file upload field in Zoho CRM Workflow emails? I don't see it as an option in the drop down. Thanks, Hannah Moderation Update: I'm locking this post as a similar discussion is ongoing in the thread linked
      • Custom function daily limit and procedural programming

        Dearest Zoho Today, support confirmed that if I call a custom function from another custom function then I will use up two, with regards to my daily limit. A few times, we have blown our daily limit and that means that ordinary business processes don't
      • Calendar Overflow in Open URL popup

        Hi everyone, When Opening a form which has a date field in openurl popup, this happens. Is there any way I can change the calendar width and height or is there any other possible way this can be changed? Thanks.
      • Deluge Script - "Mismatch of data type expression" Error When Retrieving Account ID

        Hi everyone, I'm working on a Deluge Script in Zoho Creator to create Accounts and Locations. I'm running into a "Mismatch of data type expression" error when trying to retrieve the ID of a newly created Account. Here's the relevant part of my code: accountResponse
      • Update field in “Validations on form submission”

        Hello, I have a hidden field in my form. I created a workflow that is executed when a record is created and triggered an event in the “Validations on form submission”. At this point I retrieve an external ID and need to add this value to the hidden field
      • Next Page