In August 2018, I asked the following question.... is it similar to your situation?
Let's say I have 100 entries in a Dataform that has a field (named MYTYPE) that I want to use as a "dynamic filter". For example:
- I want to display a dropdown consisting of the UNIQUE values of the field named MYTYPE.
- When the user chooses one of the dropdown options, I want a filter to be applied that shows only the entries where the field MYTYPE contains the value selected by the user.
By the way, I don't know the possible values of the field MYTYPE, because the user enters the values themselves.
Can this be done?....
I never got an answer, but I am hoping you and I might be able to combine our efforts for a solution.