Hey! I manage a large, complex content planning/recording Airtable base. We have a table of content campaigns that are linked to specific deliverables records that live in their own table. Each deliverable has a unique publishing date, which means that a single campaign might have multiple publishing dates, or a campaign may not have an associated deliverable published for a long interval, but would need to be resurfaced when a new deliverable is added.
Is there a way to create a calendar view that would display the content campaigns based on the dates in the linked deliverables (with the caveat that if there were multiple deliverables on the same day, the campaign would only appear once)?
As an example we might have:
Content Campaign A [Table 1]
- Twitter Deliverable (Scheduled for 11/23/22) [Table 2]
- Instagram Deliverable (Scheduled for 12/15/22) [Table 2]
- Site Deliverable (Scheduled for 03/02/23) [Table 2]
I would want a calendar view of [Table 1] that surfaces the Content Campaign record based on the Deliverable dates from the linked records found in [Table 2].
I feel like there is a simple solution to this that I am missing, but I can’t find it. Any help would be appreciated!