Help

Create a view based on duplicates

Topic Labels: Formulas Views
Solved
Jump to Solution
2125 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Dalene_Rovensti
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, I'm stuck as to what to do here. Hoping someone can help. I THINK a formula should be able to do this? Essentially I want to create a view that shows me only the records that have a zip code that matches a zip code of another record. I was playing around with the DeDupe app, but that merges records, which isn't what I want. I want to keep the records, but I want a view that lets me easily view where the duplicates are. Screenshot attached to help communicate what I mean. Thanks! 

Screenshot 2023-06-21 at 11.51.41 AM.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try:
1. Create a new table called "Zip codes"
2. Create a linked field to "Zip codes" from your current table
3. Copy all the values form the "Zip" column and paste it into the linked field
4. In the "Zip Codes" table, create a "Count" field, thus giving you the number of records that have that zip code
5. In your original table created a lookup field to display the "Count" field you just created
6. Create a view that only displays records that have a lookup field value >1

This should do what you're looking for I think

See Solution in Thread

4 Replies 4
Sho
11 - Venus
11 - Venus

hi,

How about using this extension?

Dedupe Extension | Airtable Support

TheTimeSavingCo
18 - Pluto
18 - Pluto

Try:
1. Create a new table called "Zip codes"
2. Create a linked field to "Zip codes" from your current table
3. Copy all the values form the "Zip" column and paste it into the linked field
4. In the "Zip Codes" table, create a "Count" field, thus giving you the number of records that have that zip code
5. In your original table created a lookup field to display the "Count" field you just created
6. Create a view that only displays records that have a lookup field value >1

This should do what you're looking for I think

Yes! I never would have thought to do it this way, but I think it should work—thank you!!

No, I mentioned above I had already looked into that extension, but I don't want to merge the records, only identify them.