Multi-select lookup fields in Android app

Multi-select lookup fields in Android app

A Multi-select lookup field allows you to connect multiple records from one module to a record in another module. This is useful when you want to associate more than one item or value with a single record.

Types of relationships 

  1. One-to-One relationship (Lookup fields): Link one record to another, such as connecting a contact to a single account.
  1. One-to-Many relationships (Lookup fields): Use standard lookup fields to assign one record to multiple related records, like linking one product to several customer orders.   
           
  1. Many-to-Many relationships (Multi-select lookup fields): Allow a record to be associated with multiple records, such as linking a student to multiple courses while also allowing each course to have multiple students enrolled.   
       

Example scenario 

Let's use an event management company as an example to illustrate this.

Modules:
  1. Events: This module contains information about various events (e.g., Wedding, Corporate Meeting, Music Festival).
  2. Services: This module includes details about the services offered (e.g., Catering, Decoration, Audio).
 
Relationships:
  1. One Event can require multiple Services (e.g., a wedding can have catering, decoration, and photography).
  2. One Service can be provided for multiple Events (e.g., Catering can be used for weddings, corporate meetings, and concerts).

Using a multi-select lookup field

To associate multiple services with an event, you can use a Multi-select lookup field.
When you create a record for the Wedding event, you can select:
  1. Catering
  2. Event Setup
  3. Photography 
This way, the wedding event is linked to all these services at once. This establishes a many-to-many relationship: one event can require many services, and each service can be utilized for multiple events.
   

Working with multi-select lookup fields  

Once you create multi-select lookup fields in Zoho CRM on the web, you can easily use them in the Android app. Here’s what you can do:
  1. Assign existing records
  2. Create records and assign
  3. Unassign records

 To assign existing records 

  1. Open the Zoho CRM Android app.
  2. Go to the module with the multi-select lookup field.
  3. Open the desired record.
  4. Tap the Plus icon () next to the associated module.
  5. Select the records you want to assign.
  6. Tap tick icon ()save your selection

To create and assign records 

  1. Open the Zoho CRM Android app.
  2. Navigate to the module with the multi-select lookup field.
  3. Open the desired record.
  4. Tap the Plus icon () next to the associated module.
  5. Tap the Plus icon () in the top-right corner to create a new record.
  6. Fill in the required details.
  7. Tap Save.
  8. Tap Done to finalize your selections.

To unassign records 

  1. Open the Zoho CRM Android app.
  2. Navigate to the module with the multi-select lookup field.
  3. Open the record you want to edit.
  4. Tap the Edit icon ().
  5. Tap the Unassign icon ().
  6. Confirm unassign when prompted
  7. Tap tick icon () to save your changes.
 

Linking module  

A linking module is created to manage the relationships between two modules that are connected through a multi-select lookup field. It acts as a bridge to store additional information about the associations.
 
Example Scenario: 
Continuing with the event management example, let’s say you want to keep track of service details for each event.

Here’s the problem:
  1. You can't store specific details (like service cost or special requirements) as a field in the Event module, because each service has different details.
  2. You can't store it in the Service module either because other events might have different requirements or pricing for the same service.
 
Solution with a linking module:
The linking module tracks each association between events and services.

For example:
  1. Event: Wedding Reception
  2. Services: Photography, Catering
 
In the linking module, two records are created:
  1. Wedding Reception - Photography (Cost: $6,000, Requirement: Candid)
  2. Wedding Reception - Catering (Cost: $5,000, Requirement: Vegan Menu)
This structure allows you to create individual records for each service related to the same event. It also helps you capture specific requirements and costs for each service. This way, you maintain a clear and organized overview of all service details associated with the event.
Notes
Note: 
  1. Auto numbers are generated for each record in the linked module.
  2. Linking modules are denoted by  
  3. Each record in the linking module contains two fields that point to the primary modules. Tapping on these fields will take you directly to the related records in each primary module.

 To access records in linking module 

  1. Open the Zoho CRM Android app.
  2. Navigate to one of the primary associated modules.
  3. Tap on the More icon
    of the associated multi-select record in the related list.
    For example, if a multi-select relationship exists between the Events and Services modules, open either the Events or Services module.
  4. Tap the View the linking record option, which displays the unique number of the linked record.
    You will be taken to the specific record created for that (Event x Service) association.

You can also access the records in the linking module directly, like any other module. The method mentioned above makes it easier to find a specific record linked to the multi-select associated modules.

      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 FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              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
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure 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

                                                                                                                            • Multi-select lookup fields in iOS app

                                                                                                                              A Multi-Select Lookup Field allows you to connect multiple records from one module to a record in another module. This is useful when you want to associate more than one item or value with a single record. Types of relationships One-to-One ...
                                                                                                                            • Field of Lookup

                                                                                                                              Overview Lookup fields enable users to associate records between two modules. Let's say, for example, you have two modules: Students and Courses. By adding a lookup field called Course type in the Students module, users can select a course when a new ...
                                                                                                                            • Lookup Filters

                                                                                                                              Some of the features are available only to specific customers. Overview Lookup filters in Zoho CRM help streamline data selection by ensuring users can only choose relevant records when associating data across modules. This reduces the risk of errors ...
                                                                                                                            • Types of Custom Fields

                                                                                                                              In Zoho CRM, you can add different types of custom fields as per your requirements. These fields will be available to all the users added to your organization's CRM account. Customize Zoho Defined Fields : You can edit, delete and hide some of Zoho ...
                                                                                                                            • Marking Personal Fields

                                                                                                                              GDPR defines personal data as any information relating to an identified or identifiable natural person (i.e. the data subject). There is a wide range of personal data that includes email addresses, location, mobile numbers, identification numbers, ...
                                                                                                                              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