Link one Dataset to Blog Posts by Author Name

[user1553]

I’m having trouble with
I currently have a Leadership page that displays the team members of my company. Each team member is stored as a row in a CMS collection and displayed using a repeater on the Leadership page.

What I’m trying to accomplish is: when a user clicks on a team member, the corresponding Member Page should display Related Blog Posts written by that specific member.

Here’s what I have so far:

• A dataset connected to the Leadership Members collection

• A dataset connected to the Blog Posts collection

• A dynamic page for each Leadership Member (auto-generated from the CMS)

I tried adding a repeater on the Member Page and connecting it to the Blog Posts dataset, but I can’t seem to filter the blog posts dataset by author. Essentially, I want to link the current member’s name (the page being viewed) to the author field in the Blog Posts collection.

Has anyone successfully linked two datasets like this — where a dynamic page item filters related posts based on a matching field (e.g., memberName = authorName)? Any guidance or example code for filtering the Blog Posts dataset dynamically would be greatly appreciated.

Working in
Wix Studio Editor, CMS and Blog of Wix Studio

[Rob]

I was checking the reference fields for the collections and from what I see, the blog post authors are connected to the PublicMember Database if you are using the Members dataset to create the dynamic pages. Using that as a reference point should help in filtering the items.

However, if you’re using a custom dataset for the members (similar to the preset collection Wix provides for team members), I was able to link them really easily by making a new collection and then referencing both the blog Posts and the TeamMemberDataset.

When using the reference field, you can pull the data from both datasets.

Then once the proper information is connected on the dynamic page, you can filter this dataset to the DynamicDataset.

[user1553]

Hello Rob,

Thanks for your swift and helpful reply!

This is is absolutely helpful. However, I would like to ask, my Blog Posts are in a the Blog section of Wix (attached in the screenshot below) and not in the CMS section.

Being the case, would that still be possible to be done?

Thank you!

[Rob]

Glad it helped and yes you can. You just need to enable app collections. Most of the applications store their information in a CMS; you can’t add(write) into the collection with the CMS but you can read from them so that what you add in the dashboard can be pulled from within the editor or referenced with a custom collection.

I did a gif so you can see how you can see the before and after of enabling it on my site.

[user1553]

@Rob

ir information in a CMS; you can’t add(write) into the collection with the CMS but you can read from them so that what you add in the dashbo

Thanks for that GIF Rob! That was very helpful.

Quick question, do I have to manually link the Posts of each Author to each other in the CMS as shown in your screenshot?

I do have a lot of posts and ideally, would like to automate that process of having the Posts fetched by Author (which would be the same as the Team Member in the Page).

Thanks again

[Rob]

This method would require you linking them. I don’t have members on the example for the site so it would required some setup to do but you can try using the information I mentioned that blog authors are pulled from the PublicMember dataset to try to automate things with code or make it a little easier to find the authors.

[user1553]

I see, thanks again. Would you happen to have an example of how I could automate that with code? Would I need to leave the references column empty?

Thanks

[Rob]

I haven’t created it but I feel you should be able to use a combination of automations since there’s an option for when a post is created and there are functions to insert() data into a collection.