Attribute Rule to check for duplicates on a numeric field

Question

I'm trying to create an attribute rule which would alert me of a duplicate value being entered in my dataset. The field I want to identify duplicates in is formatted as numeric and every expression I try I get an error expecting string values. I've been unsucessful at mofiying the code to work. Any Ideas?

Robert_LeClair · Answer

Ah - you're right!  I did find an Esri Community post that uses Validation Rules for duplicates.  You can read about it here.

avonmoos · Answer

Part way there...There's a note on that workflow stating

Note:
The attribute rule to identify duplicate field values in the attribute table only works for a text field.

The only work around I could find for a numeric field would be to create an additional field and setup a rule to calculate my numeric value over as text and then run that workflow. I rather not have a duplicate field but may have to go that route.

Robert_LeClair · Answer

Yes!  There's a great Technical Support article here that describes the exact workflow to use.  Good luck!