Goal: track who of our customers are at which events
My solution thus far has been to have a People table and an Events table within the same base. Within each event, there is a guest list field that links to the "name" field of the "people" table.
The issue is, I want to be able to quickly link guests to events, i.e. by uploading a CSV guest list and then that automatically linking to the "people" list. Ideally, on the "People" i could create gallery views for each event.
I'm sure something like this is possible but can't figure out how to do so! anyone have any guidance??
Thanks! That extension looks helpful. Unfortunately, using this extension it looks like it will create new records. The guests are already records in airtable, but looking for a way to essentially tag a group all at once as having attended an event. Essentially, solving to see if there is a way to mass import guests here (see picture), in such a way that it didn't duplicate their records and linked existing records in "contacts" to the event.