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

      • Create a standard Vendors module and integrate it with Zoho CRM

        I'm aware that Desk was initially developed to handle support communications processes where ticketing is needed. However, through many client deployments, my experience with Desk is that it can be effectively utilized for almost any communication process
      • Zoho Desk Custom Module Sync with Zoho CRM Custom Module

        It is great to see the new Zoho Desk custom module feature, thanks for this enhancement. My questions is that if there is a same custom module in Zoho CRM, can I map that custom module from Zoho CRM to Zoho Desk? Just like account/contact/product, the
      • Link Zoho Desk tickets to custom module on Zoho CRM

        Hi, We are currently using Zoho Tasks on CRM as Zoho Desk doesn't let us link tickets to specific site records on Zoho CRM based on a custom module. It can match to Zoho CRM based on an email address but this is not of use to us in our setup as the email
      • Undo the recent mass update done

        Hi My last action is a mass update done to 500 deals , which was done erroneously as the filters weren't selected correctly. Can the last log be undone urgently
      • Does Workflow Critera support multiple values when using contains?

        I'm trying to set up some advanced routing/assignment workflows based on product and would also like it to assign based on keywords in original emails/description. When using the criteria in workflow, I noticed the operator includes contains and then
      • Power of Automation :: Automatically schedule a Zoho Meeting when a Task is created in Zoho Projects.

        Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-
      • How to show related lists of a field in another look up field

        Hi team, We currently have lookup fields of accounts in deals and products module. This creates related lists in account for deals and products. I also have another module - company, the accounts module has a look up in accounts. which has created a related
      • 【Zoho CRM】集計項目のアップデート

        ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から集計項目のアップデートをご紹介します。 (集計項目機能の概要が知りたい方はこちらよりご確認ください) Zoho CRMの集計項目は、データを手軽にまとめるための便利な機能です。 今回のアップデートにより、業界ごとのニーズに合わせたサマリーをより簡単にカスタマイズして作成できるようになりました。 【目次】 本アップデート概要 集計要件のカスタマイズについて 1.本アップデート概要 以下キャプチャでは、例として「見込み客」の項目の作成画面を開いています。
      • Disabled button until field workflow executed finish in mobile

        Hi In stateless form I change value in one field and this field have a workflow execute a lot of code. but before workflow finish if I click the button . Creator will cause a error. Cloud you Disabled button until field workflow executed finish in mobile
      • How can I add an element to a specific array position in a list of arrays?

        I have a list of event records that I am de-duplicating. Each record contains a title, a date, and an alphanumeric ID (needed for an external function). I wish to deduplicate records based on the combo of Title and Date only, because the ID will always
      • Self Client Authorization Issue

        Hi. Trying to test the api integration for Zoho Desk with the Self Client - Client Credintials flow method. I've created the self client, obtained the client id and secret, inputted "Desk.tickets.ALL" as my scope, and "ZohoDesk.[My Zoho Desk Org ID]"
      • More suggestions to the Ticket History Tab

        Rather than this relative time, it would be great to see the timestamp on items like this. Using the history to try and figure out issues is tough when you have to calculate the time in your head. Additionally, it would be great if you could click on
      • See more information of records of related lists

        Hey, we need a way to see more information for every record inside of a related list. Only columns are not enough. We need a section for every connected record where we can show data, maybe even subforms.
      • Poor Email Delivery

        Our company used Zoho about 2 years ago and always had trouble understanding why a great deal of our emails from Zoho CRM and Zoho Marketing Automation ended up in the recipient's spam folder regardless of the email content and despite having our domain
      • How to add sort order to API

        Hi, I have tried using the parameter ?sortBy=createdTime on this api https://desk.zoho.com/api/v1/tickets/xxxxxxxx/conversations?sortBy=createdTime but its saying its an invalid parameter. Is there a parameter to sort on this API? Dane
      • Bold Keyboard Shortcuts Not Working

        Formatting Shortcuts like Crtl + B, Crtl + I, Crtl + U, are not working. Is there a setting to get these reactivated? I can still do things like cut, copy, and paste.
      • Update project dates

        Hi, I was wondering if there is a way to shift dates of the whole project or a task list without changing each task start date? Thanks, Saman
      • Collaborators are not able to upload images

        Good afternoon, We have a sheet with 2 current collaborators and when they try to upload an image , a pop up comes up ' server error, there was a problem saving your last edit. Please try again' Can you kindly assist?. Thanks, Annrica
      • Requesting a file upload in Zoho Workplace not possible?

        I’m new to Zoho Workplace and am mostly liking it. However, it seems as though collecting/requesting documents is not available in the workplace version of WorkDrive. Am I missing something, or would I need to subscribe separately to another WorkDrive
      • What do you think about changing the panel's color spectrum?

        "In my opinion, the color scheme feels a bit gloomy, and I think brighter shades would be better. It would also be great if there was an option to change the colors. What do you think?"
      • More information Related Details widget area

        It would be great to have more related information added to related details when creating a client ticket. For example Account Information. We have a "Support Plan" field where we select Gold, Silver and Bronze and it would be good if we could choose
      • Timesheet Export Template

        Is there a way to save the export template when exporting timesheets? I have to select the fields I need/don't want before every export.
      • Several language in Chat Bot in SALES IQ

        Hello, I'm creating a chat bot for my company and would like to have a chat bot replying in French and English. As I understand, I must create 2 different bots, then according to the first sentence of the Client the system will choose the right one: FR
      • Open Tickets

        Is it possible to get a notification if a ticket is left open for X amount of time? For instance, if a ticket is left open for 1 week, can I get an alert to follow up on the ticket and close it out if necessary? Thanks!
      • Searching through the Attachment's Content

        Case: An email comes in with a file attachment The file attachment contains a REFERENCE# Agent searches using the REFERENCE# Zoho Desk Showed No Result Is Zoho Desk incapable to search through an email/thread attachment's content?
      • Zoho Books Bookkeeper

        We are looking to move our current finance activities to Zoho Books, and our current bookkeeper doesn't have the ability to learn a new software. Does anyone have any recommendations for a local bookkeeper in Ontario?
      • Ticket owner for desk ticket can't be set using Zapier "Create ticket" function.

        I have a step in my zap where I create a ticket in desk, everything works fine apart from setting the Assignee (Ticket owner in desk). When I look at the data sent to the API the assignee variable has no data I can set the assignee (Ticket owner) if I
      • CRM deals help!

        We are using Zoho to track the sale of digital products. The way they are purchased is that the user of our website (the purchaser) goes into their account and 'raises' a deal. This is classed as a 'draft purchase' and we have changed the probability
      • Department Customization Copy/Paste

        Hello! I love the new customization of the layouts, rules and templates! However, we have several "departments" that operate similar and as I'm updating either ticket layout or workflow rules, I'm finding that I have to do it in each department. I would
      • Guidance on Making Zoho Desk Connections Available for All Data Centers

        Hi Team, I’m currently developing an application using Zoho Desk connections to manage OAuth for my third-party products. Could you please advise on the steps required to make it available across all data centers? Looking forward to your thoughts on
      • Chatbot hang in establishing connexion with customer service

        Hi, When a user try to converse in the chatbot, the bot hang trying to establish a connection. Here are the errors in the console : POST https://salesiq.zohopublic.eu/visitor/v2/notariel/conversations 400 (Bad Request) And also this error : { "error":
      • Projects Integration - how can I bring the submitter of the form into Zoho Projects?

        I've spoken to Zoho several times about this but they've been pretty useless and taking ages to respond to the ticket. I have a form set up in Zoho Forms and when this is submitted, it auto-creates a task in a project in Zoho Projects via the Projects
      • Zoho Sheet View

        Hello, Is there a way to either customize the columns that appear in Zoho Sheet View, or else show all columns?
      • Linkedin - Recruiter System Connect

        Hi there! Does anyone here know how to connect Zoho Recruit to Linkedin Recruiter via Recruiter System Connect?
      • Forms choice-based field rules multiple primary fields

        Will you be adding the functionality of being able to choose more primary fields in the choise-based field rules? For example: I have 3 fields: Type, CPU, RAM When i choose: Laptop, i5 it should show 16GB of RAM as the option. But when i choose: Desktop,
      • MULTIPLE SUPPLIERS

        I am a wholesale/retail business that has thousands of inventory lines that we buy from multiple suppliers. I would like to do the following: Be able to quickly identify suppliers with their MPN's, costs and lead times in the product screen so that i
      • How to filter dynamically in query table report?

        I created the tabular view report using the query table below. How can I do if I want to add Invoice Date filter in the report and pass the value to this query? SELECT "Customer ID", SUM("Total (BCY)") as "Total Sales (BCY)", COUNT("Invoice ID") as "Total
      • Reply All function omits the full list of original To and Cc recipients in the email body

        When using "Reply All" in Zoho Mail, the email body only shows the sender's details (e.g., "John Doe wrote") without listing the original To and Cc recipients, making it difficult for recipients to see the full email thread context. This differs for example
      • not able to hit inventory api

        when i hit the api with my account keys and the access is provide by the client
      • How i can move the records from blueprint A (inactive) to new blueprint B (Active)

        Hi team I have a question, I just generated a clone blueprint (A) which I left active, and the original blueprint (B) deactivated it, well, I need to move the records from (A) to (B), is there any way to do it? Regards, Pablo
      • Next Page