Performances

Explore

*Updated*

***

I've updated the base to include a Junction Table that provides better cross-referencing between performances, works, performers, and roles. The Array fields allow for better formatting of primary record fields.

***

​

If you're a live-theater junkie like me, you probably have boxes of old programs rotting away in some closet. Time to get rid of them!

​

​I put this base together to help me keep track of everything I've seen. It gives me a detailed record of every performance of every work by every performer I've seen, thanks to Airtable's ability to create many-to-many relationships.

​

​Using the Base

​

​Performances Table

Use this to enter overall information about a live performance event, including an image, type of event, the venue, your rating, who you saw it with, and any notes you want to make. Some performances will involve multiple works. It links with the Junction Table, allowing rollup fields to display information about works performed and cast lists.

​

​Works Table

Use this to enter information on each work performed. Links with the Junction Table to associate works with individual performances and performers.

​

Performer Table

Allows you to see performers and their roles. Links with the Junction Table to associate performers with works, roles and individual performances.

​

​Roles Table

Allows you to see which roles have been performed by a variety of performers. Links with the Junction Table to associate roles with works, individual performances, and performers.

​

Director Table

Links directors with individual performances.

​

Conductor Table

Links conductors with individual performances.

​

Junction Table

Use this table to enter each individual performance of a role by a performer during a particular performance. Allows other tables to link performances, works, roles, and performers.

​

​Photo credit: "Palais Garnier" by Chris Chabot/Flickr CC BY-NC 2.0

Explore
Updated November 28, 2019 at 3:28 AM
Copied 47 times
Explore the base
All
Gallery
All
Gallery
Grid view
Grid view
Grouped by Work
All
All
Grid 2
Grid view