Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 17, 2024 04:27 PM
Hi, I help run a live event production company, mostly concerts and other performance events. I am trying to create a schedule for crewing my events. I want it to be organized by "Event" primarily, then "Position" (think stagehand, lighting, sound, etc) and then I would like to assign crew to each position. I have attached the Google Sheet I currently use for reference.
I have already created my crew database as it's own table, as well as a table for events.
I am brand new to Airtable so please explain as if I am a third grader.
In addition to this, I would like to create a time sheet for each "Event", preferably auto-created when I create a new event, that auto fills with pay, position & crew member from the schedule, and I just have to input hours and then I can print that and send it to accounting.
Any help is appreciated. Thank you!
Aug 17, 2024 11:51 PM
If I were you I'd have another table called "Positions" where each record represents a single position and is linked to all the crew members that can do that job, as this would let me use dynamic filters (https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields).
For example, the "Crew" table would look like this:
And the "Positions" table would look like this:
I'd then have an "Event <> Positions" where each record represents a single position in a single event:
And this would allow me to select the crew members that are in that position only:
===
For the pay calculations, I would create a lookup field in "Event <> Position" to grab the pay/hour, and use a formula field to multiply that by the hours worked:
The printing bit is subjective. At this point you could use an Interface you've created for this purpose and print that, or you could use the Page Designer extension to hanlde that too: https://support.airtable.com/docs/page-designer-extension-overview
===
Another thing to note is that, if your Events mostly have the same positions, you can look into creating a Record Template that has all the pre-set positions for the event, and that way you can just apply that template and have all the Event <> Position records created automatically. For example in the screenshot below, this template creates three records in "Event <> Positions" that's linked to the Event record:
1. One record with the position "Sound"
2. One record with the position "Stagehand"
3. One record with the position "Lighting"