Show only unique data from lookupRecords

Hi, I am creating a sales + CRM database from existing Digital Sales Template (Loading... - Grist).

Under CUSTOMERS Card, there is this "All Products“ that shows all products purchased by a particular customer. Is it possible to have it show only unique data instead of all (with duplicated data as well)?

Kindly advise.
Thanking in advance


1 Like

Yes. The current formula returns a list of Product records. You can use a Python set to remove duplicates:

1 Like