Dynamic FIlter Picklist Options
1. How to show dynamic values in the filter according to the values of a particular column from the list view?
a. Field Datatype- Formula Field(Text)
2. Need to remove duplicate values from the filter drop down.
Any help would be great.
Thanks in Advance.
a. Field Datatype- Formula Field(Text)
2. Need to remove duplicate values from the filter drop down.
Any help would be great.
Thanks in Advance.
Tagged:
1
Categories
- 7.9K Questions
- 926 Ideas
- 220 Discussion Categories
- 178 General
- 9 Community Feedback
- 3 Community Info
- 18 Knowledge Base
Comments
It sounds like you should be able to accomplish this if you create the filter options manually using "rows in a model" as your filter source:
- Create a new model on the same object to source the options for your picklist.
- Make this new model an aggregate model and include a count aggregation on the Id field and group by the formula field (the field you want to show up as the filter option list).
- On the original model, for your filter's source choose "rows in a model."
Does this sound like what you're trying to accomplish?Here's some documentation that you may find helpful: