Skip to main content

How to create a duplicate record field

  • September 13, 2020
  • 1 reply
  • 0 views

Forum|alt.badge.img+1

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

JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • 1110 replies
  • September 15, 2020

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.


Reply