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:
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!