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

      • Update PDF without changing permalink URL

        Hi there, I would like to be able to update pdf files on work drive without the permalink URL changing. Is there a way to update pdf versions while retaining the same url link? Alternatively, if the URL points to a Zoho writer document, that it is viewed
      • Unable to add organization consultants and contractors in Zoho People

        Hello Team: I am unable to add my few consultants and contractors in Zoho People. How to add these people as Users?
      • How long until received item is visable as in stock when creating bundle?

        We just moved to zoho, and we notice when an item is received from a PO, it is not yet available to be used in a bundle. Is there a time delay, or some other reason it will show in stock, but not show in stock in the bundle?
      • How can we update the Inline Tax in a Purchase Item using deluge?

        Dear All, I am trying to update a Purchase Order using deluge. I can update all the fields except of the Line Tax. I would like to put 0% on it using deluge. I have tried the below but it does not work. What I have to change? Is the problem the field
      • Filter a Zoho Creator main report by a field and display other related reports in sections on a Zoho Creator page

        Hi, How can I filter a Zoho Creator main report by a field and display other related reports in sections on a Zoho Creator page? Part of what I was given below is setting up sub-reports, but the subform field prompted me to link a form, not a report.
      • Is Reverse Sync a Thing? (Zoho Campaign to Zoho CRM)

        ChatGPT said I could do a reverse sync to ensure that engagement data such as opens, clicks, bounces and unsubscribes are automatically sent back to Zoho CRM from a Zoho Campaign. I can't see where I can sync something like this. I have the other Zoho
      • Display an uploaded pdf in zoho creator record template

        Is there a way to display an uploaded pdf in a record template? Functionally I'd like it to work like the image field does. Not sure if there is a way to utilize a rich text field to do this or not.
      • View Ticket history without login

        Hi, I have integrated a ticketing system in Moodle where our users can submit tickets. They receive email notifications for replies and can respond to tickets directly from their email. However, when we add a resolution and notify the user, they receive
      • Generating Reports with Data from Unlinked Forms in Zoho Creator

        Hello Zoho Creator Community, I'm facing a challenge in creating a comprehensive report. I have multiple forms in my application, but they are not directly linked through lookup relationships. I need to generate a report that includes data from these
      • How to get data from a file that is saved on zoho work drive to then update creator app.

        So we have a few machines, and they have a consumables. There usage is tracked in a file, I would like to pull that data from the .ini file and import it into the zoho app so we can keep track of usage, is this possible with flows and how would the data
      • Modify the name of an item with Month variable

        Hello, I am using Zoho books as a Point of Sale. I am trying to change my old system, to do that I need help with the next: 1. If there is a way to have a formula in the name of the item, For example I have an item with the name of "Mensualidad" that
      • Can not edit/update lists - save/update button doesn't work

        Hello So I have a custom field in subscriber list. If I nere the email click on endit (pencil) and change the custom value to the new one, pressing SAVE button does not do anything. Also if i select multiple emails and then use the mass update feature where I change this custom value, pressing PROCEED also does not do anything. What is the matter, does it just not working, or am I doing something wrong? Browser: Chrome 65.0.3325.181
      • All Inbox emails are marked as read automatically

        Hello friends! I have and issue that all new emails in Inbox are been marked automatically as read. Plase how can I fix this??
      • Uploads API Body samples & request method

        Hi, Hope you are fine. I am request UPLOAD Api from post man its totally working fine but how could i pass all that body and headers via JS code.I am attaching images what i got in response please have a look into it. In this image i am showing the console
      • Desk Round Robin manually trigger

        Situation: During office hours I have a round robin rule to assign new tickets to specific agents. However, over the weekend and in the evening when the agents are offline the tickets are placed in the other priority. This means we have to manually assign
      • Set a different table column heading label instead of name of custom task field label

        Can we have the ability to set a different column label for task fields? See the below example, these will automatically show the same as the task field label but it would be useful for the benefit of table columns to just be able to display a different
      • How do you re-order (sort) the order of articles in a chapter?

        So you can re-order Chapters but I cannot see where and how to re-order the Articles within each Chapter... Surely this is possible?
      • Receive items from PO that has already been billed

        Rarely manufacturers bill for items before we receive the goods, but when this occurs.... {"code":36510,"message":"The purchase order(s) have bill(s) without receive(s). Hence, you cannot add receive(s)."} There is no documentation on this. Please advise
      • Auto Payment

        Hi. Is there a way to automatically take payment from the preferred payment gateway upon invoice's due date? I cant see a tick box for that, but wondering if there's some sort of Deluge wizardry that can be done?
      • Can I export a TXF (TurboTax exchange format) file out of Zoho Books?

        Hello, I'm trying to do my US Small Business Taxes using Intuit's Turbo Tax. Can I export my expenses from Zoho Books to a TXF format file, so that it can then be imported into Turbo Tax? Thanks, Rajnesh
      • 🔍 How to effectively organize data in a CRM? – My approach and questions for you

        Dear ZOHOssians! While working on organizing data in a CRM, I decided to use the native modules: Leads, Deals, Contacts, and Accounts as a solid foundation for managing processes. However, I’m now exploring the next steps and considering various options
      • Change an existing email name

        Can you change the name of an existing email address I have under my account?
      • Request for Assistance with Script for Updating a Custom Field in Accounts

        Dear Zoho Support Team, I have created the following script, intended to automate the update of a custom field called kontrolka in the Accounts module based on data from the Leads module. Below is the script: // Get the account ID from the Lead var accountId
      • Zoho CRM - How to get Lead Timezone ?

        We are connecting Zoho CRM to our Website lead form (Wordpress JetBuilder). We have field for Date/Time selection to book a Free session with our Business. We need a way to get the lead timezone, so we are able to set the free session time correctly on
      • Default value from global set not working if leads comes from Whatsapp

        I have field called 'Marketer' and I have set default value from global set like this if it is created manually by pressing 'Create Lead' button it works without problem, but the leads created automatically from Whatsapp (Business Messaging) the 'Marketer'
      • How to print all tasks

        I want to print a report on tasks status
      • Team does not exist error when sending emails. I can not even contact support as I can not send emails. I am the admin or the org and all is fine I belive.

        title
      • Access custom view for Boards module - Qntrl app update

        Hello, everyone! In the latest Android version(v3.0.8) of the Qntrl app, we have brought in support to access the custom views for the Boards module. You can also mark a view as favourite by tapping the star icon next to the view name. The views that
      • Service Module: Multiple time duration choices on service

        Hi. I just discovered the Service Module in Zoho CRM. While defining my first service, I noticed that I can't select multiple durations. My services have booking choices for 1-6 hours. Is there a way to select multiple durations that I'm missing?
      • Zoho one and multiple organizations

        So in my company we have been using zoho for i guess 8 years. Brilliant 99% of the time. I also am the chairman of an industry association and i have suggested we stop using my zoho one and that they get their won subscription. So my question is as i will be the main user on both am i going to have problems. I understand fully that the apps will only work on one account but is there any other gotchas.
      • Antique market software

        We run a small Antique market event company in the UK . we want software that will file online bookings into the right venue folder , send out remainder invoice for unpaid bookings , send out conformation emails and other accounting tasks .
      • CRM email

        Our CRM email automatically adds myself to the TO: (email address) How do I change that to pick up another field?
      • Pages load very slow

        Does anyone else experience 10+ seconds of page loading?
      • Please add option to set meeting duration

        Right now there is no way to create a meeting that is longer or shorter than one hour.  Right now I have to create a 1 hour meeting, then send out a very quick change in Google Calendar to say that the meeting is 30 minutes.  This looks unprofessional of me, and can cause my customers to decline a meeting that overlaps with other meetings they have, since they think the meeting is 1 hour long. Please give options at least for 30 minute meetings, and allow for 30/60/90/120 minute meetings.  Is that
      • Currency conversion formula in table

        Is there any way to convert a figure in a table from USD to GBP? I can't find a formula to be able to do this...
      • Creator Simplified #12: Track the no.of button-click downloads

        Hey Creators! We're here with yet another episode of Creator Simplified for you! In this post, we'll see a workaround to count the number of button-click downloads made in the report. Usecase In a training app, students can download the course material
      • Profile photo not syncronized in Zoho Recruit - Zoho CRM syncronization

        How come, profile photos (candidates, contacts, and accounts) can't be synchronized between Recruit and CRM? Surely it can't be a technical problem? Is there some solution that I haven't noticed?
      • Check for new emails period

        Hello. We are currently using our own mail server and Zoho Mail as a client through IMAP. Users have frequently complained about the 3 minute frequency when checking for new emails, finding that waiting 3 minutes for a new email is too long. We are considering
      • Webinar - Getting Started with Landing Page Marketing | Zoho LandingPage

        Ready to build your first landing page that actually converts? Landing pages are a powerful marketing tool—but only if you know how to use them correctly. In this webinar we’ll dive into everything you need to know about creating landing pages that capture
      • Stock (on-hand) Items not updated after using Composite items

        Hi there, I created a Composite item (consist of 3 items). After I created the Composite item, I invoiced it and shipped the items. However the actual stock on hand of the 3items didn't change at all. Have you guys encountered this? Thank you Regards,
      • Next Page