Dynamically Filter Lookup Options Based on Another Lookup Field's Selection | Zoho Creator Help

Dynamically Filter Lookup Options Based on Another Lookup Field's Selection

Requirement

Automate the creation of portal user accounts based on the email entered in the Zoho Creator form.

Use Case

Consider an IT asset management application on which an organization relies to register and monitor assets assigned to employees. When an employee needs to initiate a request for an asset, they must use the asset request form within the application. This form incorporates dynamic filtering of lookup field options based on the value selected on another lookup field. The first lookup field allows the employee to choose the category of the asset they require, such as software, hardware, PC, or mobile. Once the user selects a category, the second lookup field dynamically filters assets based on that selection.

Steps to Follow

  1. Create two forms with the following details to record asset details.

    Form Name

    Form Link Name

    Field Type

    Field Name

    Field Link Name

    Asset Category

    Asset_Category

    Single_Line

    Category

    Category

    Register Asset

    Register_Asset

    Lookup
    (Asset Category)

    Category

    Category

    Single Line

    Asset Name

    Asset_Name

    Single Line

    Operating System

    Operating_System

    Single Line

    Manufacturer

    Manufacturer

    Single Line

    Serial Number

    Serial_Number

  2. Create another form with the following details to record employee asset request details.

    Form Name

    Form Link Name

    Field Type

    Field Name

    Field Link Name

    Asset Request

    Asset_Request

    Single Line

    Employee Name

    Employee_Name

    Email

    Email

    Email

    Lookup
    (Asset Category)

    Category

    Category

    Lookup
    (Register Asset)

    Asset Name

    Asset_Name

  3. NotesNote: In order to autofill the Email field, select the Initial value as zoho.loginuserid from the field properties as shown below.

  4. Select Set filter under the choices from the field properties of the Asset Name field.

  5. To filter the Asset Name lookup field based on the Category lookup field input, set a filter on the Asset Name field to list assets that match the ID with the selected value in the Category field. In the Set Filter pop-up, opt for ID under Asset Category as the field and choose equals as the operator. Enter input.Category as the value.

  6. Head to the live mode of the application and access the Asset Category form. Input the relevant values to categorize your assets. In this instance, we've included four records: Laptop, Mobile, Hardware, and Software. These categories will be available for users to choose from when registering or requesting assets in the other two forms.

See How It Works


  1. Manage filter


        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                Mobile App
                                Form DesignerHR
                                Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                Wufoo alternativeSecure Forms

                                TypeformWCAG


                                    All-in-one knowledge management and training platform for your employees and customers.

                                              Create. Review. Publish.

                                              Write, edit, collaborate on, and publish documents to different content management platforms.

                                              Get Started Now




                                                                You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                                    Manage your brands on social media


                                                                      • Desk Community Learning Series


                                                                      • Digest


                                                                      • Functions


                                                                      • Meetups


                                                                      • Kbase


                                                                      • Resources


                                                                      • Glossary


                                                                      • Desk Marketplace


                                                                      • MVP Corner


                                                                      • Word of the Day


                                                                      • Ask the Experts


                                                                        Zoho Sheet Resources

                                                                         

                                                                            Zoho Forms Resources


                                                                              Secure your business
                                                                              communication with Zoho Mail


                                                                              Mail on the move with
                                                                              Zoho Mail mobile application

                                                                                Stay on top of your schedule
                                                                                at all times


                                                                                Carry your calendar with you
                                                                                Anytime, anywhere




                                                                                      Zoho Sign Resources

                                                                                        Sign, Paperless!

                                                                                        Sign and send business documents on the go!

                                                                                        Get Started Now




                                                                                                Zoho TeamInbox Resources





                                                                                                          Zoho DataPrep Demo

                                                                                                          Get a personalized demo or POC

                                                                                                          REGISTER NOW


                                                                                                            Design. Discuss. Deliver.

                                                                                                            Create visually engaging stories with Zoho Show.

                                                                                                            Get Started Now








                                                                                                                                • Related Articles

                                                                                                                                • How to display images dynamically on a subform row based on the lookup field selection

                                                                                                                                  The images stored in a form can be retrieved and displayed dynamically within subforms. When users select a record from a lookup field in a subform row, relevant images associated with that record can appear in a designated rich text field within the ...
                                                                                                                                • Auto populate a field based on the selection from a lookup dropdown

                                                                                                                                  Requirement   When a value is chosen from a lookup dropdown, related values are populated in the other fields of the same form. Use Case   An order management app contains a form to store order details. When the admin chooses the customer name from ...
                                                                                                                                • Filter report using dynamic values from a function

                                                                                                                                  Requirement When a user accesses a report, data is filtered based on the logged-in user's role so that only the required details are visible to the user. Use Case An employee management system has two forms, Department and Employees. The Department ...
                                                                                                                                • Integration field

                                                                                                                                  In a nutshell An integration field in Zoho Creator is a special field that allows you to look up data stored in external services (other Zoho apps or third-party tools). It appears as a dropdown that fetches and displays data from the selected ...
                                                                                                                                • Functionality-based URLs

                                                                                                                                  Overview In the topic Zoho Creator URL Patterns we learned about the default URLs to access a Zoho Creator application and its forms, reports and pages. In this topic, we will learn about the functionality based URLs to set default values for form ...
                                                                                                                                  Wherever you are is as good as
                                                                                                                                  your workplace

                                                                                                                                    Resources

                                                                                                                                    Videos

                                                                                                                                    Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                    eBooks

                                                                                                                                    Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                    Webinars

                                                                                                                                    Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                    CRM Tips

                                                                                                                                    Make the most of Zoho CRM with these useful tips.



                                                                                                                                      Zoho Show Resources