Oct 12, 2022 04:43 PM
I’m trying to write a formula to detect if there is a duplicate record, ignoring a few columns.
I’m not very good with formulas, but I imagine it’d be two if statements, which if correct I’d like it to highlight the row red? There’s probably a more intuitive way. I think with the if statements it might not pick up duplicate numbers that are on the same row?
Oct 12, 2022 11:00 PM
Hi Xavier, could you provide a screenshot of your data with examples of the duplicates you’d like noted highlighted? Would love to help but don’t have enough info
Oct 17, 2022 02:57 PM
Here is a screenshot of an example database. In this example there are two duplicate entries for Kate Bush (ignoring the PC NO and Paid columns). I’m trying to come up with a formula that would detect this duplication and highlight it red.
Oct 21, 2022 12:36 AM
Roger that, thanks for the screenshot
I’m afraid that this gets slightly more complicated as records in Airtable cannot refer to data in other records unless they’re linked, and so you’d need to have all your records linked to a single record in another table and create a formula that checks for duplicates from there
At that point, since you’d probably use an automation to link the records up, you might be better off creating an automation that would see if there are any other records that share the same
Name value and if there are, to mark the triggering record as a duplicate instead really
You’d be 90% there and could set it up yourself in 5 minutes