Multiple Filtering of One Dataset on Multiple Repeaters?

Ask the community
,
1

I am designing a website for a local diner. I want to do their food menu using multiple repeaters. Ideally, I would like to have a single database. I would also like to include various fields for filtering purposes. I have attached a diagram of what I want to achieve on a single page.

For example, on their breakfast menu they have Skillets, Omelets, and Pancakes. I would like to create a column in the database where I can enter these categories and then filter these on individual repeaters on the same page.

Repeater 1 on the diagram (below) would filter and show only Skillets. Repeater 2 would filter Omelets, etc.

Is this possible using only one Dataset/Database?

1950×1656 158 KB

2

You can do this with just the one dataset as you would be linking each individual text box element on each repeater yourself through the Wix Editor dataset link.

Although you might be better working with the multiple datasets and collections instead, see here for more.
https://support.wix.com/en/article/about-displaying-content-from-multiple-database-collections-using-datasets
https://support.wix.com/en/article/about-connecting-multiple-database-collections
https://support.wix.com/en/article/about-reference-fields-in-database-collections
https://support.wix.com/en/article/about-referencing-multiple-items-in-one-field
https://support.wix.com/en/article/working-with-multiple-item-reference-fields

Plus, have a read of these previous forum posts about querying them.
https://www.wix.com/corvid/forum/community-discussion/help-with-querying-referenced-fields%3fpage%3d1%26dl%3d5c33c1c95516de01d29e8d88%252f5c17f9493aeebe016fec021c%252f1
https://www.wix.com/corvid/forum/community-discussion/query-many-collections-with-reference-fields