Show only unique data from lookupRecords

Ask for Help
1

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

Regards,
Cleven

1 Like
2

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

set(Order_Line_Items.lookupRecords(Customer=$Email).Product)
1 Like