How to create a duplicate record field

[Claire_Conza]

Hi lovely airtablers!

Just a quick and simple one I hope? How would I create a field that automatically denotes whether a record is a duplicate on a single field only?

I have orders that share the same order code and I’d like to know which line items are part of the same order. This duplicate field could be a checkbox or a single text field and should denote all records that are part of the same order code.

Any help would be gratefully received.

Thanks

Claire

[JonathanBowen]

Hi @Claire_Conza - not sure what your workflow is here - can you expand a little? Are you choosing a line item record (with an order code) and wanting to find other line items with the same order code?

I wrote a script for a similar thing here:

Script to Link Same Table But Only Find Duplicates? Scripting app

This is an alternative approach, but might not be what you are looking for. It identifies duplicates, but doesn’t show which records are connected as duplicates. let applicantsTbl = base.getTable('Applicants'); let applicantsQuery = await applicantsTbl.selectRecordsAsync(); // make an array of all of the emails let emails = applicantsQuery.records.map(record => { return record.name }) // filter to get emails which are duplicates of another let dupes = emails.filter((item, index) => email…

Might need some reworking, but it could be tweaked for the above scenario I think.