Hi, I’ve started to build an Airtable base in order to create a matrix that would allow our content team to know exactly what Content (eg. Article, blog post, social media post, …) to create depending on an Event (a new feature is available, there was an issue with the app, …).
The relation between Events and Content is not 1 to 1. Therefore we’ve identified a set of 4 criteria (Frequency, target, channel, location) to help us associate each Event to the appropriate Content(s).
Here is what I have so far on Airtable
Table 1: list of Events associated to the 4 criteria (see screenshot below)
Table 2: list of Contents associated to the 4 criterias (see screenshot below)
Table 3: list of value associated to criteria target (see screenshot below)
Table 4: list of value associated to criteria frequency
Table 5: list of value associated to criteria channels
Table 6: list of value associated to criteria locations
So now that I have all this ready, I’d like to either create a new table where I could see the list of Contents associated to an Event (or the mapping between event and content type based on their overlapping criteria) - see expected result below in the screenshot. I started to dig into formula but I got stuck a bit in it.
Does anyone have already build something like this before? What would be the best way?
Thanks for your help