Skip to main content

How to create a duplicate record field

  • September 13, 2020
  • 1 reply
  • 24 views
C
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

      This topic has been closed for replies.

      1 reply

      JonathanBowen
      Forum|alt.badge.img+18
      • JonathanBowen
      • Inspiring
      • 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.

      Terms & ConditionsAccessibility statement