Achieve a more focused feature: a blueprint for nimble video production
You've translated your script into an intricately choreographed shoot schedule; now you need to get your players in line. Taking multiple scenes from zero to final edit hinges on expert coordination—juggling equipment, crew, and down-to-the-minute timing.
Master production day by keeping targets in sight and automating away the most tedious items on your to-do list.
Airtable Apps can take tasks like updating shoot schedules and giving your team the latest shot details off your plate, allowing you to focus on smart planning up front, and smooth execution when shoot day rolls around.
Here's your play-by-play guide to streamlining production:
Visualize your shoot dates
Update your entire production schedule at once
Create shot lists automatically
Text your team the latest updates
Count down to your next shoot date
More questions on this blueprint, or other ways that you can use apps for video production? Sign up for our webinar on using Airtable Apps for video production this Thursday, March 29th, at 10 a.m. PDT! Reserve your spot now.
Visualize your shoot dates
Getting a handle on timing for your next set of shoots is essential for executing everything according to plan. Add a timeline app to see the spread of shoot dates over time, and quickly reference any updates to your schedule.
Step 1: Add a timeline app.
Open the apps menu, click the add an app option, and add a timeline app to your base. You'll want to point the table field toward one that includes your shoot dates. Choose a view that corresponds to the set of dates you'd like to visualize over time—this could be a view containing the shoot dates for every scene in your table, or a filtered view containing just the content produced for a specific video.
Step 2: Adjust the timeline range and colors.
Choose your preferred start and end date fields. Above, we've selected the earliest and latest shoot dates associated with each scene. You can customize the color of the records on the timeline, too—try coloring according to the shot status or location.
Update your entire production schedule at once
No more updating each individual shoot date for a project when logistics change. Use the batch update app to push a series of dates forward or back by any increment you choose. You can also alter a set of dates to a specific date and time, or remove dates altogether.
Step 1: Choose a set of records and make a view.
Create a filtered view that contains only the records you'd like to edit as a group. You might choose only the set of shots for a particular scene or video, for instance.
Step 2: Add a batch update app.
Go to the apps menu and select the add an app option, then add a batch update app to your base. Then select the table and filtered view that you just set up.
Step 3: Set up editing rules.
You can specify one or multiple actions you want to trigger with a single click. Select the field you want to update and the action you want to take. In the example above, one day will be added to the shoot date for every shot in the specified view.
Create shot lists automatically
Make sure everyone on your production team has the most up-to-date shot list in their hands. Leverage the page designer app to pull in your latest shoot info and format it into a print-ready, itemized list. (Tip: You can repeat the process to generate call sheets, too!)
Step 1: Add a page designer app.
Select the add an app option in the apps menu, and add a new page designer app to your base. Make sure to pick the correct table and view. You should select the custom page size and input the dimensions that you'll need for your assets.
Step 2: Design your slide template.
Choose what information you want to include on each page. You can drag and drop elements onto the page, tweak fonts and colors, and otherwise adjust according to your aesthetics to make a great template page for your shot lists.
Step 3: Print your shot lists or export them into a shareable PDF.
When it's time to share shot lists with stakeholders, you can quickly print or create PDFs from the relevant records.
Text your team the latest updates
When schedules shift or locations change, keeping everyone on the same page is crucial for efficient production. The send SMS app offers a quick way to update a given team without the hassle of looking up and adding their contact details one by one.
Step 1: Create a filtered view.
Unless you want to contact your entire staff at once, make sure to create a new grid view, then apply as many filters as you need to get a view that only shows the people you want to message. Try a filter that will only show staff members on one particular team, or a filter that will only show people working on a specific project.
Step 2: Add a send SMS app to your base.
Note that you'll also need a Twilio API key in order to use this app. To add a send SMS app, just open up the apps menu, click the add an app option, and add a new send SMS app to your base. Go through the setup process, picking the appropriate table and view and entering your Twilio API key. Then compose a message that you want to send, including the relevant promo code. Remember that you can use curly brackets to take information from fields and put it into your message.
Step 3: Send out the message.
Whenever you want to send out your mass message, just press the send button!
Count down to your next shoot date
With so many deadlines competing for attention, make sure the most important one stays top of mind. The countdown app can tick off the time until the day of your next shoot.
Step 1: Make a view that displays upcoming shoots.
If you don't already have one, make sure that the table where you're tracking shoot dates has a view that's filtered down to show only those in the future.
Step 2: Add a countdown app.
Open the apps menu and select the add an app option. From here, add a countdown app to your base.
Step 3: Choose the dates you want to track.
Toggle the Date from view option and select the view with upcoming shoots. Make sure Earliest date is selected and check off the units you'd like to track.
Can't get enough of Airtable Apps? Sign up for our Apps mailing list to get updated for each new app we launch!