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.
Notes
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. A maximum of 500 nested picklist options can be added.
  3. 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. 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.
Notes
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 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

                                                                                                                                • Working with Custom Fields

                                                                                                                                  Custom fields enable organizations to capture and organize information that cannot be added to the system-defined fields such as customer location, work experience, asset type etc. These user-defined fields can be configured to suit business and ...
                                                                                                                                • Color Coding of Picklist Values 

                                                                                                                                  Picklist fields provide a predefined set of values for users to select from. This ensures consistent and standardized data entry across the system. It also enables grouping and filtering of similar records. For example, in the Tickets module, ...
                                                                                                                                • FAQs: Ticket Management

                                                                                                                                  1. What is a ticket and where does it originate from? Tickets are support requests that are submitted by customers. They contain the support conversations and other important details, such as priority, category, and status, that help agents ...
                                                                                                                                • FAQs: Formula Field

                                                                                                                                  1. What is a formula field? A formula field is a custom field that automatically calculates values based on other field values. It helps automate data calculations based on a predefined expression using fields, constants, operators, and functions. It ...
                                                                                                                                • Actions in the Ticket Detail Page

                                                                                                                                  Once a ticket is assigned to an agent, there are several actions they need to perform in order to resolve the issue and eventually close the ticket. Sometimes, agents have to edit the ticket to include missing information that the customer shared ...
                                                                                                                                  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