Finding Duplicate Records

[LucasTT]

Hi everyone,

I'm very new to Airtable and I'm trying to get an automation to check a column called "Vehicle Registration" and a column called "VIN No" and if either of these two columns match with an older record, both the new record and the old record are either highlighted as duplicates, or a column with a checkbox is automatically ticked to show it's a duplicate record.

What would be the best way to go about this?

Thanks in advance.

[dilipborad]

Hello @LucasTT 

Duplicates, there are different ways and maybe it does not exactly match your requirements but if you dig it more OR if you have more technical programming knowledge then you can achieve the same results that you need.

See this solved Show if a record is duplicated 

If this still has not solved your problem then reply with proper details of your steps.