Tracking Events Attended
Hey all, we run different events and want to be able to search / filter people depending on events that they have attended. We have been using a custom field (multiple options) to track when people attend our events (which has worked great for tracking, filtering and searching who has attended different events). But, we have run into a huge bottle neck with it. When we import new data it overwrites the existing entries. This means anyone who attended a second event we have to manually update their contact because if we import we lose the data for the first event.
Is there a better way of solving this problem than in custom fields? How do others track event attendance in a searchable / filterable way?