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

      • Experience sharing - creating quick prototypes to align understanding

        Curious to hear from developers in this community - How do you create a prototype of Zoho CRM customised changes quickly with little coding so that you can validate your idea and requirements with stakeholders? The latest method I have found still requires
      • All notes disappeared

        I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,
      • How to bulk edit on subform field

        Hi, It seems impossible to bulk edit on subform field. Is really it impossible? The subform field is well shown on view, and we can search as criteria, but the field doesn't appear in "bulk edit" dialog. Is there any other way for add the same subrecord in all records of a view? Thank you very much, Bernat
      • Bar Charts in Zoho CRM

        Hello, We are using the Analytics section in Zoho CRM (not Zoho Analytics). We created two bar charts using a workaround with LinkMatch: each time we send a message to a lead/contact on LinkedIn (not on Sales Navigator but the “normal” LinkedIn”), a new
      • Sending two different reports through one e-mail schedule

        Hi. I have two different reports which I want to send to someone. However, I don't want two separate emails, but only one. Is this possible?
      • Is there a way to see the code in parallel to what you are creating.

        So when you are creating a form, or making layout changes you see what is happening in the code. Similar I guess to some website editors, thanks
      • Help with filtering Contacts from Accounts based on third module

        Community I need some advice. There a small thing that is a big stone in our shoe. So we have three modules Accounts, Contacts, Assets. They are connected Asset > Account Contact > Account I want to email all Contacts from Accounts that have Asset. Right
      • WhatsApp phone number migration

        Hi @Gowri V and @Pheranda Nongpiur, Thanks for implementing the promised enhancements to the integration between Zoho CRM and WhatsApp. The previous discussion has been locked, so I'm opening this new one. I am copying below a specific
      • WhatsApp For Zoho Commerce

        Team: Right now all trigger based communications happens via emails. Emails are outdated and now customers wants to interact with a business through whatsapp. Does zoho commerce support whatsapp based communication?
      • Launching Snowflake Integration: Streamline Contact Management in Zoho Marketing Automation

        Hello Marketers, Here we are yet another addition to Zoho Marketing Automation, integration with Snowflake. This integration is designed to streamline your contact management and enhance your marketing efforts. Let's dive into the features that come along,
      • Possible to disable "Quick Create" option for new record creation?

        Is there a way to disable the "Quick Create" option for creating new records? Some of my layouts are heavily reliant on conditional layout rules and these don't work when in the "Quick Create" mode. It's very annoying and confusing for the end users to
      • Manage Approvals like Never Before: More Control and Flexibility in your Approval Processes

        Hello Everyone, We hope you are doing well! We are here with exciting enhancements to the approval process of Zoho CRM. The updates provide greater flexibility, transparency, and control over record approvals, empowering you to ensure the right data enters
      • Enhance email sending for custom functions in Zoho Connect

        Dear Customer, We would like to share an important update to how emails are sent via Custom Functions (Deluge) in Zoho Connect. What's new? To improve security and email deliverability: The From Address in the Send Mail task used in Custom Functions must
      • How to Check if the Access Token is expired?

        Hi Zoho CRM Team, I want to ask if there is a way or if there is an API to check if the access token is already expired. This is to avoid having several active access tokens. I really appreciate any help you can provide. :)
      • Zoho Recruit is coming to the UK | Zoho Community Learning Series

        Customers from the United Kingdom, Exciting news: We will be in London for the Zoho Recruit user meet up. Our team will help you better understand the intricate nuances of Zoho Recruit to help you hire faster, inform about new and upcoming features, and
      • Workaround for Backstage's non-compliant cookie banner

        Hi Does anyone has a workaround for the cookie banner Backstage uses when you publish an event? Currently there is no "Decline All Cookies" button, only "Accept All" and "Customise". Which means it is not compliant with data protection requirements, as
      • [Free webinar series] Get to know Deluge: Zoho’s powerful scripting language

        Hello Everyone, We are much elated to invite you all to our upcoming session in Zoho Deluge! Bringing on to your table - Get to know Deluge: Zoho’s powerful scripting language Understanding Deluge Zoho’s suite of applications offers robust solutions for
      • Mass Update a Lookup Field

        How is it after 10 years this still hasn't been implemented? I have 2,000 records that require a lookup field updating and I can't possibly do it manually one-by-one...!
      • Batch Download Completed Documents in Zoho Sign

        I have thousands of completed documents that I need to download. There has to be a better way than individually clicking on each one?
      • Relation name issue with getRelatedRecords

        Hi, I'm puzzled because of the following. I have custom modules Participants (CustomModule5) and Departures (CustomModule1): a Contact can be a Participant in multiple Departures. Participants used to be called Passengers; it was renamed to Participants
      • Uploading file to workdrive from creator

        Hello I am trying to upload a file from creator into my zoho workdrive but it does not seem to be working.  A file does get uploaded but there is nothing when I try to look at it and just gives an error message saying "We couldn't generate a preview due
      • How do I delete survey responses (Customer Happiness)

        Hi,  I need to remove dummy survey responses (those I created during evaluation period), and invalid ones - responses received from Cancelled tickets - which is a custom status we use to close spam, duplicate, or internal emails. I cannot find anywhere to remove them, and one of your chat agents suggested to remove the response provider (contact).  I'm not inclined to do what was suggested as there could be valid responses from that contact, so kindly provide another option. And I did try that too
      • Setting value while adding new entries to lookup field

        I have a question regarding this process: https://help.zoho.com/portal/en/kb/creator/developer-guide/forms/add-and-manage-fields/articles/fields-lookup-allow-new-entries If I set a value for a lookup field while adding new entries, and the form it looks
      • product registration module / warranty

        i need someone who can create a online/product registration module for me. Our website is based in wordpress. We need our consumers to register their product and should they need to make a warranty claim, do so online as well. One way to do this is to create using zoho creator - Registration Page o To have normal information fields o Attach scanned proof of purchase o product purchase details o Point of purchase details o Database back end for all the information. o Access to database (view or download
      • Product Registrations via Zoho CRM

        Hello, I would like to have a public page, where users can enter product registration details.  This needs to be many-to-one (registrations-to-contact).  I tried the CaseToWeb Form.  It adds a Contact and Case, which is fantastic.  However, it will only let me add a few details on the Contact such as Name, Phone, Email.  I also need the ability to add address, city, state, zip fields. Has anyone tried this before? Thanks, Brian
      • Email Alert attachments unavailable for Vendor Payments

        I have several vendors with country specific compliance requirements to support the payment of their invoices. I've created Vendor Payment templates to meet their requirements and I setup an automation workflow that gets triggered when the invoice is
      • W-9 Upload Limitation (250 kb) is Too Small

        Nice touch to add a system field to deal with W-9 forms for the US. However, the system limitation of 250 KB is way too small for this. Because the form must be signed, many (most?) vendors use a scanned form, and those are always larger than this. While
      • Incorrect Shipping cost calculation - Zoho commerce Shipping method

        Hi, there seems to be some issue related to logic used in shipping cost used. Consider the below case: For an item of 100 grams, I expect it to be 75 rupees as that is what I have given in the condition. But it calculates 0.1x75 = 7.5 rupees which is
      • Add "Merge by Ticket ID" Option on Ticket Screen

        Dear Zoho Team, We would like to request a new feature for the ticket interface in Zoho Desk. Specifically, we propose adding a button to the ticket screen that allows users to merge the current ticket with another ticket by directly providing the second
      • Invoices using purchase account instead of sales account from Items

        We're running into an issue where invoices created from bills are using the purchase account on the journal entry for the invoices as opposed to the sales account. In the screenshot examples you can see that the sales account is janitorial services but
      • Function deleted after releasing connection in Kiosk

        Hi Everyone I create a Function (Automation) and link it in a Kiosk Workflow. Later, I decide not to use this function from Kios anymore, so I delete the entry in the Kiosk Workflow and publish the new Version. Problem 1: The Function remains linked until
      • Help with Formula to Calculate Remaining Days from Due Date in Zoho CRM

        Hello, I am working on a Zoho CRM formula to calculate the remaining days from a Due Date field. My goal is to display the number of days left from today to the Due Date. I have tried the following formula, but it is not working as expected: plaintext
      • [Free Webinar] Learning Table Series - Creator for the Healthcare Industry

        Hello Everyone! We're thrilled to invite you to the Learning Table Series—a year-long initiative to demonstrate how Zoho Creator can transform industries with innovative and automated solutions. Each month focuses on a specific industry, and this time,
      • Change lead status via url parameters

        Hello, We have a lead generation form on our website and and we received an email when the lead is generated. This email contains a link to the lead in CRM. Does CRM have built-in parameters so that I could have a link in the email that also says junk?
      • Sorting Grouped Records by Last Opened

        So, I have a form. For simplicity, lets say that this form only has a job_name field, a room_name field, and a order_number field. (the order_number field is to input a number for sorting purposes) On the report, I have it set to group by job_name, and
      • Tracking new lead response time

        Hi, I have a team of Sales Development Reps, who have a KPI of responding to a lead within 20 mins or less once it hits the system.  I seem to recall that Zoho CRM had the capability to track this in a previous version, but don't see it anywhere.   It's
      • Request for access to domain "palmonteproducciones.com" for DNS server configuration

        Dear ZOHO team, I hope this message finds you well. I am reaching out to request access to the domain "palmonteproducciones.com," as we have contracted hosting services with a local provider and need to make changes to the DNS server configuration. We
      • Fake Zoho One dashboard

        I noticed on the Zoho One splash page, an absolutely gorgeous dashboard that beautifully shows the concept of Zoho One, bringing all of your business functions together under one roof. Problem is, it's a fake dashboard. We can't create a dashboard like
      • Sending Estimtes to approval from CRM Finance module

        Hi, This is the second time I'm facing this user experience problem. I hope you might give some insight on how to either do or explain colleagues / clients. A sale person is responsible to create an estimate for a deal from the CRM. However the estimate
      • Plug Sample #5 - Read and write values/data in a Google Sheet with Zobot

        We all know google sheets are one of the widely used spreadsheet software. It helps us to make data-driven decisions. When connecting the Zobot with sheets, the bot can display values/data from a spreadsheet, like the available stock details (Item price,
      • Next Page