Skip to main content

I have used Airtable a couple of times pretty much as a spreadsheet. I want to do something that is still probably simple, but I still can’t figure it out even with the videos. I am just trying to organize all of my home media (see flow chart) into a searchable database . Can you point me to a video or example already out there?

It seems like you could make one base with one table per top level item in your flow chart:



  • Table 1: Videos

    • Single Select Field: “Type”. Add options for “Hi 8”, “DVD”, “VHS”, “Film - 16 mm”, “Film - Old Format”, etc.

    • Attachment Field: “File”. Attach the appropriate file; OR

      URL Field: “Link to File”. If the file sizes are large, link to the files on your cloud storage of choice.



  • Table 2: Photos

    • Single Select Field: “Type”. Add options for “Slides”, “Negatives”, “Prints”, “Film - 16 mm”, “Film - Old Format”, etc.

    • Attachment Field: “File”. Attach the appropriate file; OR

      URL Field: “Link to File”. If the file sizes are large, link to the files on your cloud storage of choice.



  • Table 3: Audio

    • Single Select Field: “Type”. Add options for “Cassette”, “Zoom”, etc.

    • Attachment Field: “File”. Attach the appropriate file; OR

      URL Field: “Link to File”. If the file sizes are large, link to the files on your cloud storage of choice.



  • Table 4: Journals


If you need a sample base, check out this Media Catalog built by Anton Preisinger. You can find this and other example bases on the Airtable Universe.

Reply


Terms & Conditions