Help

How to create a duplicate record field

798 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Claire_Conza
6 - Interface Innovator
6 - Interface Innovator

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

1 Reply 1

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:

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