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

      • i can't create other user with my lite plan

        hello, I have paid little plan and I have added two domains but each has its own user however zoho shows me this message You do not have enough licenses. Purchase the necessary licenses to add, invite or import users I don’t know why if I have another
      • Zoho Books & Zoho CRM - Funcionalidade do campo moeda

        Pessoal bom dia, O Zoho Books tem uma funcionalidade nos campos de moeda, que ao colar números decimais com vírgula ( , ), ele automaticamente transforma para o formato de ponto ( . ). Ex: R$ 2,50 --> R$ 2.50 Esse comportamento está disponível no Zoho
      • Does Mail Lite allow SMTP?

        I am looking to use SMTP access, however I am not sure what plan I have to purchase, please assist.
      • No image image comes out in the recipient when I sent an email

        Hello to the entire forum, when I send an email from Zoho, my profile picture does not come out. On the other hand, if you do, using Gmail accounts. How is it configured to leave ??? Thank you Greetings !!
      • Iphone receipt capture stopped working

        I have been having difficulty getting receipt capture to work on the iPhone app. I have been using a work around by taking a photo with my camera then uploading it into the app instead of taking the picture through the app. This adds way too much extra
      • cant receive emails

        I have checked the Dns and everything seems to be fine pls check the print screens attached below help me cause i need to solve this fast
      • IP Addresses for Whitelist

        Hi,  Where can I get a list of the IP addresses I need to whitelist for accessing Zoho Desk? TIA
      • Zoho Books API down

        We've been using the zoho books api for the last few weeks to pull open invoices, and the code has stopped working suddenly. When making the same API call as always, we're getting a 400 error.
      • Loop in Blueprint but it works. Why? How should this be set?

        see picture
      • Work Drive Tray Icon Missing

        How can I get the tray icon back? The app froze, had to restart PC and then it's been gone since...  I've re-installed the windows program and restarted my machine twice now.
      • Using Agent Email Address as From Address

        Currently, while replying to a ticket, it is possible for agents to choose their own email addresses as 'from' addresses. Although we built this just for that little extra flexibility, in hindsight, it hasn't figured much in conventional usage.  Almost all businesses prefer that responses to their customers' tickets be sent from the common support/service email address and NOT from those of individual agents. During personal interactions at events, some of you have even made passing mentions about
      • Unable to update desciprtion field

        Hi Team, perviously, we had hidden the description field on our Help Center as we used a diffirrent field to name our ticket description. Now, the description field suddenly became available on our help center and there are no option to disable it to
      • How to integrate Zoho sign with Zoho CRM

        Hi, I am starting to use Zoho sign for CRM inventory template signature collection. is there any way to fetch CRM inventory template and auto send to specific mailbox by using Zoho Sign API(or other)? I know we can click "Send with Zoho sign", but we
      • Importar datos de clientes a Zoho CRM por medio de un archivo csv o un excel

        Importar datos de clientes a Zoho CRM por medio de un archivo csv o un excel Hola necesito hacer importacion de datos desde un sistema propio. Quiero exportar datos como nombre de Cliente, empresa, venta, importe, fecha.
      • Exciting Update: Multi WhatsApp Business Account (WABA) Support Now Available in SalesIQ!

        We’re pleased to share an important update that will enhance the way you manage your WhatsApp Business accounts (WABAs) within SalesIQ. With the launch of Multi WABA support, you can now connect and manage multiple brands more effectively, each under
      • Formula field - anyway to round up/down to nearest integer?

        Hi all I'm sure I'm missing something, but how can I return the nearest integer i.e. 5.2 = 5, 5.7 = 6? Ceil and Floor round up or down... not to the nearest. Thanks BUMP Any ideas on this? This cannot be too difficult surely? Just to clarify, this is what I need to do: http://en.wikipedia.org/wiki/Nearest_integer_function BUMP!! If this isn't possible - please let me know?
      • want to create labels in radio button below the radio circle

        matrix question....labeling the radio button
      • Zoho Campaigns - Footer mis-aligned

        Hello, I'm experiencing an issue with the footer alignment in my Zoho Campaigns emails. When I create an email, the footer appears correctly at the bottom in the editor. However, after sending a test or live email, the footer shifts to the middle of the
      • Tasks not added to the timeline

        Hi, It would be nice if tasks and completed tasks were added to the timeline. Especially since there's no easy way to see if there are completed tasks without changing the default open tasks to completed tasks. Also the quick view doesn't display task
      • Contacts, Leads, Prospects, Opportunities, Deals, Oh my!

        I've implemented three CRM's in previous companies, and led the effort for two of those. I'm pretty familiar with sales pipeline management. For my current company, I chose Zoho One because of the broad range it includes for other business processes,
      • Ask Zia to update a number

        Hi, Quick question....... Is it possible to use Ask Zia to update a number in a table, for instance if I have a field with $1M and would like that updated to $10M can I do that via Ask Zia? Thanks in advance
      • Phonebridge is not visible for one user

        Hello Community, i setup phonebridge. It is working for all users in the organisation. Except for one. I uninstalled phonebridge for the user and reinstalled. But the Call button is not appearing in CRM. What could I am missing. ? Many thanks and best
      • Sorting in scorecards

        Hi Can I request the addition of a Sorting feature in the Scorecard widget? We use this to show account manager performance by quarter, or year, or whatever. It's good for side-by-side comparisons. However, it would be more useful if we could choose to
      • Implementing component filters and restoring deleted items in Zoho CRM analytics

        Hello everyone, We're thrilled to announce two powerful enhancements to your Analytics Dashboard that will improve the way you visualize and manage your data: component filters and the option to view and recover recently deleted items. These improvements
      • WORK DRIVE CUSTOMIZATION

        WORK DRIVE CUSTOMIZATION Create folder for every Case by “Contact Name “in Work Drive under Associate Deals Folder Directory: User Work Drive Accounts: Route Directory Associate Cases Case Name, Case Number Client Upload- Shared with contact (for collaboration)
      • Integration with Zoho CRM?

        Will it be possible to integrate WorkDrive with CRM similar do Zoho Docs?
      • Leads, Prospects, Contacts, Clients and Me

        I'm trying to adapt my process to Zoho and am getting confused. Here's how I did it before. Maybe it's just terminology...? Leads - anyone from any source that I might want as a client. Leads include people that I am sending emails or tapping in social
      • CRM Portal Help

        Hello, I am trying to set up a portal to connect with our referring doctors to keep patient cases organized. I set up the accounts module as office, the contacts as doctors, the leads as patients, and the deals as treatments. Everything seems to work
      • Make function for repeating code

        Hi, It's me again with my questions... 😅 In my Creator app, there's code that repeats itself in several places. And repeating code necessarily means optimization. So I'm trying to create a custom function to centralize my code in a single place and call
      • Issue with syncing zoho campaigns with zoho crm

        Hi there, I want to sync both zoho campaigns with zoho crm however i have encountered some issues with this. when clicking manage in zoho i receive this message even though im using the same account and its an admin account. however when i go to zoho
      • Filter Statuses by Project in Jira "Issue Status Updated" Trigger

        Hi Zoho Flow Team, Hope you're doing well. When using the Jira "Issue Status Updated" trigger in Zoho Flow, after selecting a project from the "Project" dropdown, we need to choose the "Status Changed To" parameter from a dropdown list. However, this
      • Does funnel chart in Zoho Analytics have an option of deciding the order of the stages of funnel in custom manner?

        I want to build a funnel chart for my recruitment process. I have data from Zoho Recruit synced with Analytics. Upon creating the funnel chart with 'Stage' in X-axis and 'distinct count of candidate ID' in Y-axis, I can create a funnel chart. However,
      • how to add time to date on a highly customized quote - where to find the customized quote

        Our highly customized quote generates on the quote the date, we want to add the time it was generated. We do not know where to find the customized quote in the CRM to do this.
      • unblock account email

        Could you please enable jperez@asociacionpataz.org.pe. Thanks for your support
      • Zoho email address not found.

        HI Zoho Team, I have created a zoho account, verifyied domail and Confihure MX record also, all are done.I have also created three email address  but now i am facing a problem that - i am able to send messages using my zoho email ids but if any person trying to reply on that mail then it gives a mail which says-"Address not found.Your message wasn't delivered to "email@domain .com" because the address couldn't be found, or is unable to receive mail."
      • Integrating Zoho Creator's Calendar Report with Zoho Calendar as App Calendar

        Hi, it would be helpful if Zoho Creator's Calendar report is integrated into Zoho Calendar as an app calendar.
      • Bigin-Zoho Projects Integration

        We're pleased to announce the Bigin-Zoho Projects integration, which enables you to manage client relationships and project tasks simultaneously in one system. With this integration, once you close a deal in Bigin, you can create a project in Zoho Projects
      • Challange in Zoho Books Integration Task - Create Record

        I am creating Customer record in Zoho books, through Workflow\Custom Functions in Zoho book. The input values are picked from custom module "cm_student_id" during edit and save events. The Customer record is getting successfully created, however only
      • Competitors When Deal Lost

        I would like to add a lookup field to deals that is only visible and only required when the deal is closed and the reason is marked as "Lost to Competitor" This lookup field would use the competitors module to allow the salesperson to link the deal to
      • User filter in Analytics Report

        We have connected Projects to Analytics so we can generate have a dashboard on task progress and completion. I've added a "User Name" user filter, with the intention that we will be able to quickly see tasks per task owner and what the statuses of those
      • Next Page