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

      • 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
      • Access of Activities Module in CRM to Client Portal?

        I want to enable access of Activities Module in Client Portal of my CRM to my Clients but not getting option to choose the module. By doing this I aim to give the access to the clients to their realtime status of the work going on and they can track the
      • Is there a quick way to copy the contact details for a Zoho CRM contact?

        This has probably been asked lots of times before, but I couldn't find an answer anywhere - Is there a simple 'one-click' way to copy a contacts details from Zoho CRM, so that you can paste it into an email or word document? All I need is to grab 'business
      • ZOHO Expense API Documentation - Can't see anything about Purchase Requests

        Hello, I am reading the API Documentation for Zoho Expense but can't see anything about Purchase Requests - This is one of the modules we use the most. Has anyone had any luck getting Purchase Requests data from Zoho Expense via API? Thanks,
      • KPI Widget - last month sales vs same period last year

        I would like a KPI Widget that might compare data with the following date ranges: This month to date (meaning all of February through the current date, for example the 14th, if today was the 14th. So Feb 1-14th 2018)vs. last year this month to date (Showing
      • Salesiq zia skills

        We have built a bot using salesiq codeless bot builder. So now, we would like to utilize Zia to enhance our bot by providing relevant information fetching articles from Zoho desk knowledge base. How to achieve this, maintaining the existing workflow cards
      • Restrict Past Date in Zoho CRM Module

        How can I restrict from selecting a previous Date? I want only future dates to be selectable
      • Add tasklist from a template to Zoho Project using Deluge

        I have some tasklist templates that I want to be able to add to a project under certain circumstances. So if a project meets Condition A, add the tasklist from Template B to that project. If it meets condition C, add tasklist from Template D, and so on.
      • Zoho Flow custom functions "Error occurred while processing this request. Contact support for more details"

        Any ideas why this is happening? Zoho Flow custom function...
      • I need to add difference for Average Row at the end

        (Confidential data hidden here) Guys, hello! I have this graph, it calculates the averages of Retention and then shows the delta (2024 - 2023). In the 3rd column with delta Churn %, I want to show the difference between averages too, which would be (16.99
      • No encuentro la opción para crear una orden de compra

        No encuentro la opción para crear una orden de compra, soy nuevo, ya busqué tutoriales, pero no me aparecen dichas opciones.
      • Post on behalf of employees as well as business socials

        Is there a way to give our sales team access to social to add their own LinkedIn accounts, so that when we schedule business posts, we can also post on behalf of them at the same time so they don't have to repost etc.
      • Alignment of Company Information Page Structure in Zoho One and Zoho Desk

        Hello Zoho One Support, We appreciate the continuous improvements across Zoho products. Recently, Zoho Desk restructured the Company Information page into three distinct sections: Company Profile – Includes Company Name, Logo, Alias, Description, Website,
      • Trying to setup a record to automatically create on a weekly basis

        Hello all, I need multiple records to be automatically created on a weekly basis. What I'm trying to accomplish is, I have a maintenance database where I track when I work on IT related systems. Every week on the same days I perform backups on systems
      • Sheet Access

        How do you set a spreadsheet to only allow certain people to access certain sheets? Like if I wanted to have someone view one sheet that pertains only to them, they can't see the other sheets on the spreadsheet while allowing someone else to view theirs but not others.
      • Automate posting to job site boards via Deluge/ or Schedule

        Hi Zoho Recruit Community, I'm working on automating a recurring job posting for a long-standing labor hire role that we update monthly. Right now, I can automate the creation of the job opening using scheduled tasks and Deluge scripts. However, the challenge
      • How To Sync 'Deals' data To The Related Contact In The 'Contacts' Module

        Hi there! I'm looking to be able to sync Deals and Contacts. Basically, when someone places an order we have it syncing the order data to Deals, complete with the customer's name and email. Is there any way to have that Deal synced to the matching contact in the Contacts module? Presumably matching by email address. I'm familiar with Workflows, however it doesn't seem that Workflows work across different modules. We're looking to be able to run reports based on what the customer bought, but can't
      • Zoho CRM Appointments and Services

        The Appointments and Services modules are nice but very limited. Is there any chance that Zoho will make these more customizable or expand the fuctionality? Appointments Allow "Appointment For" lookup to the Deals module. For us and I'm guessing others
      • How to upload image from Creator field to CRM File Upload Field or Module Notes section

        Hello,  How can I upload an image from Creator Image Upload Field to CRM Module Image field (or Notes section).  The file upload field type would also work. I just cannot seem to find a way to upload the images from one application to another. Case: Field record requires images as part of the report. I would like the image from the field record form in Creator to be uploaded in the CRM as well as.  All of the other fields from the Creator Field Record Report work perfectly. Thank you very much for
      • Unable to pay bill from Prepaid Expense account

        Our transport vendor requires us to use their prepaid system.  We have paid R1150 upfront into the Prepaid Expenses account: As we use their services, we get billed.  These bills must obviously be settled by from our prepaid account.  I am unable to record
      • Unable to import data into zoho analytics using the post man APIs of udemy for business

        Hi Can some one help me with the following Unable to import data into zoho analytics using the post man APIs of udemy for business through API beta feature, I have created the sample report in zoho analytics through the table structure but i am unable
      • errorCode":8504. What is wrong with my CONFIG?

        I can't determine what is wrong with my config. It worked properly until I added an additional field, but the additional field is just a number and shouldn't effect the config. I am attempting to do a bulk update add to an existing table based on this
      • Analytics report issue

        Hey, does anyone know why suddenly our Analytics report goes blank whenever we add a field from the contacts module? It shows when adding fields from all other modules. Thanks.
      • COST CENTER

        Hello, Is it possible to add cost centers.
      • High cpu load on client side by process sessionaudit.exe

        Hi, as stated above. This happens every time with different clients. Now, the first thing I have to do after making the connection is to go to taskmanager on client computer and kill the process 'sessionaudit.exe' If I don't their cpu is very high and
      • Urgent - issue with VAT registration

        Im trying to enable VAT but it wont let me add my company VAT details. I'm getting this. Please disable Adjustments and Entity level discount before registering for VAT How do i do this as i cannot find answer. It would be nice if there was a help icon
      • No Updation of manual journals in case of Accrual basis of Accounting

        Hi Readers, Please help with a query of mine, Actually I am not able to see any of the transaction updated in the manual journals, if i view a the report(Balance Sheet) in Accrual format. Like the transactions which are to be there even in accrual basis
      • Excise Tax for Oman

        We are a long time user of Zoho for multiple businesses. We have now started a new business division which is trading of beverages. This product however has an import excise tax (50% of assessed excise value) and sales excise tax (50% of invoice value).
      • NEW TO ZOHO

        I am transferring from company accounts which are being recorded in written book keeping method. I have stocks which are purchased in cash some by credit from vendors. I have datas from pervious year like total sales and purchases etc In future i will
      • Member Portal with Subscriptions

        We are a subscription box business using Zoho One.  How do our members login to make changes to their subscriptions, contact details, etc.  Is there a portal?  If not, what should we do to create one?  Also, we must be able to customize the portal with tabs and custom fields.  Finally, we need form and survey information to show up in the portal with some items editable and others read only.  I really need this information soon.  Thank you! Paige
      • GROUPING OF CUSTOMER

        SIR PLEASE ADD GROUPING OF CUSTOMER IN ZOHO BOOKS
      • Convert Sales order to Delivery Challan

        Dear Developer Team, In Zoho books we cannot convert sales order into delivery challan before making invoices. As a service business we have to get the delivery note signed then only we can make the invoice. In Some cases we don't receive a purchase order
      • Why does a field dependency auto choose the 1st field in picklist when set as mandatory?

        I have a pick list in the cases module called "Warehouse" with 2 options DC 1 or DC2. I also have a field dependency for Case reason = Mispick which will make the picklist a required field however the picklist auto defaults to DC1 (Even though the default
      • Cost Center accounting

        Hello all. We are looking at switching from MYOB to Zoho books. Love all the features in books - esp. CRM integration, but the big gap for us is the lack of cost-center accounting feature. Are there firm plans to develop this feature in Zoho Books? If
      • [How-to with Example] Getting field value/data in Client Script from lookup field record

        Imagine you have a field you would like to prefill a field based on a value from another record in another module. In this case, we are looking into a scenario where an Asset (custom module) module is being created from a Deal module. Meaning, there is
      • Shopify to Zoho Books Integration

        I have had to go ahead and disable my Shopify integration entirely.  When a Sales Order comes in from Shopify, it lists the shipping charge as a line item with no SKU attached to it.  As you are not able to edit a Sales Orders that comes in from a Marketplace,
      • Using functions in Zoho CRM Circuits, howto and solution

        So, I don't know if anyone has tried this yet but Circuits can be a pretty powerful solution to process data and get the job done in a more structured way. However Circuits are not that easy as it looks. One of the problems that we had to overcome was
      • CRM 'Connection' to Desk - "Use Credentials of logged in user"

        From Desk to CRM, I can create a Connection in Sigma (to CRM) that gives me the option to Use Credentials of logged-in user. In CRM, there is a separate option in setup for 'Connections'. As there is no specific Desk connector, I can create a 'Zoho oAuth'
      • Next Page