Skip to main content

Making the perfect Airtable base for logging video for my documentary

  • March 17, 2020
  • 4 replies
  • 74 views
J

Hi everyone,

I’m new to Airtable and before I get too far populating my Airtable base, I was hoping to solicit advice on how to set it up as well as possible.

I am watching raw footage for my documentary film and logging it. Basically the data I have is: time code, logging notes, thematic tags.

Here are some examples pulled from the Google Doc:

31:09 | Clint, Joyva History, Radutzky Family

  • Clint: Mickey, Harry, Milton, Alex. Those were all my bosses. I love them all. There was nothing in the world that they wouldn’t do for me. That’s why I never let them down. I never leave them.
  • Now I work for Milton’s son Richie, your father
  • Anybody that’s not happy with their job I don’t understand why, I love my job

27:37 | Angel, Factory, Outdated

  • The process hasn’t changed at all. “It’s like your grandmother’s pancakes”

31:09 and 27:37 is the Time Code. Angel, Factory, Outdated, etc are the tags. Then the third field is the notes “the process…”

Any advice?

Thanks so much!
Josh

This topic has been closed for replies.

4 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Josh_Freund,

Welcome to Airtable Community!

Well i think what you are already doing now is good. You can make the 2nd field a linked field and create a new table with it (if it helps you to track all the events in a certain tag for example).

You can also add a field with Character names involved in the scene to help you track the whereabouts of each character (again, maybe you dont need it)

Good luck!
Mo

J
  • Josh_Freund
  • Author
  • New Participant
  • March 18, 2020

Hi @Mohamed_Swellam,

Thank you SO much for reading my post and responding!

I’m not entirely understanding your comment about linked fields. How would I make the tags a linked field? Where would the table then exist? Right now, the tag column is multiple select. Would I have to change that?

I like the idea of Character names too. I’ve thought about that as an option.

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Mohamed_Swellam,

Thank you SO much for reading my post and responding!

I’m not entirely understanding your comment about linked fields. How would I make the tags a linked field? Where would the table then exist? Right now, the tag column is multiple select. Would I have to change that?

I like the idea of Character names too. I’ve thought about that as an option.


Hi @Josh_Freund,

Yes you will have to change that into a Linked Field instead. You will then choose Create New Table, there is where the tags will be.

Same for Character names / relationships. If you want me to take a loom at it you can share a screenshot.

BR,
Mo

J
  • Josh_Freund
  • Author
  • New Participant
  • March 18, 2020

Gotcha. I just read some Airtable guides on linked fields so I understand what you’re saying now. Thanks a lot, again, for taking the time to respond to me! There’s so much you can do on Airtable, it’s amazing if you want to be hyper organized. I just find it to have a slightly high learning curve. :slightly_smiling_face:

    Terms & ConditionsAccessibility statement