Help

TV/Film Call Sheet Page Design

909 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Mrs_Christine_S
4 - Data Explorer
4 - Data Explorer

Hello,

I’ve created a database that essentially allows me to create a call sheet (sample here) using the page design app.

I currently have two tables:

  1. Call sheet table - lists the date as the main column. For each date, I have information such as the location, linked crew member, status etc.

  2. Crew table - this table lists each person’s name in the main column. There’s a linked record to the dates they’re working in the call sheet table, their email, cell, and role. I’d also like to add a column for the call time, but that will vary based on the date. On Tuesday their call time might be 9:00am but on Wednesday it’s 8:30am.

Since each crew member in linked to several call sheet dates, one person may be linked to 2-4 different days of work on set. The time that people need to report to set each day varies.

I’m trying to figure out a way, in the crew tab, to assign a call time for each person for each shoot day that they are assigned.

Would you be able to assist?

I then take all this information and pull it into the page designer app to build a call sheet with each crew member for that day and their corresponding call time.

3 Replies 3
Shannon_Bradley
7 - App Architect
7 - App Architect

Did you ever figure something out? I am also currently working to build a Call Sheet as well as a proper 1 Liner

@Shannon_Bradley - Did you ever work out a Call Sheet template? I'm about to start one for a documentary production, and I'm wondering if you have a public template you might share?

The key was Docs Automator! I ended up revamping my setup a bit and integrated the amazing 3rd party site. I can't say enough good things about it, the best part is the reduction in possible errors from copying info from the system to the call sheet since it pulls in automatically.  I then worked on learning interface setup to make something easy for my ADs to use