Hi all!
We’ve been racking our brain as to best set up our base, but we could definitely use your help!
Here’s the thing: as a copywriting agency, we’re producing content for many different clients. And each client has their own tab with their own product planning. Some have say - thirty blogs per week. Others have incidental assignments. In our main/ starter/ first tab, we’re trying to create an overview of grouped tasks (eg. ‘Blogs week 17’), since mentioning each project would simply be a mess. And we would like to be able to link ‘Blog week 17’ with the corresponding tab of the client, were we can then specify which blogs these are (topics, who writes, etc).
So, we have a ‘secondary’ tab per client. But now we’re looking for a simple way to link our main tab to these specific titles without having a ‘linked field’ for each client in the first tab: this would mean a very - very wide view for each record, while only one link would be relevant. To clarify: our first tab has the overview of all assignments in ‘broad’ terms, so of all clients.
Hope I’m explaining our puzzle correctly: please feel free to ask additional questions if you need clarification.
Hope someone can shed light on our puzzle! Thanks so much for thinking along.