I do not have a coding level. The last time I wrote any code professionally was over 40 years ago. I do not want to have to write code unless it is unavoidable, and even then only if it is simple and I can basically copy and paste from someone else.
So, are you saying that Wix does not support out of the box the trivial use case of populating a dropdown from a collection, and using the selected vaue from the dropdown to filter another collection? Even though there are dialogues to connect a dropdown to a collection? What are they for if not to do that sort of thing?
Of course I do not insist that the user uses a dropdown. The use case is that the user can select the author that they are interested in, and the repeater displays only the rows form the collection that have that author in it. It is easy to hard code the filter, but that is not a generic use case like we need. It is easy to hard code the options in the dropdown, which looks like a proper solution to the user, but means we have to manually maintain the content of the dropdown, which is not good.
We cannot use an ordinary text box, because Wix does not (for reasons I cannot comprehend) support that use case.
So, is there an approach that we could use that satisfies the use case, using any controls that are available? Or are we stuck with having to build static, or semi-static web pages with limited or no filtering capability for the users?