Unique value in interactive filter

[Appy2]

Hi Team,
We need to create a interactive filter which should display unique value from the table, in our we have created a custom table which stores data in below format

Name	Group
ABC	TestGroup1
ABC	TestGroup2
ABC	TestGroup3
BCD	TestGroup4
BCD	TestGroup5
BCD	TestGroup6
IMG	MyGroup1
IMG	MyGroup2

And we need to create interactive filter which will display unique value of name in the filter (i.e filter will display only ABC,BCD and IMG in the drop down list)

Let me know if anyone implemented such kind of logic.

Thank you!!

[Mark Manders]

What kind of fields are these? If it's string fields, it will be difficult, but if it's a reference field, you should only see the unique value.

[Appy2]

Hi Mark,

Field "Name" is a string field. Is there any way to achieve this requirement?

Thank you for your help!!

[Mark Manders]

A string field is never seen as unique in regards to filtering. You can do a 'group by' on a list, but not use it as unique in an interactive filter, because it's coming from different records. ABC simply exists 3 times, so it will be shown 3 times. If you could make it a reference, you will have it as a unique value and it only exists once, on 3 records. The system is now trying to filter on name and each name is seen as unique, even though we read it as the same.