2 datasets/filters for 2 repeaters on the same page

Hi all,

I’m very new to this and a total novice at code, I was trying to do everything I needed to without really getting into the code as it seems like it should be fairly simple.

I am using database collections to create a list of items with a photo, hire price, description, dimensions etc.

There are 6 categories of these hire items, each with it’s own page.

I have a database collection with all of the products in with a field to select which category they belong to and then on each page a filter to show only the relevant items in a repeater on the page. All good so far.

My problem is that I would now like to add a repeater across the top of the page with the 6 categories on so the user can easily click between them. This information comes from a linked database collection “Hire Category”, referenced in the main collection as a reference field.

When I add that repeater across the top, only the button for the current category appears as the dataset is filtered to that category.

I can’t seem to figure out how to filter dataset for the two repeaters in a different way or to have them refer to two different datasets and filter them that way.

Effectively, I assumed I would be able to filter one repeater and have the other repeater unfiltered, can anyone steer me in the right direction please?

Hopefully I’ve given enough information on the issue and my issue is clear, but please let me know if I’m missing information.

Thanks

Gavin

I am assuming you are talking about a category dynamic page, so the 1st dataset is a dynamic dataset filtered automatically for that category.

If not, I suggest you create one from the list of items collection. Connect this dynamic dataset to a repeater of items. This will automatically filter your collection by a specific category. Then connect another dataset to connect to your second collection of category titles and connect it to a repeater (category index).

Thanks for your quick reply, I’ve figured out how to add a second dataset to the page, I’ve only just added the database part of the website, so hadn’t noticed that there is now a database section in the add button.

Thanks

Gavin