How to filter cms items on a dynamic page based on the author?

Hi Webflowers!

I am working on a client site and i need a bit of help.

The site is a journaling guides site which features (obviously) jurnaling guides made by different authors.

We are in the process of adding an affiliate program page and the current authors are gonna be the first affiliates.

That page is gonna be a cms powered template. For each of our affiliates. As i said, the first affiliates are certainly gonna be our current authors and on their affiliate pages we want to display some of their guides.

So we want to show a max of 4 guides by the affiliate. How can i achieve that condition?

I will attach some screenshots so you can better understand what my problem is and how it is set up in the cms collection.

Link to the page:

Here is my public share link: