Aug 13, 2019 05:49 AM
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!
Aug 13, 2019 06:21 AM
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.
Aug 20, 2019 10:00 AM
Are you trying to create a report of sorts where you see all the books by a given author, but you only see their username and email address listed once for their group of books, instead of seeing it for every record? If you have a Pro account, you might consider building a page using Page Designer. That gives you far greater control over what and how the data is displayed compared to Airtable’s views.
Aug 20, 2019 10:35 AM
No, I just want a view where regardless of how many records I have from the author, I’m able to see each author’s name and email one time.
Aug 20, 2019 11:43 AM
One way to achieve that is to make a custom field that concatenates the name and email into a single string, group by that field, but leave the field hidden. You’ll see the name and email in the group header, and nowhere else.