Adam C - Workflow and Web Application Consulting


Generate Master Attendance List

From a bunch of different attendance lists, generate a master copy of everyone who attended

View the solution base here

Base Details

  1. Person table

    1. Each record contains the following information for each person:
      1. First and Last name
      2. A linked field for each event
      3. A formula field that compiles all of the events the person is attending
        Person.png
  2. Event 1 table

    1. Each record contains the following information for the event:
      1. First name of attendee
      2. Last name of attendee
      3. Linked field to the Person table
        Event 1.png
  3. Event 2 table

    1. Each record contains the following information for the event:
      1. First name of attendee
      2. Last name of attendee
      3. Linked field to the Person table
        Event 2.png

Scope

Each Event table was integrated with a single event on Eventbrite. When a user signed up for an event, a new record would be created in the appropriate table by using Zapier.

This all worked well, and the user wanted a master list that could show every person and all the events that they were attending.


The Solution

Consolidated Attendance.gif

(In the gif, we are using a Form submission as a proxy for a user signing up for an event on Eventbrite)

We created an automation per Event table that would, on creation of the record in the table, would paste the First Name and Last Name value in to the table's linked field to the Person table.

Doing this would either create a new record in the Person table with the person's full name, or would connect the Event record to an existing Person record


"

Adam was communicative and helpful, and quickly offered to schedule a session with me to solve a problem that had been causing us headaches for a while.

His knowledge of both airtable and external applications allowed us to come to a solution that has not just solved the problem, but increased the efficiency of the process.

"

-Florian


adam@thetimesaving.company