Need help with multiple filters on repeating groups

[bumish1]

Hello, I am making a library app to display books & their details. The database is community managed, as in users can add books to the library. These books are then moderated by a group of mods.

What I’m having trouble with is getting the main library repeating group to filter properly.

How it’s set up:

• each book has a type (audio, eBook, or webnovel) set as a yes/no values.
• each book has a genre (14+ genres and subgenres) all set as yes/no values.

What I want to do is have a repeating group that displays a list of all of the books in the library at load, but can be filtered to show books with only the exact combination of book type and genre.

Exe: A book that has both an audio book and eBook format, with the both fantasy and science fiction genres set as yes.

I am willing to change the database structure, as there is only about 300 books now and I can go through and change them, or have mods do it.

Is there a way to do this?
Here’s some screenshots.

Thanks in advance! I hope to get this working soon.

[SerPounce]

There is a MUCH easier way to do this:

1. Create an option set “Type” with your 3 types.
2. Create an option set “Genre” with your 14 genres.
3. Write a little recursive workflow so you don’t have to do it manually to add the Types and Genres to your books. You can also do this manually if need be.
4. Add a custom state to your page for Type and Genre and make them both lists.
5. Add a workflow to add to the user selections to the respective custom states when user wants to filter.
6. Then your filter on the RG would simply contain 2 constraints, 1 for each option set.

[bumish1]

@SerPounce

• Create an option set “Type” with your 3 types. - Done
• Create an option set “Genre” with your 14 genres. - Done
• Write a little recursive workflow so you don’t have to do it manually to add the Types and Genres to your books. You can also do this manually if need be. - how do I do this?
• Add a custom state to your page for Type and Genre and make them both lists. - how do I do this?
• Add a workflow to add to the user selections to the respective custom states when user wants to filter. - how do I do this?
• Then your filter on the RG would simply contain 2 constraints, 1 for each option set. - how do I do this?

Sorry to bug you but I still need a little help. I haven’t quite figured out customs states or how to use them in workflows or repeating groups.