Help

Rollup Field That Matches Value from Another Table

Topic Labels: Base design
1230 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nick_Simard
4 - Data Explorer
4 - Data Explorer

Hey there, Airtable Community! I’m trying to do something and can’t seem to figure it out.

Here’s what I’m trying to do. I’ve got one table where I’m tracking Medium stories, including the author, tags added to the story, date, etc. Basic version of what I’m going for:

Screen Shot 2021-07-16 at 12.15.25 AM

Medium has Top Writer status that can be achieved for specific tags. I’d like to track who those top writers are at the end of every month, and in a rollup field (I think this is what I would use) I want to ONLY show the stories from the month/tag in which they were a top writer. So I’d want to see that for the productivity tag, Author One got Top Writer status in June, then easily see all the stories written by them in that month (from within that record in the Top Writer table).

What’s the best way to set up that Top Writer table so that I’m able to properly connect the data and do what I’m after? Is it even possible?

Thanks so much!

0 Replies 0