I have connected a Collections List to a Products database. And then I have placed checkboxes inside Collections List Items. I have connected the text of the checkboxes to a field inside Products called Location. Location does not contain unique values, e.g, there’s more than one ‘South Africa’ Location.
I would like the checkboxes not to show duplicates. Instead of 3 'South Africa’s, I would like to show 1. How do I do this?