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

      • Attendance Over-writing of Leave

        Hello Zoho, Currently if an employee comes to work while they have applied for leave, the system considers them as "on leave". Shouldn't the employee be marked as "present". Give it a thought
      • Deals sync for Campaigns or Marketing Automation...

        We are looking to create a marketing campaign based on a custom "expiration date" field inside our DEALS module. We are open to using either CAMPAIGNS or MARKETING AUTOMATION but haven't been able to get either platform to sync the specific fields we
      • Building extensions #2: Publishing an extension

        Hello developers, Welcome to our next post about building extensions for Zoho Finance Suite applications. In our previous post, we looked at extensions, their purpose, and how to create and test them. To recap, extensions are installable plugins or add-ons
      • Is it possible to select the methods of inserting a signature (Not provider)

        Hi, I tried to search through the help pages and application interface trying to find if there's a way to limit the assigned signees, for example, allowing only images or drawing, and disallowing the automatic signature creator as per their name. It'll
      • Issue with Attachments in "Email a Thank You Note"

        Greetings, from a few days ago, when registering a new payment and clicking on 'email a thank you not for this payment', Zoho Books does not send anymore my attachments on this email, as before. It is very important to us, once here, we have to send another
      • Zoho Learn - Public Courses

        Hi guys, How can a non Zoho user enroll for a public course? cheers
      • Problem with delivery status in delegate account

        Hello, We have a problem with delivery status in "sent" folder in delegate account. Some messages has no status, some messages has "waiting" status, Some messages are delivered, some messages are delivered wit delay, some are not delivered. Conclusion:
      • Decode user intent and behavior patterns with Zoho PageSense Session Recording

        Hello there, Join us in our upcoming webinar and learn in-depth about how to tackle conversion challenges with PageSense Session Recording. Session Recording is a powerful function that lets you record, re-create, and gather user interaction insights
      • Zoho's biggest issue is unaddressed - Slowness

        I am sure most people reading this post also experience the very slow response times of Zoho CRM.  If you read the hundreds or thousands of posts on the topic...you will see that Zoho tries to take each poster offline to solve their problem as if it were a web browser tuning issue.  It is not a web browser tuning issue, it is very certainly a symptom of not purchasing enough server infrastructure (whether its the IP pipes, Disk I/O, Server I/O I don't know) which is probably a symptom of not charging
      • Need best practices and ideas for group calendars or personal calendar with group invite

        Please share your ideas and best practices to use Calendars. Here's the situation. Using a group calendar to hold weekly recurring meetings for the "Design Team" means that Design Team members can easily view/hide the calendar. However, it also means
      • Is the a way to show the actual Zoho Books Invoice in Zoho Crm Deal ?

        Im currently using the following code to create deals and tasks based off a new quote in zoho books, the problem is the quote is created under Accounts in CRM in the Zoho FInance Module, so when the deal is created it does state the amount of the quote
      • Bulk Delete / Archive

        For me the Bulk delete and archive functions are not working anymore reliable. I get the message that the action is scheduled, but often it is not executed not even minutes later. To me, the user experience became terrible in the last month. It used to
      • Error 0x800CCC0F Sending and Receiving

        This seldom used XP PC using Outlook Express has been using this Zoho email account for years with no problems. It just started getting this error when sending and receiving email. Nothing has been changed, upgraded, etc. No change with completely disabled
      • Introducing more ways to customize your Bigin forms!

        Greeting, I hope all of you are doing well. We're happy to announce a few recent enhancements we've made to Bigin's forms: You can now effortlessly gather contact and pipeline data. We're also improving the user experience with enhancements to design
      • Google ads - zoho crm integration problem

        dear zoho team we were starting to use google ads integration with zoho crm years ago.  but till April there was an error. we can see GCLID in zoho crm but we couldn't get any information from google ads. (keywords campaign name etc) is there any problem
      • Feedback Setting in Zoho Learn

        Hi everyone, I’ve encountered an issue with the feedback settings while creating quizzes in Zoho Learn, and I’m hoping someone can help me figure out a solution. Feedback Swapping Automatically: When setting up feedback for right and wrong answers, I
      • Post to Bot doesn't work for Clickup extension

        I correctly configurated the extension but i don't received the notifications in my bot when a task has an update. Can you help me?
      • What takes from the inventory quantity

        There are several options SaleOrders, PurchaseOrders, Invoices... which ones disminish the Inventory quantity of the product? Does the change occurs online?
      • Show or hide a field based on the value selected in another field?

        Can this be done in CRM? If not and can only happen in Creator is there a way to combine Creator and CRM without paying for 2 accounts? Thanks in advance for your response(s). Moderation Update: I'm locking this post since a solution has been provid
      • Default account for service invoice

        Hello, My client has some invoices for which he has entered a service description rather than using an item.  Is there a way to set the income account on this invoice, or can that only be done by using an item?
      • Extracting data from ZOHO through API

        How can I extract the invoice and bill reports from ZOHO through API? I have to create a dashboard in Power BI and we do use other software too for accounting, so to get all data from different software in single place I need the API.
      • Tip of the week #42- Filter out suspected spam emails before they reach your team's inboxes.

        Are unwanted emails cluttering your inboxes and exposing you to potential threats like phishing and malicious content? The antispam feature in Zoho TeamInbox gives you the perfect solution to keep your inbox organized and secure. By adding trusted email
      • Questions about ZohoCRM's portal features

        thanks for the care from you every time. I have a question about ZohoCRM's portal feature. Products are displayed to the customers invited in the standard portal, but the products and prices to be displayed differ depending on the segment of the customer.
      • Contact details when no answer in Chat

        Hello, it would be great to have a feature that when no one is answering in the chat for lets say 60 seconds ... the user gets a meesage to enter his email and we can follow up later. Now we can have only prechat forms ... which can loose potential clients
      • Customer Display Name

        The Customer Display Name defaults to only the first name.  Is there a setting to make it default to display both the first and last name? Thanks, Bryan
      • How Good Is Mail Search?

        I am thinking of switching to Zoho hosted mail. I have approx. 1.3G of mail in many hundreds of folders organized hierarchically. It goes up to 7 layers deep. I have to often pull up messages from previous years. Would I be able to search the entire content by using Zoho search? Right now I use an IMAP account. My desktop client is Thunderbird, the server is MailXchange hosted by 1and1. The server allows a multi layer structure, but the search function is useless. Because of that I have to use TB
      • Problem when condition with lookup field in Zoho Creator

        this is my code: if input.promotions1 != null { info input.promotions1; } And this my result: when i info input.promotion1 (which is a lookup field), it turn back nothing, so what type of this field is? normally i use the condition: if lookup_field ==
      • Integrate WordPress site as a Knowledge Base for Zoho Desk Suggested Articles

        Dear Zoho Desk Support Team, We'd like to propose a feature enhancement for the Suggested Articles system within Zoho Desk. This feature would allow seamless integration with a WordPress knowledge base, enabling relevant article suggestions for agents
      • Error 403 (forbidden) when using get ticket API on a ticket in a new department

        Hi We use get ticket API and it works well. We created a new department and when we try to use the same API on the tickets from this department, it fails with the error: b'{"errorCode":"FORBIDDEN","message":"You are not authorized to access this resource."}'
      • Calculation of depreciation

        Can we add the feature of calculating the depreciation on assets as the year-end and mark a journal once done?
      • The current Account Name is amt-lubricatingoil.com, and I would like to change it.

        Hello, my current Account Name is a***********l.com, and I would like to change it to w*******x.com. Thank you!
      • Zoho Analytics - CRM Sync Failure

        We have experienced consistent sync failures between our Zoho CRM and Analytics apps, but there aren't any details provided as to why this failure might be occuring. Please advise on troubleshooting steps so we can figure out how to restore the sync.
      • Select Invoices by Date Range

        Is there anyway to select invoices by date range then print them in bulk?   Now I have to go and click on each invoice I want print and usually it opens up an invoice (because my cursor in wrong place) .   I would like to select only invoices for April and then print them in bulk.  YOu need this feature in most of the areas
      • "Reply to" email address issue

        On the New campaign page, you select or add a reply to email address.  It sends a verification email to that email address. But my recipient had a filter on and never go tthe email.  Now he removed the filter, but campaigns says verification email already was sent.
      • [Client Script] How to get selected related record Id

        Hi Zoho, I set an client script button in related record list. We would like to fetch the selected record id/field for further action. But I don't know how to get the selected id. If there is not possible to get related record info, then what does the
      • SalesIQ and Zoho CRM integration - stop real time contact creation

        Hello everyone, I am facing a lot of problems when a salesiq chat goes to zoho crm. As the chat answers travel in real time to the CRM, the automations doesnt work well as they pick the first answers recieved, not the final form in the chat. Is there
      • Now Indian Businesses can start accepting online payments with Zoho and Razorpay

        Hello Everyone, At Zoho, we have always ensured a hassle-free online payment experience for our customers. Today, with our integration with Razorpay, Zoho's customers from India can now offer a seamless checkout experience for one-time and recurring payments, with a host of payment options including card payments, multiple wallet offerings, and net banking with over 50 banks. With Zoho and Razorpay, help your customers pay their way. Whether it's with debit cards, credit cards, wallets, or net banking,
      • Duplicate Column Data with Individual Filters

        Is it possible to create a report using the Zoho Desk Connector which would look something like this: | Account Name | Ticket Count (filtered by department 1) | Ticket Count (filtered by department 2) | For Example: Where Dept. 1 = Support Tickets, and
      • External E-Mail to approve Form

        I am currently setting up a form to apply for a member discount. To do this, the entry must be confirmed by the external partner of which the person completing the form is a member. Is it possible to enter an external email address as approval or is this
      • Job Opening Fields - Rich Text

        I migrated to the new version (4?) of ZoHo Recruit.  I am trying to add a new field to my Job Openings layout and I want it to be a rich text field (just like the field I am typing in right now) so I can format the text, instead of just entering plain text.  I know the rich text field exists because one of my existing fields (Job Description) migrated over as a rich text field.  But I don't see rich text as a choice in the field type menu.  Or, I would like to change the field type on an existing
      • Next Page