i’m using the CSV import app to create a list of unique people who have attended all our events. i match the people using their email address and create new people if they don’t exist.
one of the fields is a related record field that relates to a tab with a list of all the events. that field allows for linking to multiple records. however, when i import the list of attendees from Event 2, it overwrites all the data in the Events Attended field, so that Event 1 disappears. my preferred outcome is that Event 1 and Event 2 appear in the Events Attended field.
how do i solve? thanks!!