Filter an auto complete to remove doubles?

I have a database column with product names.

On my page I have setup an auto complete textfield.

Because there are multiple records with the same name I see lots of the same names in the auto complete list when I start typing.

Is there a way to filter the auto complete list to not show the same product name multiple times?

You can use the DISTINCT option in the query builder, to only return unique records from the query:

1 Like

Oh wow, that was easy :roll_eyes:
Thanks!