We have an airtable set up to list the podcasts we are sponsoring. We have the main scheduling tab (Podcast Sponsoring) as well as the canned reads that we send each podcaster (Canned Read).
On the PS tab, we list which product they are sponsoring. Product 1 or Product 2.
We want Airtable to look at what is in that column; Prodcut 1 or 2 and bring in the information that is listed for that product in the Canned Read tab.
Is there a way to do that?