How do I sort and filter to show a single entry if multiples exist?

I have an Airtable with thousands of rows, all of them with unique links. Each link has an associated author who has a Username and Email.

In a view, I’m grouping by Username and then I see multiple entries for that same Email. That’s fine, but my goal is to see only one entry for that Email, for that Username, in this specific view.

How can I go about achieving that? Thanks!


I could be wrong, but I believe this is a challenge because unlike SQL databases, we don’t have a UNIQUE constrictor in the filtering feature (that I know of).

A lot has changed since 2017 but I think @Chester_McLaughlin nails the answer here.

Unfortunately, I think the only way to do this is with an API process that would perform the UNIQUE filtering process and update an adjacent table with the results.

1 Like