Populate a repeater with data from multiple collections

From what I can tell, this is something that cannot be solved with reference or multi-reference fields, but I could be missing something.

On my site, I host multiple types of content: long-form articles with lots of images, shorter blog posts, podcast episodes with an image and brief description along with the audio player, pages that describe a digital tool and and allow visitors to download, etc. Each of these types of content require a distinct layout (obviously) but each occur often enough that I want to use the Content Manager features and make each type a collection of it’s own - a collection for Long Articles, another for Posts, Another for Podcasts, etc.

I want to be able to showcase a repeater that is like a feed of my latest content, listed from newest to oldest, no matter which collection it belongs to, one item per repeater node, and to have each item link to the correct dynamic item page.

It would be nice to be able to have a dynamic list page that works the same way, which could then be filtered by content type.

Everything I can find for the last couple of hours in this forum and in third-party tutorials doesn’t cover this, so either this is an uncommon use case or it’s something very simple that I am just not getting somehow.

Thank you in advance for any insights.

I get the feeling that I may have to manually curate a separate collection strictly for mixed content types and link to the item pages by inputting the dynamic item URLs in their own field.

I am hoping this is not the case, as it drastically reduces the utility of the CMS tools if I can’t present the content holistically without this laborious manual step.

Hey!

It seems you might have found an approach by using a new collection. It might be possible to automate things using Velo and data hooks. You could automatically change the content in the new database when your others are changed.

Perhaps the Velo (code) forum might have a solution - https://community.wix.com/velo/forum

Thank you, Noah! I will check it out.