Hello - I'm VERY new to Airtable, though I think I have a basic understanding of databases. I'm looking for examples, templates, pointers to further help. Or even the right terminology to use.
While I want to create a larger base, I got started with a simple event tracker (types of events, different leaders, different sponsors, etc.). Now I'd like to expand this to keep track of who has attended AND enable some options for adding the list of attendees and querying.
Adding the attendees seems fairly "obvious" - table of people; table of events; table of attendees (people + event).
The thing I don't know as is how to make this easy to use - how to get data in easily AND how to query easily. The obvious thing for data entry is to type into the table or a form. But what I'd love to be able to do is send an (structured?) email with the event information and list of attendees. Maybe even forward the meeting invite?
And on the query side, I know how to search for individual names or look for specific events. But I'd like to be able to take a list of names and ask "what sessions have these people been in" and get a useful response back. Again, could I send an email and get an email response back?
Thanks for any guidance or suggestions!