Context: My base is set up into three tables: Videos, Scenes, and Footage. Since some shots of footage may appear in more than one video, the Scenes table is functioning as a junction to preserve the shot chronology unique to each video. I'm trying t...
Context: I have two tables, Shots and Videos (with links between). It's possible one shot may be used in more than one video. I will export shots through a CSV into an InDesign template using data merge (Page Builder won't work for other reasons).Pro...
How do I use automations to compare overlap between two tables of products?
I wanted to trigger the automation with TBD, have it look at the table of 2021 products. If matching model number was found, it would mark the corresponding one in 2022 as RE...
