Grouping data by email/user (Glide Pages)

[Jeff_Hager]

Take a look at this and let me know if you have questions. The trick is to mark each row with a boolean when it’s the first occurrence and then filter a list by that boolean. That list will then show each name only once.

Is there a way to filter duplicates from an inline list?

This is what I would do if you wanted to keep everything within glide. First I would recommend having a RowID which will give every row a unique value. This will become important in a little bit. Then I would identify a unique value for each contact, whether it’s a name, phone number, email address, or something else that you know will be in each duplicate row, but is still unique only for that specific person. Let’s assume Name for now. Create a self relation that links the contact’s Name …

Then you will also need a multiple relation linking the leads table to the activity table. When you click on a lead in your list, you can display all related activities by adding an inline list sourced from that relation.