I am building a web app with the sole purpose of finding people who share similar traits to yourself.
On sign up, users select their:
country of birth
interests (they can have between 1 and 30 interests that they select from a list of 30 predefined interests)
The current user can then go to the search page (which initially just shows a list of every user in a repeating group). They can then choose to filter this by the 7 filters mentioned above to find people with the same gender and/or same hair colour and/or same country of birth and/or same eye colour and/or same school and/or share interest 1 and/or share interest 2 and/or share interest 3, … share last interest and/or same university.
I was wondering how to achieve this without having 60+ conditionals on my repeating group for if that particular search filter is empty or not empty alongside every other filter?
Thanks for that, I read your linked post and it said if you have ~20k records there is no point using search and autocorrect feature?? The site I’m building would eventually (if successful) have ~20k records.