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!


      • 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