Importing data to lookup fields

Importing data to lookup fields

Hi everyone. I have made a fairly basic app for tracking attendance at meetings. The main form is called "attendance" and related forms are "members" and "organizations". What I want to do is import a CSV of attendees to the "attendance" form and have that automatically populate the "members" and "organizations" forms as well. It's very likely that I will be importing CSVs on an on-going basis, after each meeting.

How do I go about structuring this? Also, is there a way to de-duplicate members?


            Zoho DataPrep Resources

                Zoho CRM Plus Resources

                  Zoho Books Resources

                    Zoho Subscriptions Resources

                      Zoho Desk Resources

                        Zoho Projects Resources

                          Zoho Sprints Resources

                            Zoho Orchestly Resources

                              Zoho Creator Resources

                                Zoho WorkDrive Resources

                                    Zoho Campaigns Resources

                                      Zoho CRM Resources

                                                  Design. Discuss. Deliver.

                                                  Create visually engaging stories with Zoho Show.

                                                  Get Started Now

                                                      Zoho Writer Writer

                                                      Get Started. Write Away!

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