Hiding duplicates from a view

[isobelhoward]

Hi there,

I have a database with form entries, and I want to create a view which shows just one entry per email address. I want to show whichever one has the most recent submission time and hide the other from this particular view, but not delete it entirely. Everything seem to suggest the dedupe extension, however, this just deletes the record rather than hide it.

Thanks!

[Stephen_Orr1]

Hi @isobelhoward,

There's currently no way for a record to know info about its surrounding records in the same table (see my product suggestion here for more info: https://community.airtable.com/t5/product-ideas/all-formula/idi-p/155436) and therefore something like a formula field to filter a view that could evaluate submission dates for given email field values across records in the same table is not currently possible.

The Airtable way of achieving this is through linked records, table hierarchies, and roll-up field aggregations.

The simpler, albeit less ideal, option is to group by email address and sort by submission time to have the latest submission appear at the top or bottom of a submitter group.

Hope that helps!
-Stephen

[kuovonne]

The key here is identifying which record is the most recent submission.

If your entries are created with a form, you could run an automation on form submission that sets a {Is Most Recent} checkbox for the new submission, and clears the checkbox for any other records with the same email address.

I wrote a detailed explanation in Kuovonne's Guide to Airtable.