AnsweredAssumed Answered

Counting Duplicate Values at Creation

Question asked by sam.gedert on Sep 14, 2018
Latest reply on Sep 20, 2018 by beverly

Good morning FileMakers,


I have a field, we'll call it FIELD.  I allow duplicate values in this and I would like to create another field ( DUP_COUNTER ) that is a serial number that increments up one everytime a duplicate value is entered.  I'd like to do this in a calculation or an auto-enter rather than during an open script or script trigger. 



FIELD                    DUP_COUNTER

VALUE_123          1

VALUE_123          2

VALUE_123          3

VALUE_999          1

VALUE_123          4

VALUE_999          2

VALUE_444          1


I'm using FM 17 on a mac and hosted on 17 Server as well.

Let me know if anyone has any ideas.