Filtering by multiple dropdown fields - Wix Code beginner

Hi everyone, I really hope someone in here can help me and I will be so grateful as I have spent too many days trying to get this sorted!
So, I am setting up a database with one search bar where you can search by player name (I have sorted this already and it works) and then I have 7 dropdowns that can be filtered.
I have started to write the code for each dropdown and it has been working fine, but, I have now realised that only one dropdown will work at a time. However, I want the dropdowns to work together so that the results shown are the results when multiple dropdown selections are selected.
I am very new to code but is it possible someone could explain the best way to use code so I can filter by multiple dropdowns at the same time? All of my dropdowns only require text.
Thank you for anyone who is able to help!

There are previous posts and tutorials out there already that can help you with your issue.
https://www.wix.com/corvid/forum/community-discussion/help-with-multiple-dropdown-s-to-filter-a-dataset-and-populate-a-repeater-with-results-using-wix-code
https://www.wix.com/corvid/example/search
https://www.wix.com/corvid/example/cascading-form
https://www.youtube.com/watch?v=EhXed0u6wh0
https://www.youtube.com/watch?v=r0DLqkRDJ34
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-WITH-MULTIPLE-FILTERS
https://www.vorbly.com/Vorbly-Code/WIX-REPEATER-MULTIPLE-FILTERS-WITH-RESET