Creating nested picklist fields - Online Help | Zoho Desk

Creating nested picklist fields

Record Creation forms are used to collect and display data. The more organized, clean, and streamlined these forms are,the more efficient the data collection process will be.
 
A nested picklist is a type of picklist field that can help you build organized Record Creation forms by reducing the number of fields you would otherwise need to use. 
With a nested picklist, you can nest or group up to six levels of values within a single picklist option, so that each level relates to the previous one. 
For example, for a company to obtain a customer's location, it can create a nested picklist with country > state > city as levels. Without the nested picklist field, the form would be cluttered with several different dropdown menus. 
Lets look at a few example, to understand how nested picklists can be used:
Example 1
A mobile phone retailer wants its customers to select their preferred location for store pickup. With a nested picklist, itcan obtain the customer's country, state or province, and city through a single option. Here's how to nest these values:
 
Picklist label: Location
Picklist values:
Option 1 -> None (Default)
 Option 2 -> US :: Washington :: Seattle 
Option 3 -> US :: California :: Los Angeles
Option 4 -> US :: California :: San Francisco
Option 5 -> Canada :: Ontario :: Toronto
Option 6 -> Canada :: Ontario :: Toronto



The nested picklist field will look like this on the Ticket Add form.



Example 2
A company wants to know how its employees commute to the office so it can optimize its parking system. Here's how it can create a nested picklist field to obtain this data: 

Picklist label: Mode of commutation
Picklist values:
Option 1 - None (Default)
Option 2 - Car :: Personal
Option 3 - Car :: Pool   
Option 4 - Car :: Company  
Option 5 - Bike
Option 6 - Public Transport :: Bus   
Option 7 - Public Transport :: Metro



This is what the field will look like on the Record Creation form.
Note
  1. The levels of a nested picklist are separated by double colons (::). For example: Category :: subcategory :: further subcategory. Let's call this the "actual format." 
  2. The picklist field will be auto-filled with a default value, which is generally the first option on the Creation form. However, you can set any option as the default during field creation/editing. 
  3. Picklist values must be entered the same way they appear on the Create/Edit Field form while using criteria and search. In other words, they must be entered in the "actual format". 
For example, to create a custom view of tickets with customers located in Los Angeles: 

To configure a nested picklist field
  1. Go to Setup > CustomizationLayouts and Fields.
  2. Select a module and department from the dropdown menu on the Layouts page.
  3. Select the layout you want to use for the nested picklist field.On the Edit Layout page, do the following:
    1. From the Add Fields tray on the right, drag and drop the picklist field type to your desired position on the layout.
    2. Enter a name for the field.Scroll down and enable the Nested Picklist option.
    3. Fill in the options, making sure to separate nested levels with double colons (::).
    4. Click the Plus icon (+) to add up to 500 options.
    5. Click Add and then click Save & Close on the layout
  4. The nested picklist will be added to your layout.
Adding values in bulk
You also have the option to add nested picklist values in bulk. You can choose from a list of predefined choices or enter choices manually. You can also opt to import values from CSV files.
To add values in bulk
1. Navigate to the Add/Edit Layouts page and do the following:
  1. From the Add Fields tray on the right, drag and drop the Picklist field into the desired position on the layout.
  2. Enter a name for the field.
  3. Enable the Nested Picklist option.
  4. Just above the Nested Picklist toggle, you will find the Add Values in Bulk option— click on it.
  5. Choose from the 3 options for bulk adding values.
  1. If you're using predefined choices:
  1. Click on From Predefined Choices.
  2. Select a predefined choice set from under Import Predefined Choices.
  3. Select all, or the specific options you'd like to add, and click Add Values.
  4. Your selections will be listed as options.
  5. Proceed to nest values as usual, using double colons.Finish by clicking Add.
  1. If you wish to add values manually:
  1. Click Manual Entry.
  2. From the Editor, enter your nested picklist values with double colon separation, one below the other, and click Add Values.
  3. Finish by clicking Add.
  1. If you're importing values from a CSV file:
  1. Click Import from CSV.
  2. Ensure the values in the file have double colons separating the nested levels and are listed one below the other.Drag and drop the file into the Import from CSV section.
  3. Finish by clicking Add.
Note
  1. You can add up to five nested picklist fields per layout.
  2. Nested picklist fields are only available in the Professional and Enterprise editions of Zoho Desk.

      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 FormsLegalMobile App
                              Form DesignerHRMobile 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 FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      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

                                                              Use cases

                                                              Make the most of Zoho Desk with the use cases.

                                                               
                                                                

                                                              eBooks

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

                                                               
                                                                

                                                              Videos

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

                                                               
                                                                

                                                              Webinar

                                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                               
                                                                
                                                              • Desk Community Learning Series


                                                              • Meetups


                                                              • Ask the Experts


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner

                                                                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

                                                                                                                        • Color Coding of Picklist Values 

                                                                                                                          Picklist fields provide users with a predefined set of values to select. This helps to ensure that the data entered in the system is consistent and standard. It also allows users to group and view similar records. For instance, in the Tickets module, ...
                                                                                                                        • Working with Custom Fields

                                                                                                                          In Zoho Desk, custom fields help you capture and organize information that may not be covered by default system fields. Because custom fields are user-defined, they can be tailored to meet the specific needs of your business and industry. For ...
                                                                                                                        • Creating Formula Fields

                                                                                                                          Managers and support agents often require quick access to key metrics, such as the time remaining before a ticket becomes overdue or the calculated costs associated with services. Manually extracting and calculating these metrics can be ...
                                                                                                                        • Understanding Layouts and Layout Rules

                                                                                                                          Creating Layouts Layouts control the organization of fields and related sections on the module page of a department. Each department can have its own layout that consists of both default and custom fields. They also determine which fields are ...
                                                                                                                        • Understanding Fields and its Properties

                                                                                                                          Fields are are an essential part of modules which are used to capture information about Tickets, Customers, Organizations, Products etc. Depending on the type of data that are stored, fields are of different types such as Date, Date/Time, Picklist, ...
                                                                                                                          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