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

      • Issue with Missing Email on Reply or Forward

        مرحبًا بفريق دعم Zoho، أواجه مشكلة مع Zoho Mail. عند الرد على بريد إلكتروني أو إعادة توجيهه، لا تظهر الرسالة الأصلية أو البريد الإلكتروني المرسل بشكل طبيعي للمستلم. بدلاً من ذلك، يتم عرض رمز ثلاثي النقاط، ويتعين على المستلم النقر فوقه لعرض البريد الإلكتروني
      • Recommendations to store meeting notes for easy access from Contacts, Accounts & Deals module records?

        I would like your advice on how to achieve this use case for my organization. It’s related to where/how best to store meeting notes from a conversation with Contact(s) working at an Account (Company) in the context of a Deal. The ideal solution (from
      • ssue with Zoho Mail – Original Email Not Displayed Properly in Replies or Forwarded Emails

        Hello Zoho Support Team, I am experiencing an issue with Zoho Mail. When replying to or forwarding an email, the original message or the sent email does not appear normally to the recipient. Instead, a three-dot icon is displayed, and the recipient has
      • remove one field

        we want to remove compensation amount field from our offer letter,As we are hiring interns we don't want compensation amount.
      • Images Added as Attachments to Email

        Hello, I am not sure if I am doing something wrong, but I am new to Zoho CRM.  I just created my first email template that contains about 5 images.  When I test out the email, it includes each of the images as an attachment to the email. Is there a way to remove this functionality/feature so that the images are shown in the email, but are not also included as attachments?   Thanks in advance.   Jo-Ann
      • Caso de Uso | Fermax omnicaliza su atención al cliente con Zoho Desk

        “Zoho Desk nos ha permitido gestionar la omni-canalidad. Ahora nuestros clientes puedan comunicarse con nosotros desde cualquier plataforma", José María Vázquez, CTO de Fermax. ¡Hola, Español Zoho Community! Sabéis que nos encanta compartir cómo otros
      • Issue with Exact Phone Number Match in Zoho CRM Search Record API

        Hello Everyone, I am working on a custom function that works as a REST API. This function receives API calls via a third-party webhook, where the payload data contains various details, including phone numbers, names, dates, etc. A single payload can contain
      • How to Automatically Populate the Deal ID in the Parent Lead After Creating a New Deal with Blueprint?

        Hello Everyone! 🎉 I wanted to share a solution to a problem that some of you might have encountered. In Zoho CRM, when creating a Deal from a Lead using a Blueprint, data can only flow in one direction—from the Lead (parent) to the Deal (child). But
      • Easy way to delete attachments

        I've reached my data limit and would like to run a view/report, and mass delete attachments. Is there an easy, fast way to do this? Moderation Update: Post Summary: There are two features the post discusses a) Easy way to remove Email attachments Will
      • Strange pop up windows when sales order saving.

        Hi, May I ask what's the meaning of this pop up window. Our client script don't have this setting..
      • Workload Reports

        Under Reports > Workload Reports, would it be possible to get Kanban view sorted by Task Owner? Seems like it'd be an easier/ quicker view of how many tasks are assigned to each user and what status they're at. Also gives you more information about the
      • Email forwarding FROM TeamInbox?

        can find plenty of instructions to forward TO teaminbox, but nothing on adding an action to a rule that allows me to forward incoming email TO my TeamInbox OUT to external emails. Situation: Have a IT tech on retainer (not my employee), need to forward
      • New permissions for accessing emails sent via Zoho CRM

        Last modified on Nov 4, 2024: Permissions for accessing emails sent via Zoho CRM have now been extended to the IN DC. With this rollout, the feature is now available to all users across all DCs. Resources: Data sharing for emails, Configuring email compose
      • How to add coloring on List Reports

        Hi guys, I would like to add colors to List reports. Is there an option to apply table colors other than using the custom layout? Thank You!
      • Zoho Sign Product updates - H2 2024

        Hello! We have almost come to the end of 2024! Here's a list of features and enhancements that went live in the later half of the year. NOM 151 certification Witness signing Formula, conditional, and custom fields Zoho Sign's extension for Bigin by Zoho
      • Telephony External ID field added in CRM

        Dear All, We have an enhancement for users with telephony integrations—introducing the Telephony External ID field. Let's get into the details! What is an external ID field for telephony? External ID fields in Zoho CRM essentially hold a record's reference
      • Lookup field, odd issue

        So I tried creating and app that has the names of engineers so I can use that for a lookup in the other apps that are being created . I add the look up in a new app, launch the app and when I try to fill out the form its just blank in the drop down menu
      • Query About Updating Records in Batches via API

        We are working on integrating the Creator application with an external app, and we need to update thousands of records daily. I understand that the "Update Records" API is available; however, it appears to be designed for updating multiple records with
      • PDF API FROM ZOHO CREATOR DELUGE SCRIPT

        Hi I am in need of using a PDF Api to compress and Merge PDF files from zoho creator. Any support on this would be really helpfull any sample code for any PDF API would be extremely heplfull
      • Streamline Custom Dashboards

        I'd like every brand have the same dashboard. Is there a way to streamline them so every brand has one? Or that I can use the same dashboard from another brand?
      • Remove the link between app admin roles and org admin privileges

        Greetings Zoho One Team, Currently, assigning someone as an admin in certain Zoho apps, such as Cliq, Connect, Mail, Vault, or Forms (and maybe other apps as well) automatically grants them org admin privileges, even though they are not listed as org
      • How to remove banners at the top of email web page

        Every day, I find valuable screen real estate being consumed by Zoho advertising themselves at the top of my email web page. I can dismiss that "announcement", but something else will come back the very next day. How do I permanently dismiss them as 99%
      • My domain provider does not support to DKIM records

        My domain provider does not support to DKIM records in zoho mail. It does not allowed underscore in a TXT name but zoho had provide DKIM records already with an underscore This is the zoho provides But my domain provider does not allowed
      • Zoho email experiencing delay when receiving emails from AWS SES

        When sending an email from our SES, our non-Zoho email is receiving emails almost instantly with a 1-2 min delay, however, the zoho email we send to is experiencing delays from 3-4 hours and sometimes dont recieve them at all. Any idea what might be going
      • How to listen to ticket change

        Hello community, I created a widget, which checks all departments, if the user has written there as well, as some customer do this. Overall it works fine, except that I have to refresh the widget tab every time I go to another ticket. How can I listen
      • Is there a way to get Guided Conversation responses to appear on a ticket?

        Hello When using the Create Ticket block, is there a way to save all of the responses the user has inputted on the ticket once it's been made?
      • Tickets Assigning Automation

        I am trying to build a bot which can automatically assign the tickets to the concerning team as of now we have a dedicated person who read the emails, understands the query and then assign it to the dedicated team. I have built an prototype of the same
      • Zoho Desk using APIs

        We have generated the necessary tokens and successfully executed the following calls: • List all tickets • Get a ticket • Create a ticket We have encountered difficulties when attempting to perform searches using the APIs related to SEARCH, as it returns
      • Knowledge Base - Import PDF/Doc

        Our company already has guides and manuals in PDF/word format. Is there a way to directly important these as articles for our customer portal? When doing a copy/paste the formatting gets a little skewed and images don't post over either. 
      • Splitting a List into different rows

        I am getting a List from a for each loop. But I can't figure out how to separate each item that is separated by a comma. Example Zone 1 - Front Door,Zone 2 - Rear Door,Zone 3 - Side Door I need it too look like this: Zone 1 - Front Door Zone 2 - Rear
      • How to associate a task with a milestone

        Hi there,  Is it possible to associate a Task with a Milestone without creating a TaskList please? When creating the task there's no such option (or at least I am not able to find it). When you click on the created task, however, on the right hand side there's a field that says Associated Milestone: None (please see the screenshot attached). This field doesn't seem to have an edit option?  Can someone please advise? Thanks in advance, Lina
      • Why can't I see the email from Zoho Campaigns Automation under Zoho CRM Leads module?

        I recently did update the field mapping on our Leads sync services between Zoho CRM and Zoho Campaigns. The end goal is to create tailored email drip campaigns with the use of segments and automation. I understand you can build cadences, email templates,
      • Allow Selection of Multiple Threads and Notes for Splitting into a Separate Ticket

        Dear Zoho Team, We would like to request an enhancement to the Split as New Ticket feature within Zoho Desk. Currently, users can only select one incoming thread to split into a new ticket. However, there are many scenarios where the ability to select
      • Final reminder: Zoho Desk Old UI will be deprecated on December 15th, 2023

        Greetings Zoho Desk users! Effective December 15th, 2023, the Zoho Desk old UI will be deprecated. This means that the option to switch between the old and new UI will no longer be available. We kindly request all users to move to the new UI by clicking
      • Access Denied

        good afternoon! When I try to access my Zoho Vault account, I get a message (image attached) that my access has been disabled by the administrator. It turns out that I am the administrator and I did not perform any type of action of the type, which is
      • ZOho Vault access denied

        Hello Community, I have suddenly got restricted by accessing Zoho vault . How can I get access back ?
      • How do I share a single sheet from ZOHO spreadsheet?

        I am sure I saw this option 15 days ago. I just stumbled on it and can't find it any more. I would like to share one sheet of a single document to each collaborator. Was it not possible? Thanks in advance!
      • How to view all departments on one dashboard or ticket view?

        Hi guys, We've just started using Zoho Support and found a very weird quirk. It seems that you need to click into each deparment to view the new tickets instead of just seeing a global dashboard of all tickets across all departments. Seems very odd, is this correct or are we missing something? If this is currently not possible, can someone from Zoho let us know if a global dashboard view is going to be developed soon? How soon? This is going to be a dealbreaker for us as we have lots of departments...
      • Zoho Connect Desktop App Mac Signing Error?

        My Mac can not open the App and sais "can not proof it for Viruses" So i can not start it on different devices. Any idea?
      • 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
      • Next Page