Hello, I've been using Airtable to create VFX shot lists for feature films and scripted TV series.
I find it very useful to display general information (VFX name, Description, Status, etc.), as you can see in the example below:
But in some productions, they need me to add specific info for every VFX plate that is part of a particular VFX shot (sometimes it's just one plate, but in some instances there are many). This is pretty easy to achieve using Spreadsheet software (see below):
But I'm having a hard time to replicate this simple organisation and layout in Airtable.
As you can see, some fields are common for all three plates (Thumbnail, VFX Shot Name, Description), but other fields are specific for each plate (Plate Name, Video track, Plate Duration, Source Clip Info, etc.)
I've tried different options in Airtable, like Grouping records, linking records and Lookup fields, but I can't manage to accomplish what I want:
- Is there a way to create a main record in Airtable and add subrecords to it?
- Would it be possible to display the information for every subrecord in a separate row (in Grid View), without expanding the main record view?
I would like to be able to create more complex VFX database like this in Airtable... But it doesn't seem to be designed for this. I'd appreciate if anybody could give me some advice about this, so I don't have to go back to using Spreadsheet software.
Thanks in advance!
Jesús