How to normalize CRM module when integrating with Survey?

How to normalize CRM module when integrating with Survey?

This question is about the problem with many-to-many relationships and Survey. One of the things our organization does is track people in our program and their jobs. We get new information from the people three times annually through Zoho Surveys. Survey integrates nicely with CRM until you have more complicated modules.

The best way to show a 1-many relationship with people and jobs is to use a subform. The best way to show a many-to-many relationship with people and companies is with a Linking Module. 

The problem is Survey cannot write data into either of those directly. I have to do a 1:1 mapping in Survey to my CRM fields. How can I still capture the periodic changes in jobs from Survey without denormalizing the module with duplicative fields like Job1Title, Job1Salary, Job2Title, Job2Salary, etc? We need to see a tidy list of the job history, like one would see in a Linking Module or Subform. 

The only thing I can think of is writing code to write the data to a Subform or Linking Module after the survey period is over and then clearing out the data for the next survey. 

Any ideas would be appreciated. Thanks.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ








                                ご検討中の方