CRM and Forms integration, using lookup fields on subforms

CRM and Forms integration, using lookup fields on subforms

Hello!

Here we go! On Zoho CRM I have 2 modules: Trailers and Forms. My trailers are identified with a field called "Trailer Number".

The Forms module has 2 subforms, both connected to Zoho forms, where:
1st, my customers can drop up to 4 rows of contact information.
And  2nd, my customers can add up to 10 Trailer Numbers that will have the same contact information.

This is a typical one-to-many relationship (1 record on the forms module connected to many records on the trailers module). My problem is that there is no integration for lookup fields inside a subform between Zoho CRM and Zoho Forms, so there is no standard procedure to link the data (or is it? If someone knows, please let me know!)

The only way I see this working is:
- Deleting the subform for the trailer numbers, adding the max number of lookup fields that I can (only 5), and making rules to show and hide fields depending on what the customer says he is going to add, which honestly is just a workaround.
- or adding a multi-select lookup field on the forms module, connect it to the trailers module, and when the record gets created, get the information from the trailer numbers subform, and add it to the new multi-select lookup field. The thing with this option is that I don't know how to grab that information from the subform and then add it to a multi-select lookup field. 
Is it possible? What other solutions would you think? 

Thank you!

    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • Sticky Posts

                                              • Free Webinar - Digital signatures for digital contract management with Zoho CRM

                                                Hi, Did you know you can seamlessly send and collect signatures on important business documents like business proposals, vendor agreements, sales contracts, invoices, and other inventory documents with Zoho Sign’s extension for Zoho CRM? Join our upcoming
                                              • New User Interface for your Email integration in Zoho CRM

                                                Hello folks,  As most of you may already know, Zoho Mail recently got a new user interface that's a lot better and easier to use. As a result, this change will affect your email integration with your Zoho CRM account**.  If you have your email integration in Zoho CRM set up through POP, your Emails UI in CRM will be moved to the new Zoho Mail UI. We hope that you like the new and improved Emails interface inside Zoho CRM. Feel free to share your feedback by commenting below.  **Please note that,
                                              • Fetching leads from Zoho CRM into Zoho Creator, automatically

                                                I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible?   Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM.  For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now