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.
Can this be done?....